How to use IF, AND, OR functions in Excel (हिंदी में)

👉 FREE Excel Webinar. REGISTER NOW
event.webinarjam.com/register...
In this video, we will talk about “How to use IF, AND, OR function in Excel (in Hindi)”.
=========================================================
Download Excel Workbook: learn-with-lokesh-lalwani.thi...
=========================================================
For any training, requirement - [e-mail], [e-mail]
Or
Visit: www.nurturetechacademy.in/
=========================================================
Following functions are being covered in this video:
IF
If a function is all about either this or that based on a certain condition. If we toss a coin and I choose heads, then I'll say if heads come I’ll win else I’ll lose, this is an if condition.
Syntax:
=IF(logical_Test, Value_if_true,Value_if_False)
Arguments:
Logical_Test - It is the condition of your present scenario.
Value_if_True - If logical_test comes out to be true then what value or calculation needs to be shown here.
Value_if_False - If logical_test comes out to be false then what value or calculation needs to be shown here.
AND
When we would like to check that if all the conditions are true or not then we use “AND” function.
Syntax
AND(logical1, [logical2], ...)
Logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
Logical2, ... Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
OR
An “OR” function will give “True” as a result if anyone out of a set of conditions is true.
Syntax
OR(logical1, [logical2], ...)
Logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
Logical2, ... Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
For more such videos subscribe our channel: / @learnwithlokeshlalwani
Follow me on my Instagram for the latest updates:
learnwithlo...
#learnwithlokeshlalwani #nurturetechacademy

[@learnwithlokeshlalwani]

Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥

[@tonydsouza2001]

Movie

[@DjBlasterSonpur]

Custom filter bataiye

[@mann_ki_do_baatein]

Sir can you tell me a shortcut key for auto-drag at 4:40

[@virendratopkar]

@@tonydsouza2001 1

[@pa2happiness13]

th-cam.com/video/q6lMbKcFgE4/w-d-xo.html
Iiiii

[@omkarpawar9401]

This is absolute amazing teaching skills collaborated with perfect Excel skills. Many Many thanks Sir :)

[@patiramgroup3559]

I have gone through many videos but your style of teaching made me impressed and have understood the concept of if, and or function. Thank you so much sir....

[@aneeshparippally]

This is the only time I understood if statement clearly. 👍 method used for teaching 👏

[@sudhakarjain1299]

Lokesh Lalwani, so good teaching! So easy to follow, So good narration. I want to learn all excel formulas henceforth from you.

[@aviksengupta8087]

Great teaching .... It's unexpectedly easy to grasp. Thank you Sir,

[@learnwithlokeshlalwani]

Glad it was helpful!

[@mukeshrothorepubglitgamers6488]

Hi

[@sandipdas3442]

Please make a video on inventory management with conditional formatting and other functions (if required) like stock comes in randomly and goes out randomly with color. Thanks

[@sangamsingh3]

Phli bar smjh paya hu is complex concept ko :p thank you

[@meghapurohit1484]

BEAUTIFULLY EXPLAINED

[@marjukrusselhera8143]

This is such an outstandingly fruitful video! Amazing sir je, love from Bangladesh

[@learnwithlokeshlalwani]

Thanks for such motivating words Marjuk :)

[@avr9747]

This is a masterpiece.
You have made indepth research.
Kindly provide video on offset as its quite diecy
Thanks

[@ishtiyaqueansari8814]

Sir
Your teaching skill is superb 👍
Thank you so much 🥰

[@eshakapoor460]

You are a great instructor. Can't thank you enough for the way you teach and the content you create! Many thanks😊

[@learnwithlokeshlalwani]

You're very welcome!

[@Lazysrsvideo2002]

Thank you sir 😎 ,
It was helpful for me,
I was getting doubts in it but now it has done ✅😎😎😎😎😎😎

[@learnwithlokeshlalwani]

Great 👍

[@arshadmehmood8158]

Your teaching method is excellent. Thank You very much .I Learnt a lot from this lecture.

[@Isaiah9.6]

Excellent training!! Thank you for sharing your valuable expertise!!

[@ucmasgularbhoj3146]

I love your way of teaching

[@learnwithlokeshlalwani]

Thanks Kajal :)

[@darksoulvibe]

