Excel Logical Functions IF AND OR NESTED IF in Hindi By TeachToeach

TeachToEach shows you “ How to use Excel Logical Functions - IF AND OR Nested IF in Hindi. A Logical function of excel is make your task so easy whenever is you work in excel with the condition.
How to use excel logical function in excel is always a difficult task to users. So , This video solve your problem in a minute. Whatever you do either is it a simple sheet or making dashboard, this will help you a lot.
You do not believe how effective these If, And, OR formulae in itself. Let’s start how to use and or function in excel 2010 2013 2007.
Sometimes we use excel And OR function in one argument.
Please watch and read excel if and or function tutorial step by step.
(1) IF Function : The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.
How to use IF function in excel
Syntax of IF Function : IF( condition, [value_if_true], [value_if_false] )
(2) Nested If Function: The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. How to use NESTED IF function in excel.
If Nested Formula is When we use more than 1 IF we called as Nested If.
(3) OR Fucntion : he Microsoft Excel OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.
How to use AND function in excel
Syntax of IF Function : OR( condition1, [condition2, ... condition_n] )
(4) And Function : The Microsoft Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
How to use OR function in excel
Syntax of IF Function : AND( condition1, [condition2], ... )
Please subscribe my channel “TeachToeach” for more videos of excel tutorial in hindi.
For More Videos:
1) Reverse Lookup Formula Vlookup with Choose Function in Excel - • Reverse Lookup Formula...
2) How to use Vlookup formula in Excel 2013 Hindi - • Vlookup Formula in exc...
3) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel - • 2D-Two Dimensional Loo...
4) How to Lock individual Cell in worksheet of excel - • How to Lock individual...
5) How to consolidate multiple worksheets into Pivot Table in Excel Hindi - • How to consolidate mul...

[@TeachToEach]

Excel और VBA सीखने के लिए हमारे नए चैनल को जरूर सब्सक्राइब करे इस लिंक की मदद से czcams.com/channels/050KnRA2lffzEsB1h8uQCw.html , एक्सेल की क्लासेज शुरू हो गयी है शुरुआत से , बहुत जल्द VBA भी शुरू होने वाला है |

[@saikamal1000]

If and formula not working properly

[@AbdulHaseeb-ej4gk]

Thank,x sir this is very easy to understand this method after watching your video Great work.

[@TeachToEach]

Thanks for the comment Abdul

[@Azhartheofficial]

Lovely teaching yaar very clearly i got to undsdt thankew so much ur amazing god bless u...👍👍👍

[@dr.surabhisrivastav29]

Very useful video and you have explained this in a easy manner. Thank you for sharing

[@TeachToEach]

Welcome Surabhi Ji.

[@ishubisht766]

Hi there!
Thank you so much for this video. You helped me understand the formula so clearly and comprehensively that I otherwise wouldn't have learned from the so called Excel teachers on CZcams. Please upload some more videos with this awesomely innocent voice! Your biggest fan!

[@TeachToEach]

First ...Thanks you sooooo much for this long comment . You wrote so many things which makes me happy.
Second ... You also wrote about my voice .. By profession I am excel expert But by hobby i am a mimicry artist too..Thank for noticed my voice.
Please share if you want video on any excel topic.

[@KaranKohliVlogs]

Thank youuuuuuuuuuu so much to share your knowledge with us. You videos help me a lot to learn new formula. :)

[@TeachToEach]

Your Welcome

[@pankajsaini3086]

Superb dude... I was looking for a solution of my work and just got it... Thanks... Keep it up

[@TeachToEach]

Thanks for the comment Pankaj ji.

[@ashutoshnazare945]

Very easy way to teach. In short time teached 3 formulaes. Sir add video of If-Vlookup-and combined formulaes

[@avchandrakant3615]

Thank you Sir jee for simplifying Excel. Very helpful . Keep it up

[@TeachToEach]

Thanks Chandrakant, I m not a sir .... I m a very young guy My name is Ashish Rawat and you can call me "Ash" My nick name.which i like too much HAHAHA

[@aishwaryamahapatra706]

Thanks for explaining formula in a simple way ..

[@TeachToEach]

Your welcome

[@umeshn7513]

Excellent sir, you have very good teaching skill, thank u very much,

[@TeachToEach]

Thanks for these precious words for me Umesh.

[@nurasad9797]

Very helpful, thanks a lot...

[@ImranKhan-fc3ri]

Super bro bahut ache se samjhaya bhai tune

[@naveenchkaravarthi7869]

thank u bhai, u had solved my problem which I am struggling for a long time. I have subscribed and hit the like and bell.

[@TeachToEach]

Thanks for the subscribe

[@soobrataguha14]

Sir - Thanks a ton. The way you teach is very nice. God bless. Must share with my friends...//

[@TeachToEach]

Thanks for the comment.

