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....
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 ❤
"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!"
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
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
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 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, 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..
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, 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)
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
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.
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🥰🥰
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.❤❤❤
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
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
ua-cam.com/video/q6lMbKcFgE4/v-deo.html
Iiiii
Great teaching .... It's unexpectedly easy to grasp. Thank you Sir,
Glad it was helpful!
Hi
almost spend an hour to clear =if and =and function, You pull me out of this concept very easily, would like to say thank you
That’s great to hear! I’m happy I could help clear up those functions for 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....
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.
This is absolute amazing teaching skills collaborated with perfect Excel skills. Many Many thanks Sir :)
Phli bar smjh paya hu is complex concept ko :p thank you
This is such an outstandingly fruitful video! Amazing sir je, love from Bangladesh
Thanks for such motivating words Marjuk :)
"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
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!
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
That's why you are a trainer....
Hat's off to your teaching skills...🙏🙏🙏
Thanks a ton
Sir grade kaise nikaalte hai
This is the only time I understood if statement clearly. 👍 method used for teaching 👏
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
Thank you sir 😎 ,
It was helpful for me,
I was getting doubts in it but now it has done ✅😎😎😎😎😎😎
Great 👍
Explain bahut hi achhe kiye h sir ek
bar me samjh gaye
Thanks for video❤❤❤
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
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
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 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
Jin jin ko sir ki teaching aatche lage vo like kare
One like from my side too .... :)
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
Feeling sad for sunil 😔
🤣
Who is he ??
@@maheshrathod204 Dhyaan se dekho smjh jaoge 😅
😂😂
😂
Aapka samjha ne ka tarika bohot easy hai aur aasani se dimag mein beth jata hai.. Thank you Sir 🙏
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 bahut achhi information di apne vedio clear he formula proper he voice bhi clear he thank you so much sir
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
The way you teach is very good
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)
Aapka samjhane ka tarika bahut prempurna hai parmatma aapko sada prempurna banaye rakhe
Thank you so much
Thnx sir for clear all dout of ms excel very easy way 😍😍
Thx sir g jo mai itne din se nhi sikha ajjh sikh gya hu..... Very thankfull to u........ ❤❤❤❤❤❤❤❤
Glad it was helpful!
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
आप का ये विडिओ बहोत ही अच्छा हे आपका समजानेका तरीका बहोत अच्छा हे
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!
Really thankyou sir ache se smjh aaya ❤
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 ❤️
Thanks sir... Ap explain bhot hi acche trha krte hai❤
wow yr sir apke samjhane ka style mujhe kaafi jyada interested laga ek hi baar men samjh aagaya very jana nice sir ji
Appka padane ka tarika bahut achcha or sagjane me assan hai love you sir
superb sir👍 .no one can explain this topic in very simple way.thnk u so much sir
Great explanation! Easiest and Simple.
Thank you, sir.
Glad it was helpful!
YOU MADE IT SO SIMPLE.... THANK YOU SO MUCH SIR😃😃😃
Most welcome
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.
Aapki, example leneki, option bahuti understandable hai,(coin & subjects)🎉
Knowledge has no limitations🔥🔥🔥
Thik samjhaye ho...
Jo samjh gaya unko easy lagega lekin jo nhj samjhe toh. ....dhyaan lagao 😂🔥🔥🔥🔥....
Sir
Your teaching skill is superb 👍
Thank you so much 🥰
Great
Simplest and easiest way of communicating the scenario.
Hatts of
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🥰🥰
Lokesh Lalwani, so good teaching! So easy to follow, So good narration. I want to learn all excel formulas henceforth from you.
Bohat Shandar way me explain kia hai. It was a great video.
Nice teaching Bro.....🤓🤓 May Fida Hogai 🤩🤩........
Please make more videos like this. I like the way you teach. Extremely helpful and understandable
Very nice presentation
I understand everything perfectly😎😎😎😎😎😎thenks all
Zabardast samjhaye bhai tum👌😊... Zalzala hai video 🔥
MERE TEACHR NE ITNI CHOTI SI CHEEJ KO ITNA COMPLICATE KRDIA THA GAWWD THNKU SIR
Sir, aapne to assignment diya hai wo bohot useful hai, thank you so much
Sir your teaching method is amazing
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
Your way of teaching is very Good Brother . THANKS A LOT
Thanks sir to clear my doubts on "And/OR" topic by giving such a good example so that a person can easily understand
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.
bhot acha samjya bhai..👏👏👏...ur new subscriber...best wishes from pakistan
Thank you for teaching in a simple way.🙏🙏
My pleasure
Superb explanation
In very simple way 👍👍🙏🙏
thank you 🙋🙋🙋sir ji ❤️
Great tricks bro. Today i learn something from you. Thank you.
Watched a lot of videos but you explained it very good.Thankyou
Sir apne bahut achhe se samjhaya Thank you so much ❤ ap drdo k exam k liye bhi video bana diye
Very good explanation for beginners like me, point as well as examples which is very rare explanation vedio.
1 bar m hi bahut ache se samjh gaya very gud techinc
Thanks Brother! Your old video was very helpfull to me. May ALLAH bless you💗
You are most welcome
Bohot Dhanyavad. Subscribed.
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!
Thank you. Your teaching method is very impressive. very easy to understand.
Thank you do much.
The way u explained it's very nice
I almost work this formulas on regular basis but way of explaining is very nice.
Apka sikhane ka tareeka bhut hi pyara h
Thank you for your comment.
Thank you Sir, It was very simple presentation but effective
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!
GREATLY EXPLAINED. TRUE EDUCATOR. I WISH YOU GOOD HEALTH.
Keep Learning. All the best !!!
your way of teaching is appreciative
Thank you so much
You are best teacher of Excel sir
Maza a Gaya ,very refreshing after seeing videos that I cannot understand
Sir your voice is too soft and clear ❤ thanks sir
Aapke samjhne ka style bahut better h
explained in simple way in lucid language
The method of simplifying and summarising is great.
Glad it was helpful!
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
Bahut अच्छी knowledge थी
Bohot acha laga sir concept samjh aa gaya THANK YOU
Most welcome. Glad you liked it.
Best teaching sir, very easy way simply teached, thanks a lot
Ap bahut acha amchate hai tq sir ji 🙏
Lokesh ji.. you are really great Sir. I really like ur explanation..
Thanks and welcome
Thank you sir.your learning skills is very good.😊😊
Excellent training!! Thank you for sharing your valuable expertise!!
Really incredible your way of teaching no words to say