​@@learnwithlokeshlalwani sir manager 20000,clerk15000,peon10000 in teeno ki salary itni hai or mujhe if wale condition se dena hai to kaise denge?

[@mkztlw]

Sir please make a video on, how to look up value from different sheets via index plus match function

[@learnwithlokeshlalwani]

Sure :)

[@mkztlw]

Thanks sir..i like the way you teach us

[@parveenrana4359]

sir, Your way of explaining is very good thanks.

[@pankajsaini50]

Aapne bhut acche se samjhaya...saaf suthri voice and sound quality🙏

[@imranmananzoi3681]

Thank You great work

[@learnwithlokeshlalwani]

Thanks Imran :)

[@vinitgupta226]

Sir thank you so much for teaching us. One thing i would like to know the difference between 'Nested if' and 'And' function.

[@learnwithlokeshlalwani]

Hi Vinit,
Glad to know that you are gaining knowledge from my videos. The core difference is that AND function checks all the conditions at a time and NESTEDIF cehcks it one by one.
Hope this answer your question.
Happy learning :)

[@vinitgupta226]

@@learnwithlokeshlalwani Thank you so much for replying.

[@pankajdubla4061]

Very good
I learn from your video, now I understand different between and function and OR function.
Thanks

[@ChandraShekharBanjara]

Thank you thank you thank you very much sir maine bahot video dekha youtube pe par apka video sabse best tha mujhe if and or bahot achhe se samjh a gya ❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@aena395]

Sir, two columns ke beech me comparison krke multiple result print krana hai.
For exam. A and B columns me number hai, agar A column me 1 hai and B me 0 to New print krana hai, agar A me 2 and B me NA hai to closed, pls share videos for the same..

[@mohamedadjal8502]

Hi, Professor, you have provided a lot of effort for these videos, thank you, I have a question in excel, if we have for example in cell "a1" the number 10.00 m, how to have this number in the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍

[@santoshshukla1340]

Ctrl+d

[@AnkushKumar-yn1ur]

Thanks

[@sachingurav2099]

@@AnkushKumar-yn1ur I guess its Ctrl+R

[@9stepgaming721]

You can use = then cell number then press enter

[@aman__ghildiyal4493]

@@9stepgaming721 =" " and then alt+enter

[@siddharthsuman297]

Sir main yunhi kisi ki taarif nahi karta but aapka explaination bahut accha hai koi jaldi ya hadbadi nahin dikhti hai. Please ese hi padhate rahiyega sir

[@atulbharti7880]

superb sir👍 .no one can explain this topic in very simple way.thnk u so much sir

[@hiteshshukla1409]

Sir, In "OR" Condition, You took atleast one value which must be greater than 50k for the commission.
If in a certain case, we take two values must be greater than 50k to get commission, then how to apply than condition?

[@anandpreetsingh78]

Ya same question

[@abroazhar]

For simplicity, we can do this by checking Total value... For example. for Two categories he earns at least 50, and in one category his sale is 0. then total value will be 100 (at least). then we can put another condition on Total if Total is =>100 then he earns commission.
(same question by @harrysing5052 ... i answered there as well)

[@ragealpha4784]

Feeling sad for sunil 😔

[@vickey3005]

🤣

[@maheshrathod204]

Who is he ??

[@HotzMovies]

​@@maheshrathod204 Dhyaan se dekho smjh jaoge 😅

[@pratitakwale9518]

😂😂

[@djosjsjw]

😂

[@madhun8092]

Thank you 😊… it’s a lot simple and clear.. Do share your knowledge as always. Just a suggestion.. if you update English subtitles you may attract more viewers.

[@noorirfan4886]

Thanks sir to clear my doubts on "And/OR" topic by giving such a good example so that a person can easily understand

[@vedant_gade78_patil]

Jin jin ko sir ki teaching aatche lage vo like kare

[@learnwithlokeshlalwani]

One like from my side too .... :)

[@ahmednawaz4946]

Sir, if company require that sales is more than 50000 for each of two products then 2% commission on total sales is given then how then conditional AND formula would be applied?

[@shivshankarbirla5820]

This is also my question sir please

[@pranjalprotimkonwar4293]

ans mila😂

[@FKN993]