[@mahfujalam8255]

Thank u sir your good effort, amazing sir 😍😍

[@upsctak6067]

Master ek no brother app to legend ho

[@sumitchoudhary8857]

It helps me sir thank u.

[@happiebrar6807]

Luv uh ♥️ I’m in studying excel in Canada.. but your way explaination is simple and easy

[@TeachToEach]

Welcome Harpreet

[@sonimohitkadel2636]

2:24

[@venugopal-vt9wk]

I work in retail industry & this is very usefull for me thanks!!

[@TeachToEach]

My pleasure @ Venu !!! Thankyou so much

[@krishnajitechnicaleducatio6903]

czcams.com/channels/4S6Ej0lytw6CVJEmahJuFw.html

[@sonalmestry4729]

Teach to each is very easy and effective way to get excel

[@chandrapalrajput6269]

This video is very useful sir..Thank you so much..🌸🌸

[@TeachToEach]

Your welcone Chandrapal

[@abhijitroy8041]

Wonderfully explained. Thumps up my dear friend..

[@TeachToEach]

Welcome Abhijit Ji

[@cvishwakarma451]

very good explanation sir!

[@satyendrasingh9300]

Very nice easy way to understand

[@puneetvij8433]

सीधी बात नो बकवास|
Teach to each एक दम clear है| : )

[@TeachToEach]

Its always good to see anyone who commented on each video.

[@bijayakumarsahoo6300]

Very good describe.

[@dharitrisahoo3361]

Good teaching, well explained

[@TeachToEach]

Thanks Dharitri

[@rosehayat2208]

Oh, thank god, I was really frustrated regarding the logical test, I was unable to understand the concept of the word logical test in the function, until I came across your video, you just cleared it in one word, condition, lmao, silly me, thanku, sir for explaining it.

[@ankitrajpoot2870]

What a video bro...

[@sammu28]

Nicely explained. Thanks

[@TeachToEach]

Welcome

[@kalpeshkakuste1796]

Thanks for this video.
Very useful

[@TeachToEach]

Welcome Kalpesh Ji

[@vasimshaikh3581]

Wow It's Also Very Important.........

[@TeachToEach]

Thanks

[@sharathkk1807]

Superb 🤝

[@monarchsunion3485]

Very nice and useful

[@dinesh53752]

Thank you so much man

[@rajukc8878]

Gud sir thank u so Nice n clearity lean...

[@TeachToEach]

Thanks for the comment Raju

[@prabhakarkumar5639]

Great Sir !You have very good teaching skill, thank u very much,

[@TeachToEach]

Welcome Prabhakar

[@williechristian9135]

Thank you! Too good.

[@TeachToEach]

Thanks for the comment Willie Ji.

[@rajanikumari957]

Very easy step u thaught sir...thnx

[@TeachToEach]

Thanks

[@codinglife128]

Thank you sir nice tech 🙂🙂🙂🙂

[@motivation.rahul64]

Very nice good teach sir ji

[@TeachToEach]

Thank You

[@vk6456]

Thanks a lot sir 😊

[@avipriyanka1998]

Channel name bhut achha lga bhai😊

[@aashirmehmood4543]

Thanks Brother u saved my day

[@TeachToEach]

Please check your inbox Aashir ji has been sent to you.
Dont forget to Like, Comment and Subscribe our channel with bell icon and get new videos notification on your mobile.

[@abhaypadhan4666]

Nice video.

[@allphamarine9346]

Ashish Very nice video
How to use IF, OR AND FUNCTIONS in more than 3 conditions, like I want to compare 2 prices, n there different scenarios if when 2 prices are equal take one value (from one perticuler cell), if both prices are not equal take 0, if both price are equal but both price are higher than 3rd price take 3rd price, if both prices are equal but lower than 4th price take 4th price.

[@TeachToEach]

Please share your sheet with condition on [e-mail]

[@diliplondhe2934]

Sirji, very easy teach to us.

[@TeachToEach]

Thanks for the comment Dilip.

[@SeemaKumari-eq2os]

Thanx bhut mst samjhaye

[@vaibhavsingh308]

great one !

[@TeachToEach]

Thanks for the comment Vaibhav Ji.

[@Tabishjimcorbett]

Bahut khoob bro

[@TeachToEach]

Thanks Tabish Ji

[@harendrakumar4738]

Super sir👌👈

[@user-ke8xj2tk8n]

Nice video sir

[@kumarj223]

Thank you ...👍👍👍

[@TeachToEach]

Welcome

[@PappuKumar-rm3zo]

Thanks very helpful

[@TeachToEach]

Welcome Pappu

[@ajmalshahtravelling7088]

good work

[@amitsahota6048]

So good sir.

[@TeachToEach]

Thanks for the comment Amit

[@Buddha795]

