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 ❤
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....
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
"Sir, I have been practicing the IF condition for a long time but couldn't understand it. But after your explanation, I understood it in just one go. Thank you, sir!"
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.
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
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
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 :)
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..
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?
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)
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.😃👍
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?
@@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 ☑️💯
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
Sir Meine bahut channels par MS excel ki videos dekhta hu lekin samajh nhi ata par aapki videos ko ek baar dekhte hi samajh main aajata hai thanks sir🥰🥰
Sir bahut maja aata h aapki video dekh kr k, Sir ek solution bataye - Yadi excel sheet m ek row k ander meri 5 column tk entry h (A1, B1,C1,D1,E1) Ab sir koi esa formula bataye ki yadi koi ek bhi entry 10000 se uper ki aaye to complete row green colour m convert ho jaaye from A1 to E1. Your way of teaching is very grt sir. Salute 🫡
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
This video is really very helpful for those who were completely confused on this topic, And after seeing your this video my several doubts has gone away from my mind. "Really Highly Appreciate Sir for bringing such excellent tutorial with easy examples.❤❤❤
Sir large data ko handel karne ka video banaie kyuki Mai office join karna ja rha hu to large data handel kar saku if possible ho pae to Sir aap bahut acha samjhate h aap excel ke legend h
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
Movie
Custom filter bataiye
Sir can you tell me a shortcut key for auto-drag at 4:40
@@tonydsouza2001 1
ruclips.net/video/q6lMbKcFgE4/видео.html
Iiiii
Great teaching .... It's unexpectedly easy to grasp. Thank you Sir,
Glad it was helpful!
Hi
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 ❤
Thank you so much for your comment.
Thank you sir 😎 ,
It was helpful for me,
I was getting doubts in it but now it has done ✅😎😎😎😎😎😎
Great 👍
Phli bar smjh paya hu is complex concept ko :p thank you
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....
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
This is absolute amazing teaching skills collaborated with perfect Excel skills. Many Many thanks Sir :)
"Sir, I have been practicing the IF condition for a long time but couldn't understand it. But after your explanation, I understood it in just one go. Thank you, sir!"
BEAUTIFULLY EXPLAINED
Thx sir g jo mai itne din se nhi sikha ajjh sikh gya hu..... Very thankfull to u........ ❤❤❤❤❤❤❤❤
Glad it was helpful!
This is the only time I understood if statement clearly. 👍 method used for teaching 👏
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.
Glad it helped!
This is such an outstandingly fruitful video! Amazing sir je, love from Bangladesh
Thanks for such motivating words Marjuk :)
Sir bahut achhi information di apne vedio clear he formula proper he voice bhi clear he thank you so much sir
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
Appka padane ka tarika bahut achcha or sagjane me assan hai love you sir
Sir please make a video on, how to look up value from different sheets via index plus match function
Sure :)
Thanks sir..i like the way you teach us
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
Sir thank you so much for teaching us. One thing i would like to know the difference between 'Nested if' and 'And' function.
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 :)
@@learnwithlokeshlalwani Thank you so much for replying.
Sir app ka samjhany ka method bohat kamal ka hai
Aap bohat acha kam kar rahy ho. Itni detail say koi b ni sikhata
Love you sir from pakistan
You are a great instructor. Can't thank you enough for the way you teach and the content you create! Many thanks😊
You're very welcome!
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 ❤️
Jin jin ko sir ki teaching aatche lage vo like kare
One like from my side too .... :)
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
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..
Aapka samjhane ka tarika bahut prempurna hai parmatma aapko sada prempurna banaye rakhe
Thank you so much
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?
Ya same question
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)
First time apka video dekha. Ek bar main hi aapne dil jit liya, I love your teaching style ❤😊
Thank you so much. Glad you liked it!
Feeling sad for sunil 😔
🤣
Who is he ??
@@maheshrathod204 Dhyaan se dekho smjh jaoge 😅
😂😂
😂
Explain bahut hi achhe kiye h sir ek
bar me samjh gaye
Thanks for video❤❤❤
Thnx sir for clear all dout of ms excel very easy way 😍😍
Great explanation! Easiest and Simple.
Thank you, sir.
Glad it was helpful!
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.😃👍
Ctrl+d
Thanks
@@AnkushKumar-yn1ur I guess its Ctrl+R
You can use = then cell number then press enter
@@9stepgaming721 =" " and then alt+enter
आप का ये विडिओ बहोत ही अच्छा हे आपका समजानेका तरीका बहोत अच्छा हे
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?
This is also my question sir please
ans mila😂
mujhe to question hi samajh nai arha 🥲
@@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 ☑️💯
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
The way you teach is very good
Aapki, example leneki, option bahuti understandable hai,(coin & subjects)🎉
Sir jo aapne yeah video banayi if and, Or ki
Aisi hi Or video average ifs,count ifs aise hi upload kariye...achi lagti hai...bahut badiya sir😊😊
Thank you. Sure, will make a video in future.
Really thankyou sir ache se smjh aaya ❤
Thanks sir... Ap explain bhot hi acche trha krte hai❤
Aapka samjha ne ka tarika bohot easy hai aur aasani se dimag mein beth jata hai.. Thank you Sir 🙏
YOU MADE IT SO SIMPLE.... THANK YOU SO MUCH SIR😃😃😃
Most welcome
wow yr sir apke samjhane ka style mujhe kaafi jyada interested laga ek hi baar men samjh aagaya very jana nice sir ji
समझाने का तरीका बहुत ही अच्छा है ।
👌
Sir Meine bahut channels par MS excel ki videos dekhta hu lekin samajh nhi ata par aapki videos ko ek baar dekhte hi samajh main aajata hai thanks sir🥰🥰
Knowledge has no limitations🔥🔥🔥
Thik samjhaye ho...
Jo samjh gaya unko easy lagega lekin jo nhj samjhe toh. ....dhyaan lagao 😂🔥🔥🔥🔥....
Sir, aapne to assignment diya hai wo bohot useful hai, thank you so much
Ek dam samaj me aajaye is tarike se bataya aapne thanks........
Sir apka concept bhut clear hai thankyou apne itne achhe se samjhaya
Thank you for your comment
The method of simplifying and summarising is great.
Glad it was helpful!
That's why you are a trainer....
Hat's off to your teaching skills...🙏🙏🙏
Thanks a ton
Sir grade kaise nikaalte hai
Sir your teaching method is amazing
Thanks Brother! Your old video was very helpfull to me. May ALLAH bless you💗
You are most welcome
Sir bahut maja aata h aapki video dekh kr k,
Sir ek solution bataye -
Yadi excel sheet m ek row k ander meri 5 column tk entry h (A1, B1,C1,D1,E1) Ab sir koi esa formula bataye ki yadi koi ek bhi entry 10000 se uper ki aaye to complete row green colour m convert ho jaaye from A1 to E1.
Your way of teaching is very grt sir. Salute 🫡
explained in simple way in lucid language
MERE TEACHR NE ITNI CHOTI SI CHEEJ KO ITNA COMPLICATE KRDIA THA GAWWD THNKU SIR
Thank you for teaching in a simple way.🙏🙏
My pleasure
Very good explanation for beginners like me, point as well as examples which is very rare explanation vedio.
Bohot acha laga sir concept samjh aa gaya THANK YOU
Most welcome. Glad you liked it.
Very nice presentation
I understand everything perfectly😎😎😎😎😎😎thenks all
Bohot Dhanyavad. Subscribed.
Great tricks bro. Today i learn something from you. Thank you.
Thank you Sir, It was very simple presentation but effective
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
Thank you. Your teaching method is very impressive. very easy to understand.
Thank you do much.
This video is really very helpful for those who were completely confused on this topic, And after seeing your this video my several doubts has gone away from my mind. "Really Highly Appreciate Sir for bringing such excellent tutorial with easy examples.❤❤❤
Thank you so much. Glad it helped!
Bohat Shandar way me explain kia hai. It was a great video.
Your way of teaching is very Good Brother . THANKS A LOT
your way of teaching is appreciative
Thank you so much
Sir large data ko handel karne ka video banaie kyuki Mai office join karna ja rha hu to large data handel kar saku if possible ho pae to
Sir aap bahut acha samjhate h aap excel ke legend h
Apka sikhane ka tareeka bhut hi pyara h
Thank you for your comment.
Bohat zyada samaj aa gaya..
Thanks
Please make more videos like this. I like the way you teach. Extremely helpful and understandable
the way of your teaching is very nice sir, your way of teaching is understandable for everyone keep it up sir, thanku sir jai shree rram🙏🙏
Thank you so much.
Great
Simplest and easiest way of communicating the scenario.
Hatts of
This was the perfect sir, you explained the concept really well, thank you so much.
Glad it was helpful!
Maza a Gaya ,very refreshing after seeing videos that I cannot understand
Lokesh ji.. you are really great Sir. I really like ur explanation..
Thanks and welcome
Thanks sir to clear my doubts on "And/OR" topic by giving such a good example so that a person can easily understand
Thank you so much for your detailed explanation of the Formulas..
You're very welcome!
Watched a lot of videos but you explained it very good.Thankyou
superb sir👍 .no one can explain this topic in very simple way.thnk u so much sir
Your video makes very helpful to clarify the logic function topic 🙏
Glad to hear that
Sir apne bahut achhe se samjhaya Thank you so much ❤ ap drdo k exam k liye bhi video bana diye
hello sir, aap ny itny achy tareeqy sy samjhya hy k bta nai sakta
bundle of thanks sir
THank you so much for your comment. Glad you liked it!
sir ayesa samjhaya ki mind me baith gya thanku sir
GREATLY EXPLAINED. TRUE EDUCATOR. I WISH YOU GOOD HEALTH.
Keep Learning. All the best !!!
Very Useful 3 Even after 3 years 🔥
Thanks you very much sir apka ye question mere interview me aaj kaam aaya
The way u explained it's very nice
I almost work this formulas on regular basis but way of explaining is very nice.
Thank you for making it simple to uderstand....🙏
Glad it was helpful!
Aapke samjhne ka style bahut better h
You are best teacher of Excel sir
1 bar m hi bahut ache se samjh gaya very gud techinc
YOU ARE AN EXCELLENT TEACHER
Sir you are a real guru what a great explanation
Thank you so much for your comment.
Thank you sir aapke btane ka tarika bahut achcha hai
Awesome video sir I was confused what is the purpose of AND and OR conditions superb teaching
Thank you so much. Keep watching!
Ap bahut acha amchate hai tq sir ji 🙏