mujhe to question hi samajh nai arha 🥲

[@KKInfinityGaming]

@@FKN993 😊 koi na simple tarike se samjha ta hu.
Company ka kahna ha ki jo koi 50000 se jada ki sale Karta Hai Har product mein toh usmein 2℅ tumhara isliye is situation Mein IF(AND )👍ka formula use hoga! -or dusri situation mein agar koi all product mein se Agar Ek bhi product Ko bechta Hai 50000 Se Jyada ka to usmein bhi 2% ka Tumhara Hak hoga isliye is situation mein IF(OR) Ka Formula use hoga ok ☑️💯

[@KKInfinityGaming]

IF(AND) formula use hota hai all product ko company ke target ke hisab se Sel karne par
And IF(OR) formula ka use hota ha company ke Diye Gaye target ke hisab se all product mein se ek product Ko bechne per

[@sheojeesharma8549]

The way you are teaching is very good. I understood all the points very clearly. I would like to request to you. Please shared the link of this file sample for downloading.

[@kishanmishra9611]

Sir iss condition ne mujhe excel mai aur bhi smarter bana diya .. mujhe achhe tarike se condition lagana aata h... Aapke video se sikh maine ❤️

[@kajaltripathi7743]

Thnx sir for clear all dout of ms excel very easy way 😍😍

[@tapasyajha7183]

Really thankyou sir ache se smjh aaya ❤

[@artatranpatra657]

Aapka samjhane ka tarika bahut prempurna hai parmatma aapko sada prempurna banaye rakhe

[@learnwithlokeshlalwani]

Thank you so much

[@vaibhavpandey7635]

Sir, you made my concept clear about this formula-thankyou so much
🙏🙏🙏

[@masuoodahmad]

Very well explained. Thanks a lot for sharing this wonderful video.

[@muralikrishna-mi1nh]

Thank you sir .it's a good knowledge and Very useful lesson

[@sumeetkotian8544]

Seriously u made excel so much simple... Keep the good work going..👍

[@Fulwar_Live]

Love ❤ you sir g Kyoki Mai ek sheet pe work kar raha tha or Mai formula laga laga kar thak chuka tha or youtube par bhi kisi ne mere problem ka solution nahi diya finally mujhe aapka video mila.
Mai ek marksheet create kar raha tha jaha mujhe use karna tha ki wo kisi bhi subject me fail hai to fail hai.
But sabhi youtuber sirf single function ka hi use karke dikha raha the so finally I found that content that I really need.
Love ❤ u

[@nehakhanna752]

Nice explanation sir thanks for your video 👍

[@learnwithlokeshlalwani]

Thanks for liking Neha

[@ankurgaur4740]

That's why you are a trainer....
Hat's off to your teaching skills...🙏🙏🙏

[@learnwithlokeshlalwani]

Thanks a ton

[@shailendrapathak1503]

Sir grade kaise nikaalte hai

[@thefearless5316]

Thanks sir, you explained the excel functions in a very good and clear way.

[@arfa3812]

YOU MADE IT SO SIMPLE.... THANK YOU SO MUCH SIR😃😃😃

[@learnwithlokeshlalwani]

Most welcome

[@mrdhanstube]

Great explanation. Plain and simple.

[@girijachandran20]

Thank you, I learnt and, or use of in IF decision making.🙏
I am searching for compare the cell value with different conditions and different value to be display in a cell.

[@newsandvlogs9130]

Bohot Dhanyavad. Subscribed.

[@lo_highoct10]

very simple and easily explained.
Thank you sir.

[@growstronger426]

Great way of teaching. Also the choice of having real world scenarios helps a lot. Thanks for the content please keep uploading such beautiful videos.

[@learnwithlokeshlalwani]

Thanks, will do!

[@nawshinnawar4714]

Please make more videos like this. I like the way you teach. Extremely helpful and understandable

[@dineshjangid4556]

समझाने का तरीका बहुत ही अच्छा है ।
👌

[@Rehan07635]

First time apka video dekha. Ek bar main hi aapne dil jit liya, I love your teaching style ❤😊

[@learnwithlokeshlalwani]

Thank you so much. Glad you liked it!

[@satyabanmahapatra6132]

The way u explained it's very nice
I almost work this formulas on regular basis but way of explaining is very nice.