Thank you so much for the video sir, I want to know how can we combine all the above formula together.
I mean to say all the dis% in one colum

[@TeachToEach]

Hi Panchu please share your excel sheet with data on [e-mail] will you reply with the whole formula.

[@ankitverma10112]

🙏🏻🌹❤🙏🏻🙏🏻Thank u so much sir 🙏🏻🌹❤

[@TeachToEach]

Your welcome

[@anilmadeshiya9987]

V.Nice.. example

[@TeachToEach]

Thanks Anil

[@reliableservices7467]

Great sir ji

[@TeachToEach]

Thanks for the comment.

[@moolaramdudhwalridmalsar3412]

Good explanation

[@TeachToEach]

Thanks

[@technicalyaarakrish1883]

Thanks bhai

[@cmsraviverma1036]

Thanks Brother.... :)

[@TeachToEach]

Always welcome

[@mshoaibijaz1335]

Thanks bro

[@roshanpadhan1126]

Tq sir...

[@nazirahmed3292]

very good gentle men
ch nazir ahmed

[@TeachToEach]

Thanks Nazir Bhai

[@shilpasinha4713]

Thank you

[@abang1101]

Ye video bahut hi acha tha

[@TeachToEach]

Thanks Narendra

[@SanjayPrakashSrivastava]

अच्छा प्रस्तुतीकरण

[@TeachToEach]

Dhanywaad

[@arjunaiora2407]

Superb

[@arjunsingh1811]

Thanks Ashish

[@TeachToEach]

Thats like a Dude

[@bikashkumarsingh8868]

Love u bro

[@TeachToEach]

Welcome

[@ajinkyagadgil2747]

You saved my job dude 😉

[@TeachToEach]

Reallyyyyyyyyyyyyy Ajinkya?

[@waqasahmad8225]

Thanks Brother sending flower from pakistan

[@TeachToEach]

Thanks Waqar

[@Alokguptak]

Thankkkkkyuuuuu

[@sumitdarge3335]

thanks a lot

[@TeachToEach]

Thanks for the comment Sumit.

[@AryanComputerEducation]

thanks bro...

[@TeachToEach]

Welcome Aryan Computer Education

[@AryanComputerEducation]

duwa roilo BHijaan...

[@sagarupadhyay1449]

Great

[@anilkukreti347]

Nice...make some video for mobile excel..

[@javedali230]

thanks sir

[@anilkumarsingh4560]

Super Hit Video

[@TeachToEach]

Thanks for the comment Anil Ji.

[@passion8040]

You may also use IFS function instead of Nexted IF

[@arijeetkumarsharma226]

Superb.

[@TeachToEach]

Thanks for the comment Arijeet

[@teachsanjay6158]

Thank you sir

[@TeachToEach]

Thanks for the comment Sanjay Ji.

[@sayedsohel6674]

খুব সহায়ক ভিডিও এক্সেল সূত্র শিখতে.....

[@LyricalCom-co9xj]

Thanku sir

[@narayanlimbu6429]

Thanks Lot sir.....

[@TeachToEach]

Welcome Narayan.

[@narayanlimbu6429]

Could you provide Online class?

[@TeachToEach]

Where are you from? please mail me on [e-mail].

[@Ravikumar-to2tu]

Bahut achhe😃

[@TeachToEach]

Dhanyawad

[@anjanakumari5768]

Thanks

[@beinguttarakhandi6183]

Gazab ho bhejiii

[@TeachToEach]

Thanks Garhwali Bheji

[@md.sumonshikder3779]

Thank's

[@TeachToEach]

welcome

[@Wasimsir7]

आशीष रावत जी excel के Menu का भी clearly video बनाईये जैसे फंक्शन को क्लिअर समझाते है वैसे ही Excel के सातों Menu का भी समझायें
आप से कुछ अलग सिखने को मिलता है!
Please Rawat ji
Will be getting help us

[@TeachToEach]

Yes sure

[@zeeshankhalil4679]

Good yar.

[@TeachToEach]

Thanks for the comment Zeeshan

[@rajashahzad3875]

Excellent

[@TeachToEach]

Welcome Raja

[@saiyed4678]

Sir, good video , & one request to you please share with us your excel sheet for our reference & homework which is your teach us.

[@TeachToEach]

Share you email ID

[@saiyed4678]

Thanks for replying sir. My e-mail id is [e-mail], Sir please send all your excel sheet if you can. It will be appreciate.

[@sonalmestry4729]

There is a need that I want to know if there is only one logical function and only one column but having three or more conditions then what to do

[@tanukhan8367]

Thanx sir

[@TeachToEach]

Welcome

[@VICKYROMEO786]

PLS PROVIDE THE EXCEL FILES AS WELL FOR PRACTICE

[@magbulmansuri4636]

very nice

[@TeachToEach]

Thanks for the comment Magbul Ji,