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 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
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
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..
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
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🥰🥰
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.
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
th-cam.com/video/q6lMbKcFgE4/w-d-xo.html
Iiiii
Great teaching .... It's unexpectedly easy to grasp. Thank you Sir,
Glad it was helpful!
Hi
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
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
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.
BEAUTIFULLY EXPLAINED
Phli bar smjh paya hu is complex concept ko :p thank you
This is the only time I understood if statement clearly. 👍 method used for teaching 👏
Appka padane ka tarika bahut achcha or sagjane me assan hai love you sir
This is absolute amazing teaching skills collaborated with perfect Excel skills. Many Many thanks Sir :)
समझाने का तरीका बहुत ही अच्छा है ।
👌
Thank you sir 😎 ,
It was helpful for me,
I was getting doubts in it but now it has done ✅😎😎😎😎😎😎
Great 👍
"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!"
This is such an outstandingly fruitful video! Amazing sir je, love from Bangladesh
Thanks for such motivating words Marjuk :)
Aapka samjha ne ka tarika bohot easy hai aur aasani se dimag mein beth jata hai.. 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
Aapka samjhane ka tarika bahut prempurna hai parmatma aapko sada prempurna banaye rakhe
Thank you so much
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!
Really thankyou sir ache se smjh aaya ❤
Feeling sad for sunil 😔
🤣
Who is he ??
@@maheshrathod204 Dhyaan se dekho smjh jaoge 😅
😂😂
😂
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!
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
The way you teach is very good
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 iss condition ne mujhe excel mai aur bhi smarter bana diya .. mujhe achhe tarike se condition lagana aata h... Aapke video se sikh maine ❤️
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 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
Thnx sir for clear all dout of ms excel very easy way 😍😍
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
आप का ये विडिओ बहोत ही अच्छा हे आपका समजानेका तरीका बहोत अच्छा हे
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)
MERE TEACHR NE ITNI CHOTI SI CHEEJ KO ITNA COMPLICATE KRDIA THA GAWWD THNKU SIR
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
Aapki, example leneki, option bahuti understandable hai,(coin & subjects)🎉
Explain bahut hi achhe kiye h sir ek
bar me samjh gaye
Thanks for video❤❤❤
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
Knowledge has no limitations🔥🔥🔥
Thik samjhaye ho...
Jo samjh gaya unko easy lagega lekin jo nhj samjhe toh. ....dhyaan lagao 😂🔥🔥🔥🔥....
Nice teaching Bro.....🤓🤓 May Fida Hogai 🤩🤩........
That's why you are a trainer....
Hat's off to your teaching skills...🙏🙏🙏
Thanks a ton
Sir grade kaise nikaalte hai
explained in simple way in lucid language
Thx sir g jo mai itne din se nhi sikha ajjh sikh gya hu..... Very thankfull to u........ ❤❤❤❤❤❤❤❤
Glad it was helpful!
wow yr sir apke samjhane ka style mujhe kaafi jyada interested laga ek hi baar men samjh aagaya very jana nice sir ji
thank you 🙋🙋🙋sir ji ❤️
Sir, aapne to assignment diya hai wo bohot useful hai, thank you so much
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🥰🥰
Ek dam samaj me aajaye is tarike se bataya aapne thanks........
Bahut आसानी से समझ मे आ गया
Thanks sir... Ap explain bhot hi acche trha krte hai❤
Aapke samjhne ka style bahut better h
1 bar m hi bahut ache se samjh gaya very gud techinc
YOU MADE IT SO SIMPLE.... THANK YOU SO MUCH SIR😃😃😃
Most welcome
sir ayesa samjhaya ki mind me baith gya thanku sir
Maza a Gaya ,very refreshing after seeing videos that I cannot understand
Ap bahut acha amchate hai tq sir ji 🙏
Very informative
YOU ARE AN EXCELLENT TEACHER
Bohat Shandar way me explain kia hai. It was a great video.
Apka sikhane ka tareeka bhut hi pyara h
Thank you for your comment.
Thank you sir aapke btane ka tarika bahut achcha hai
You are best teacher of Excel 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.
Glad it helped!
Sir your teaching method is amazing
Bohat zyada samaj aa gaya..
Thanks
Thanks you very much sir apka ye question mere interview me aaj kaam aaya
Sir apka concept bhut clear hai thankyou apne itne achhe se samjhaya
Thank you for your comment
Love you sir sab kuch samajh a gya
superb sir👍 .no one can explain this topic in very simple way.thnk u so much sir
Bohot Dhanyavad. Subscribed.
Bahut hi achha bataya sir 🙏❤️😘
Very Useful 3 Even after 3 years 🔥
Please make more videos like this. I like the way you teach. Extremely helpful and understandable
Bahut अच्छी knowledge थी
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.
Great
Simplest and easiest way of communicating the scenario.
Hatts of
Sir apne bahut achhe se samjhaya Thank you so much ❤ ap drdo k exam k liye bhi video bana diye
best way of teaching
BHAI AAP MST HO , APKI SYNTEX WALI VIDEO BHI MST HAI
CRYSTAL CLEAR CONCEPT... THANK YOU SIR
And, Or aaj time clear hua.. thanks
Excellent teaching!!
Sir your voice is too soft and clear ❤ thanks sir
Great explanation! Easiest and Simple.
Thank you, sir.
Glad it was helpful!
CHOOSE function par ek full dedicated content chahiye!!
Very nice presentation
I understand everything perfectly😎😎😎😎😎😎thenks all
Thanku sir bhut easily smjaya h apne.....
Zabardast samjhaye bhai tum👌😊... Zalzala hai video 🔥
I love your teaching skills
Excellent level teaching 😊
The method of simplifying and summarising is great.
Glad it was helpful!
Bahut badhiya sir
Nice video SIR . Samaj aa gaya
Thank you Sir, It was very simple presentation but effective
शानदार ! धन्यवाद।
Excellent sir
Your way of teaching is very Good Brother . THANKS A LOT
you made it quite simple sir, love from Pakistan ****
Perfect teaching its so clear to understand.