How to use IF, AND, OR Functions in Excel (हिंदी में) | MS Excel IF Function | IF Formula in Excel
HTML-код
- Опубликовано: 27 сен 2024
- In this you will learn How to use IF, AND, OR Functions in Excel. You can also learn complete Digital Marketing Free through our RUclips channel in Hindi.
Also it helps our client in discovering ecommerce product to boost and shot up the sales and make big profits .
If you are the one who want to make big money in digital marketing then it is a must tool.
Best Web Hosting Service Provider
1. BlueHost - bluehost.sjv.io/YgVkOj
2. Hostinger - www.hostg.xyz/...
Best SEO Tool
1. Semrush Pro Trial - semrush.sjv.io...
2. Semrush Guru Trial - semrush.sjv.io...
#msexcelcourse #iffunction #hiteshgupta
Thank you so much sir 😌
Bcuz of u thousands of students can learn professional skills only for free
, Once again thank you 😊
Please play back speed *1.75 kar dena nahi to irritate ho jaoge
mene toh 2x rakhi hai aur fir bi ho jata hu
Sekh liya ho to thank you bol do sir ko...🤔
@@navneetyadav1553aap to married lag ri ho..aap q Sikh ri ho😅
😂😂
@@md.alikhan8238 Education ki koi age limit nhi hoti bro thoda samjha Karo ❤
Hlw sir you are the best trainer I'm amazed u made learning so simple easier with fun thank you so much
Bahut hee accha se samjhaya jata hai, bahut bahut dhanyawad sir 🙏🙏🙏
What a course really nice 👍
Thanks 😊
Respect for your content 🙏
Thanks 😊
Thank you for this useful information 🙏
AMAZING SESSION SIR JI
Thanks 😊
Thankyu sir really understanding vedio...❤ sach me aap achi vedio bnate..
Thanks sir for this online course
Most welcome
Your lectures are so helpful, sir !
Glad to hear that
Learning amazing things bcz of you. Thank you
Glad to hear that
AMAZING COURSE . YOUR TEACHING STYLE IS GREAT . THANK YOU SIR
Your Welcome
Mast video acche se smj aaraha h
Thank you so much sir, your teaching skills are really appreciable,, but sir I have some confusion in the part of grade, there is results something different
Please sir giving easy formula for result
Thank you sir Apne ki Bari problem solve krdi❤❤
Your welcome 🤗
Thank you sir!
If I learn this IF,IF AND there will be any use for working in a company
agr bnda percentage dekh k likh dy to kafi time bch jaye gha 😅
Mja aa gya sir jee
Thank you so much sir 🙏🙏
Most welcome 🤗
Thanks a lot sir..🙏🙏
Most welcome 🤗
Sir my result and grade formula is not working so any solution for it???
Very important videos sir
Thanks and welcome
Sir suplimentry ka liye kese formula put karnge
Thank you sir 🙏
Most welcome 🤗
Highly helpful...👍
Amazing sir❤
Thanks a lot 😊
U r the best
HELLO SIR MENE YE APPLY KIYA PR YE ISME LG HI NI RHA ERROR BTA RHA H PLEASE HELP ME K MAI KHA GLT HO RHI HU =IF(AND(D3>=33,E3>=33,F3>=33,G3>=33,H3>=33),''PASS'',''FAIL'') AND THANK YOU SO MUCH FOR TEACHING US UR WAY OF TEACHING IS VERY GOOD.
THANK YOU SIR JI
Most welcome
Bout Pasand aya g
Thanks 😊
EXCLLENT WORK
It is really helpful video.
Thank sir
Helpful video 🎉
Thanks a Ton Means a Lot
Thanks sir
So nice of you
If and function apply hogya tumhara?
Sir can we use IF for whole row and colum Please
Actually i am try to put this formula in this to do like i want to apply two conditions on sat and sun will mark w/o and rest day P
2x m dekhne wale like kre 👍☑️
Nice
Thanks 😊
Thank u for sharing the video. I am not able to get IF IF formula correctly. Showing ERROR as #NAME?. Please could you rectify my error for below formula:=IF(Q3=FAIL,"F",IF(N3>=75,"A+",IF(N3>=60,"A",IF(N3>=45,"B",IF(N3>=35,"C")))))
if if wali sari example solve k doran screen blurr hi rhi kuch nzr nhi aya
❤❤
Sir Javascript se toh easy hi hai yeh 😢😢
Sir apne 39%vale ko pass kar rakha hai or 49 % vale ko fail asa kyu
Because 49% wala ek subject me fail hai dhyan se dekhe... hindi me uski marks 29 hai ... or sutra ke anusar 33 no ke niche wala fail hai
Summary:
IF use
IF(F12>=33,"PASS","FAIL")
IF AND use
IF(AND(C2>=33,D2>=33,E2>=33,F2>=33,G2>=33),"PASS","FAIL")
IF OR use
IF(OR(C2
Sir mai end meri remarks dena cha raha hu jaise jiska A+ aya usko excellent,C aya toh very poor, usi formula se jisse grades diye hai lekin error show ho Raha hai har baar.
Ms excel sikh k kuch kam milega kya
If we learn only one rule that would be enough bcz all are being used for same purpose
Hello sir meri grade column m value false aa rahi he kyo plz give m suggestions.
Need 4x
Sir my result formula is not working plz solution
Sir yeah grade waly mn error ata hai formula mn value Ka puchta hai JB Kay ap Jha seikha rhy hai wha enter krty hi grade c ajata hai JB Kay yha value b Puch Raha yh smj ni aya
Why not only IF?
SIR IF IF NAHO HO RAHA HA PLZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ CLEAR THIS
Bhai phir se try kro
My if and formula is error what do i do plzz
sir sarre function krvao yeh toh 10 percent hai bus concatinate, left toh krvaya he nhi
SIR IF IF FORMULA IS NOT WORKING ON MICROSOFT 365
Hi
sir khudi pass or fail likh skty itny formula lgany ki kia zrort h?
To save your time when you get many students marks what will you do you?will you write all of them pass or fail or just you can write the formula for one and apply all for the same.
Sir if and wale concept me parsentage me sab 33se above he fhir vha fail kyo aaya
Sir muja ap ka "IF AND" aur " IF OR" ma koi pata nai chala ka ap kia samjhana chah rahe ha. Mara khiyal ma ap ko khud b clear nai ha ka dono ma kiya diff ha.
Why using IF AND IF OR?
Tooo difficult kuch samjh ni aya😢😢😢😢😢
C programming mein padhaya tha ye sb...isiliye condition smjh aaya ..
I applied last formulae if if one wala...yhn likha aara h....u have applied too many argument that for this function... What should i do...and where i m wrong... Olz guide
Same problem I'm facing in IF AND function........ it's giving an error
Pls help me if u have sorted this error
@@raoaman1364apply formula properly,
At the Time of applying condition don't use double inverted commas sign
Use this formula it is easy and you will easily understand it and there is no error in it.....
= if (L8 >= 90,"A", if (L8 >= 80,"B", if (L8>=70,"C", if (L8 >= 60, "D", if L8>= 50,"E", "F")))))
19:20 39.2 wala pass or 49.4 wala fail kaise ho gya.
EXACTLY
Kyu ki 39.2 wale ke kisi bhi subject me marks 33 se kum nhi the dusri taraf 49.4 wale ke hindi me 29 hain mtlb 33 se kum isliye wo fail h
sir it is coming you enter too many arguments for this function
Sir 49 toh pass hota Hai na I m right ❤
Last vala nahi hua meraaa 5 brr try kia😢
49.4 PAR PASS HONA CHAHIYE ISME ERROR H PLZ SOLVE OTHERWISE DATA IS WROUNG
Student E has 29 marks in Hindi. He has less than 33 marks in that subject hence why he has failed. IF AND statement is applied to individual subjects, not the overall percentage.
sir ek problem ari ha ma safe formula dalra hu lekin har value ka result fail hi nikal rha h
facing same issue, I don't know even how to resolve it.
Or and me galti kr diye🙂aap
49% kaise fail aa raha h sir, vo toh pass hona chahiye na
Kyuki uske hindi mai 29 marks hai vo hindi mai fail hai pass hone ke liye minimum 33 marks hone chahiye thai
PR wo 49.4% ke baad bhi fail😅
If or ka kya fayda...ye kaam toh if and me bhi hota hai 😅
information thik he lekin dimak bhot kharab kiya
Practice makes men perfect
Achha
CLASS 8TH COMPELETED
lol
Thanks u sir
All the best
Sir less than ka formula muzhe kuch bhi samzh nhi 😒aya? =If (or (34
Jab vo values true hai to fail qu ana chahiye sir . Or fail hai to true qu ana chahiye ? Jab ki value to same hi nikalni hai app less than karo ya greater than karo 🤯
If , if and, if or, if if ye 4 condition ku h 1 baar me hi to result aa gaya abb baar baar result ku nikal rahe ha
SIR IF OR MAI CONDITION MAI EQUAL TO KA USE KYU NHI HA
IF(OR(C2
So difficult concept explained in simple language! Great learning experience!!!! Thanks Sir.
Most welcome!
Sir IF and formula is not working, pls help
Kuch samaj nahi aya ki result nikal ne ka 4 tarika h
SIR POWER POINT KA FULL COURSE LAYE
Can we also calculate this with the help of the total column
Bohat hi kam ki chez ha mashallah
Sir kya and formula greater then ke sath lagna hai ya less then ke
Kai log bolte h greater then ke sath lagta h
Answers me
Sir mai daily aapki hi videos se sikhta hu,, thanks sir ji itna acha se btane ke liye 😊
Your welcome 🤗
Sir I want to ask which MS Excel version u r using.
Just appreciate him then he only reply you 😂
Sir condition apply karne se acha to mey khude dekh k fail,pass typing kardu, time v bachega
Sir aap bahoot acha se detail me samjhte hain bahoot acha lgta hai apaka teach ka tarika
Thanks ☺️
everything is thax giving but sound is little bit low....I need to use head phone
if if wala formula mere PC me error bta rha h sir koi solution btaye sir
Sir mera if (and) wala postion red dikha raha hai enter kerne ke bad
Sir Har jagah certificate mangta hai uska kya kare
Wonderful✨😍.. Course...
Thank you🙏❤
Thanks and welcome