Brother my sincere n heartful thanx n gratitude. So many explained it but Bro You are truly n undoubtedly the perfect teacher.... God bless you n keep you safe Bro.....
Thank you so much for such lovely feedback, Lalitha. You made my day 🤩. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
The most precisely and perfectly explained video I have ever come across on TH-cam. May Allah give you better Health ,keep educating people. Thank you so much for the outstanding tutorial.
Thank you for the feedback, it helps me to keep motivated. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback Thanvir, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you so much for such lovely feedback, Aziz. You truly made my day 🤩. If you haven't already, please subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Jerry, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback, it truly helps to keep myself motivated. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback Mohammad, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Having problems making this formula work. =if(AND(C2:C1760), "Out of range", " ") *example* Just need to find what number is out of range. I have over 1000 entries over 16 books. Can use the help....Ty!
Thank you for your valuable inputs, it truly helps. You may visit this page which I will keep updating with all the videos in the series myknowledgeportal.com/microsoft-excel-tutorials/ or follow the playlist on my channel TH-cam channel th-cam.com/users/hussainisyed
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
You're right, it's not the test they failed but the analysis criteria where if the output is False, the candidate is passed. You may try it differently, this was purely for instructional purpose. Let me know if you have any questions. Regards, Syed H
Hello there!, Can you please let me know which video are you referring to so that I can help you. If you are looking for series, please check out the link below for the playlist. th-cam.com/play/PLEvKN_6AClrhT1h_ePfPT5dgUhElJ4mPJ.html
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
अगर कोई स्टूडेंट सभी 6 विषयों में 17 या इससे कम अंक लाता है तो फैल दिखाए,,, और कोई स्टूडेंट सभी विषयों में "0" लाता है तो absence दिखाए इसके लिए क्या फार्मूला लगाया जाए और कैसे लगाया जाए सर कृपया समाधान करें
जहां तक मुझे समझ आया है, आप चाहते हो की 17 या उससे ज्यादा लाने वाला पास होगा और 16 या उससे कम लाने वाला फेल और सब में 0 लाने वाला एब्सेंट। आप अगर 2:06 से वीडियो को देखेंगे तो आप यह अपने आप कर पाएंगे। अगर फिर भी आपको दिक्कत आ रही हो तो मुझे सैंपल डाटा भेजिए जिसे देख कर मैं आपकी अधिक सहायता कर पाऊंगा। नीचे दिए गए लिंक का इस्तेमाल करके अपना सैंपल डाटा भेजें। forms.gle/CxaWGeqdugMktWPx6
@@Syedhussainipage अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए
The Excel logical functions IF, AND, and OR are used for decision-making and performing logical comparisons in Excel formulas. - The IF function is used to return one value if a condition is true and another value if it's false. - The AND function is used to require multiple conditions to be true at the same time, returning TRUE only if all conditions are met. - The OR function is used to require at least one of multiple conditions to be true, returning TRUE if any condition is met. The IF function can be combined with the AND and OR functions to create more complex logical tests in Excel formulas.
Please let me know a bit more about what's not working, the steps you have performed, and where you are facing the issue so that I can help you with that.
Brother my sincere n heartful thanx n gratitude. So many explained it but Bro You are truly n undoubtedly the perfect teacher.... God bless you n keep you safe Bro.....
Thank you so much for such lovely feedback, Lalitha. You made my day 🤩.
Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
The most precisely and perfectly explained video I have ever come across on TH-cam. May Allah give you better Health ,keep educating people. Thank you so much for the outstanding tutorial.
@@GolamNur-f3e Thank you for this lovely comment. It truly makes me happy.
You are a very clear and patient teacher. Thank you for all your helpful videos.
Short, precise and straight to the point. Great video
Thank you for the feedback, it helps me to keep motivated.
Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Brilliant! Simple, clear, quick. Thank you!
So happy to hear such motivational words. Thank you.
@@Syedhussainipage You are very welcome. You deserve it!
Thank you ! you're a life saver
@@poojithac1643 Thank you for the lovely feedback. I'm happy I was able to help.
sir your method is amazing you made it clear to understand for all watching it
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Fantastic Work.....very easy to understand. Thanks Sir!
Thank you for the feedback Thanvir, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Concise but detailed demonstration.
I am happy to hear that, thank you for the helpful feedback 😃
What would be more perfect than this video ❤
Thank you so much for such lovely feedback, Aziz. You truly made my day 🤩.
If you haven't already, please subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Straight to the point . Great video
Outstanding! Best Regards from Limón, Costa Rica!
Thank you for the feedback Jerry, it helps in keeping me motivated.
Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
best explenasion in youtube!
really well described, exceeded my expectations!
Thank you for the feedback, it truly helps to keep myself motivated. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Short and Precise
Great Video tutorial
finally someone can explain clearly
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
great video . i have my exam tommorow this is really helpful
Really fantastic vedio with great learning experience 👍 God bless u sir I hope if u upload this kind of vedio regularly it will be great everyone
Good Teaching ❤❤❤
Good 👍🏾
@@lawrenceNG-k3q Thank you for the helpful feedback!
very special thanks
@@IssaIsmayelHelew You are welcome! If there is anything else or another topic you would like me to cover, just let me know.
What a nice explanation!
Thank you so much for the feedback. It really helps me to keep motivated. 🙂
thanks men
Thank you! Very clear.
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Really it is beautiful Explaination Sir... Ur voice is so sweet.. Tqs sir
Thank you for the feedback Mohammad, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Having problems making this formula work. =if(AND(C2:C1760), "Out of range", " ") *example*
Just need to find what number is out of range. I have over 1000 entries over 16 books. Can use the help....Ty!
Would you please share some sample data with your query on my email hussaini.syed@gmail.com and i can take a look
Rad, thank you!
thanks it was really useful
ASAKM, nicely explained i like to learn more functions in excel can you please guide me or mention your video detials
jazakallah
Thank you for your valuable inputs, it truly helps. You may visit this page which I will keep updating with all the videos in the series myknowledgeportal.com/microsoft-excel-tutorials/ or follow the playlist on my channel TH-cam channel th-cam.com/users/hussainisyed
thank you!!
You're welcome!
Really thank you Sir very nice explanation
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Great video.
wow😮😮😮
Thank you sir it is very helpful for me
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Thanks very helpful
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
I watched 15 IF functions videos before I found your. Step-showed TAB instead of just saying the word.
Thank you sir.
Amazing 😊
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Its good topic sir
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
So what if I want it to be an "and" function, but I want it to result in a specific word instead of just "pass" or "fail"?
just combine if & and function then later mention your tag pass/ fail.
if(and(b3
where is other video, had trouble with last part?
3:57 saying they all failed the test isn't quite right, they didn't fail the test
You're right, it's not the test they failed but the analysis criteria where if the output is False, the candidate is passed. You may try it differently, this was purely for instructional purpose.
Let me know if you have any questions.
Regards,
Syed H
Sir, do you have tutorial using if function if i want the result in 3 category, instead of 2, example "underpaid", "overpaid", "exactlypaid"
Hello Boholandia,
Thank you for your message. Did you see this th-cam.com/video/ZsxEs1R88oA/w-d-xo.html let me know if it helps.
Best Regards,
Syed H
@@Syedhussainipage
👍👍👍👍👍
Where is the other video of this sir
Hello there!,
Can you please let me know which video are you referring to so that I can help you.
If you are looking for series, please check out the link below for the playlist.
th-cam.com/play/PLEvKN_6AClrhT1h_ePfPT5dgUhElJ4mPJ.html
Good
Thank you for the feedback. I am so glad to hear that. Do subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Sank u so mush ser i em using zis vediow in icay tay lol uwu
Sir if test is failed then I want it to show nothing not even 0 what should i type
Just type "" and it will set it to blank
HOW CAN WE DO FOR MORE THAN 5 SUBJECT ?
Yes you can, how many are you planning to go for?
अगर कोई स्टूडेंट सभी 6 विषयों में 17 या इससे कम अंक लाता है तो फैल दिखाए,,, और कोई स्टूडेंट सभी विषयों में "0" लाता है तो absence दिखाए इसके लिए क्या फार्मूला लगाया जाए और कैसे लगाया जाए सर कृपया समाधान करें
जहां तक मुझे समझ आया है, आप चाहते हो की 17 या उससे ज्यादा लाने वाला पास होगा और 16 या उससे कम लाने वाला फेल और सब में 0 लाने वाला एब्सेंट।
आप अगर 2:06 से वीडियो को देखेंगे तो आप यह अपने आप कर पाएंगे।
अगर फिर भी आपको दिक्कत आ रही हो तो मुझे सैंपल डाटा भेजिए जिसे देख कर मैं आपकी अधिक सहायता कर पाऊंगा।
नीचे दिए गए लिंक का इस्तेमाल करके अपना सैंपल डाटा भेजें। forms.gle/CxaWGeqdugMktWPx6
@@Syedhussainipage मै एक टेस्ट फोर्मेट भेजा हूँ पर मेरे से नही हो पा रहा है आप करके भेजे सर
@@Syedhussainipage अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए
@@Appsandtechnicalsupport डाटा भेजने के लिए शुक्रिया, मैं आपको कल तक जवाब भेज दूंगा। मैं आज सफर कर रहा हू।
मुझे mail कीजियेगा सर
The Excel logical functions IF, AND, and OR are used for decision-making and performing logical comparisons in Excel formulas.
- The IF function is used to return one value if a condition is true and another value if it's false.
- The AND function is used to require multiple conditions to be true at the same time, returning TRUE only if all conditions are met.
- The OR function is used to require at least one of multiple conditions to be true, returning TRUE if any condition is met.
The IF function can be combined with the AND and OR functions to create more complex logical tests in Excel formulas.
it doesnt work to me...
Please let me know a bit more about what's not working, the steps you have performed, and where you are facing the issue so that I can help you with that.
මරැ
next video?
Harry Potter series and Marvel's 😂😂
I may start with more characters from Hollywood soon 🤣
Suggest to me if you want to see any of them in specific 😆
Harry Potter 😂
ha...ha....ha.....
I'm glad you found it haha funny. Let me know if you need any help.
Have a great day ahead!
oh bhai angrezon ko tau sara pta hy
Yeh ghalat-fahmi hai bhai aapki.
wrok on your english accent
mashallha mola bless you brother
Amazing 😊