[@sonakshypanda2337]

The way you teach is very good

[@pratiksoni1859]

Good examples & easily explained. Great work sir.

[@040aliasgarkutiyanawala6]

amazing, very simple and well explained ! thanks!

[@GhumakkadRkv]

Very important video..i followed nd solved my work..thanks bro

[@AnujKumar-zl7jc]

Thanks sir... Ap explain bhot hi acche trha krte hai❤

[@ratansarkar1]

Lokeshji, your way of teaching so nice, I became your fan, very very very useful video, very easy to learn. Thanks a lot for uploading such a useful video,

[@Mdalmas.]

Great tricks bro. Today i learn something from you. Thank you.

[@muhammadsohailshahzad7472]

Great
Simplest and easiest way of communicating the scenario.
Hatts of

[@kiranjoshi560]

Excellent superb amazing wow 💕 it' doesn't lack any thing ...love from Nepal tq for such an impressive way of presenting 😍😘

[@learnwithlokeshlalwani]

Thank you so much Kiran 😀

[@Chomu432]

Watched a lot of videos but you explained it very good.Thankyou

[@RizwanAli-pd8zt]

Thank you very much , your teaching method is very good. This video will be helpfull in life .

[@rakeshpawar6242]

Very nice video dada..... Helped me lot....

[@Anikvikram]

Thank you very much for such a good video.Agar countif and or pe ek video banaye to bahut help hoga.

[@maliksid9375]

Outstanding 👍really helpful

[@trinadhrao7014]

Very useful information.. Thank you

[@abhinashdebbarma]

Aapka samjha ne ka tarika bohot easy hai aur aasani se dimag mein beth jata hai.. Thank you Sir 🙏

[@im_cpk]

Excellent teaching!!

[@Sonuyadav-tm9rn]

Very easy to learn, thanks for this dedication for your hard working

[@thenikkikotiyal8077]

Very nicely explained, thank you so much!

[@user-qm5ql7dn4k]

👌 Very well explained.
Can you please explain on condition- if any two product sales is > or = 50000, then only pay Commission.

[@santoshshukla1340]

It was one of the best explanation of if and or function thankyou so much sir for such lovely video ... I just want to know how to drag empty cells at 1 go based on my data length

[@hifzushaikhshaikh7511]

Most clearly explained thanks

[@dineshmathsclasses2514]

Nicely explained concepts, thankyou so much for your time and effort.

[@SriTechGuru]

nice short and sweet, easily understandable

[@rashmirekhabaruah1578]

Very informative . thank you...

[@billubhaikafunda5823]

Very nice and easy to learn
Maine bhutt si video deki sir but aapki sabse best h un sabme...thanks sir
Ek baar me hi concept clear ho gaya

[@antakshithakur9708]

Thankyou sir, I understood it really well.

[@vimalkmr951]

You are best teacher of Excel sir

[@rakeshraman4380]

Good Day, Sir. It is a very good lesson, sir.

[@obedullahkhan939]

Zabardast samjhaye bhai tum👌😊... Zalzala hai video 🔥

[@skdas6799]

Now this if called explanations. Thanks

[@jayprakash1360]

It's very helpful for me , Thanks sir

[@PratibhaKumari-hp4js]

Excellent explanation... Thank you so much Sir

[@ajangurung2522]

thank you, your video was worth of watching.

[@localplaceshunterka.0649]

Nice teaching Bro.....🤓🤓 May Fida Hogai 🤩🤩........

[@mahendraramavat60]

Very good teaching .Thank you.

[@stec0123]

Great Bro. Your way of explaining the thing is buttery smooth. I was learning DAX calculations just to get certification to add in my resume and got caught with this formula. Now I'm through it.

[@learnwithlokeshlalwani]

Glad it helped!

[@nawaemurshid]

Very useful.thank you so much.

[@nimikarajput8965]

Absolutely fabulous sir..😊

[@indranilchatt12]

Very very helpful.. Thanks..

[@r.k.goswami1047]

Bahut अच्छी knowledge थी

[@MONUYADAV-ue8fm]

Thanks sir. Video is really helpful

[@Sumit-dixit]

CRYSTAL CLEAR CONCEPT... THANK YOU SIR