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 सीखने के लिए हमारे नए चैनल को जरूर सब्सक्राइब करे इस लिंक की मदद से ruclips.net/channel/UC050KnRA2lffzEsB1h8uQCw , एक्सेल की क्लासेज शुरू हो गयी है शुरुआत से , बहुत जल्द VBA भी शुरू होने वाला है |

[@saikamal1000]

If and formula not working properly

[@Azhartheofficial]

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

[@nurasad9797]

Very helpful, thanks a lot...

[@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

[@sumitchoudhary8857]

It helps me sir thank u.

[@mahfujalam8255]

Thank u sir your good effort, amazing sir 😍😍

[@aishwaryamahapatra706]

Thanks for explaining formula in a simple way ..

[@TeachToEach]

Your welcome

[@upsctak6067]

Master ek no brother app to legend ho

[@sonalmestry4729]

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

[@satyendrasingh9300]

Very nice easy way to understand

[@ashutoshnazare945]

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

[@ImranKhan-fc3ri]

Super bro bahut ache se samjhaya bhai tune

[@dr.surabhisrivastav29]

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

[@TeachToEach]

Welcome Surabhi Ji.

[@cvishwakarma451]

very good explanation sir!

[@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

[@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.

[@dinesh53752]

Thank you so much man

[@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 RUclips. 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.

[@kalpeshkakuste1796]

Thanks for this video.
Very useful

[@TeachToEach]

Welcome Kalpesh Ji

[@codinglife128]

Thank you sir nice tech 🙂🙂🙂🙂

[@umeshn7513]

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

[@TeachToEach]

Thanks for these precious words for me Umesh.

[@vasimshaikh3581]

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

[@TeachToEach]

Thanks

[@KaranKohliVlogs]

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

[@TeachToEach]

Your Welcome

[@sammu28]

Nicely explained. Thanks

[@TeachToEach]

Welcome

[@vk6456]

Thanks a lot sir 😊

[@venugopal-vt9wk]

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

[@TeachToEach]

My pleasure @ Venu !!! Thankyou so much

[@krishnajitechnicaleducatio6903]

ruclips.net/channel/UC4S6Ej0lytw6CVJEmahJuFw

[@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.

[@williechristian9135]

Thank you! Too good.

[@TeachToEach]

Thanks for the comment Willie Ji.

[@bijayakumarsahoo6300]

Very good describe.

[@chandrapalrajput6269]

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

[@TeachToEach]

Your welcone Chandrapal

[@dharitrisahoo3361]

Good teaching, well explained

[@TeachToEach]

Thanks Dharitri

[@ankitrajpoot2870]

What a video bro...

[@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.

[@sharathkk1807]

Superb 🤝

[@puneetvij8433]

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

[@TeachToEach]

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

[@monarchsunion3485]

Very nice and useful

[@soobrataguha14]

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

[@TeachToEach]

Thanks for the comment.

[@SeemaKumari-eq2os]

Thanx bhut mst samjhaye

[@rajukc8878]

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

[@TeachToEach]

Thanks for the comment Raju

[@kumarj223]

Thank you ...👍👍👍

[@TeachToEach]

Welcome

[@PappuKumar-rm3zo]

Thanks very helpful

[@TeachToEach]

Welcome Pappu

[@rajanikumari957]

Very easy step u thaught sir...thnx

[@TeachToEach]

Thanks

[@roshanpadhan1126]

Tq sir...

[@happiebrar6807]

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

[@TeachToEach]

Welcome Harpreet

[@sonimohitkadel2636]

2:24

[@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

[@diliplondhe2934]

Sirji, very easy teach to us.

[@TeachToEach]

Thanks for the comment Dilip.

[@technicalyaarakrish1883]

Thanks bhai

[@cmsraviverma1036]

Thanks Brother.... :)

[@TeachToEach]

Always welcome

[@avipriyanka1998]

Channel name bhut achha lga bhai😊

[@rajeshkumargupta8371]

Thanks bro

[@abhaypadhan4666]

Nice video.

[@shilpasinha4713]

Thank you

[@ankitverma10112]

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

[@TeachToEach]

Your welcome

[@ajinkyagadgil2747]

You saved my job dude 😉

[@TeachToEach]

Reallyyyyyyyyyyyyy Ajinkya?

[@abhijitroy8041]

Wonderfully explained. Thumps up my dear friend..

[@TeachToEach]

Welcome Abhijit Ji

[@vaibhavsingh308]

great one !

[@TeachToEach]

Thanks for the comment Vaibhav Ji.

[@motivation.rahul64]

Very nice good teach sir ji

[@TeachToEach]

Thank You

[@anilmadeshiya9987]

V.Nice.. example

[@TeachToEach]

Thanks Anil

[@harendrakumar4738]

Super sir👌👈

[@ajmalshahtravelling7088]

good work

[@amitsahota6048]

So good sir.

[@TeachToEach]

Thanks for the comment Amit

[@sumitdarge3335]

thanks a lot

[@TeachToEach]

Thanks for the comment Sumit.

[@user-ke8xj2tk8n]

Nice video sir

[@arjunsingh1811]

Thanks Ashish

[@TeachToEach]

Thats like a Dude

[@javedali230]

thanks sir

[@reliableservices7467]

Great sir ji

[@TeachToEach]

Thanks for the comment.

[@moolaramdudhwalridmalsar3412]

Good explanation

[@TeachToEach]

Thanks

[@bikashkumarsingh8868]

Love u bro

[@TeachToEach]

Welcome

[@triptiverma6012]

Thanks sir

[@prabhakarkumar5639]

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

[@TeachToEach]

Welcome Prabhakar

[@nazirahmed3292]

very good gentle men
ch nazir ahmed

[@TeachToEach]

Thanks Nazir Bhai

[@LyricalCom-co9xj]

Thanku sir

[@Alokguptak]

Thankkkkkyuuuuu

[@Tabishjimcorbett]

Bahut khoob bro

[@TeachToEach]

Thanks Tabish Ji

[@arjunaiora2407]

Superb

[@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]

[@waqasahmad8225]

Thanks Brother sending flower from pakistan

[@TeachToEach]

Thanks Waqar

[@sayedsohel6674]

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

[@anjanakumari5768]

Thanks

[@abang1101]

Ye video bahut hi acha tha

[@TeachToEach]

Thanks Narendra

[@md.sumonshikder3779]

Thank's

[@TeachToEach]

welcome

[@tanukhan8367]

Thanx sir

[@TeachToEach]

Welcome

[@anilkumarsingh4560]

Super Hit Video

[@TeachToEach]

Thanks for the comment Anil Ji.

[@arijeetkumarsharma226]

Superb.

[@TeachToEach]

Thanks for the comment Arijeet

[@sagarupadhyay1449]

Great

[@deepakmali586]

thanks sir ji

[@TeachToEach]

Welcome Deepak , I am not a sir brother I am like your friend

[@AryanComputerEducation]

thanks bro...

[@TeachToEach]

Welcome Aryan Computer Education

[@AryanComputerEducation]

duwa roilo BHijaan...

[@SanjayPrakashSrivastava]

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

[@TeachToEach]

Dhanywaad

[@narayanlimbu6429]

Thanks Lot sir.....

[@TeachToEach]

Welcome Narayan.

[@narayanlimbu6429]

Could you provide Online class?

[@TeachToEach]

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

[@anilkukreti347]

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

[@Ravikumar-to2tu]

Bahut achhe😃

[@TeachToEach]

Dhanyawad

[@passion8040]

You may also use IFS function instead of Nexted IF

[@creativ.nation]

👍

[@rajashahzad3875]

Excellent

[@TeachToEach]

Welcome Raja

[@VICKYROMEO786]

PLS PROVIDE THE EXCEL FILES AS WELL FOR PRACTICE

[@arsalanalijafri]

thanks

[@TeachToEach]

Thanks for the comment Arsalan

[@beinguttarakhandi6183]

Gazab ho bhejiii

[@TeachToEach]

Thanks Garhwali Bheji

[@millipal730]

thanks yar I hope you

[@TeachToEach]

Welcome

[@magbulmansuri4636]

very nice

[@TeachToEach]

Thanks for the comment Magbul Ji,

[@zeeshankhalil4679]

Good yar.

[@TeachToEach]

Thanks for the comment Zeeshan