Excel Logical Functions IF, AND, OR
Рет қаралды 310,843
Күн бұрынExcel Logical Functions IF, AND, OR video demonstration will help you with learning Microsoft Excel logical functions.
In the Excel Logical Functions video demonstration, we will cover how to use IF FUNCTION, how to use OR FUNCTION, and how to use AND FUNCTION.
By the end of this video, you should be able to handle the essential logical functions of Excel and do some handy calculations for your Excel projects.
You may download the practice file using this link: drive.google.com/uc?export=do...
In case you are stuck, add your questions below in the comments section, and I will be happy to help you.
I hope that you're enjoying learning Excel through this Excel learning series with Syed. I request you share these videos with anyone who desires to learn Excel from scratch.
Do subscribe to the channel and enable notifications by clicking on the bell icon to receive updates about new videos as and when they are added to keep up with Excel Learning.
Free Excel Data for Practice: OnlineKnowledgePortal.com/201...
These functions apply to:
Excel 2019, 2007, Excel 2010, Excel 2013, Excel 2016, Office 365, and above
#excelLearningSeries #excel #excel2016 #excelLogicalFunction #HowWeExcel #excelconditionalfunctions
@lalithavishnubhatla6556 Жыл бұрын
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.....
@Syedhussainipage Жыл бұрын
Thank you so much for such lovely feedback, Lalitha. You made my day 🤩. Kindly subscribe to my KZfaq channel KZfaq.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@angeliaandrews4102 9 күн бұрын
You are a very clear and patient teacher. Thank you for all your helpful videos.
@viqaraaltaf3779 2 жыл бұрын
Straight to the point . Great video
@locrianphyrigian3779 3 жыл бұрын
Brilliant! Simple, clear, quick. Thank you!
@Syedhussainipage 3 жыл бұрын
So happy to hear such motivational words. Thank you.
@locrianphyrigian3779 3 жыл бұрын
@@Syedhussainipage You are very welcome. You deserve it!
@mathydee9533 3 жыл бұрын
Short, precise and straight to the point. Great video
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback, it helps me to keep motivated. Please subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@Seftehandle 3 жыл бұрын
really well described, exceeded my expectations!
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback, it truly helps to keep myself motivated. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@thanvirsarif3130 Жыл бұрын
Fantastic Work.....very easy to understand. Thanks Sir!
@Syedhussainipage Жыл бұрын
Thank you for the feedback Thanvir, it helps in keeping me motivated. Kindly subscribe to my KZfaq channel KZfaq.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@abdurrahmanadamu1157 2 жыл бұрын
Short and Precise Great Video tutorial
@fahadmaqsood5636 3 жыл бұрын
sir your method is amazing you made it clear to understand for all watching it
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@BastiaanNetjes 3 жыл бұрын
Thank you! Very clear.
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@Marketingfunfanda 2 жыл бұрын
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
@jerrymiles7804 2 жыл бұрын
Outstanding! Best Regards from Limón, Costa Rica!
@Syedhussainipage 2 жыл бұрын
Thank you for the feedback Jerry, it helps in keeping me motivated. Kindly subscribe to my KZfaq channel KZfaq.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@haidarjetaria6580 2 жыл бұрын
best explenasion in youtube!
@ayazhussain3635 11 ай бұрын
Concise but detailed demonstration.
@Syedhussainipage 10 ай бұрын
I am happy to hear that, thank you for the helpful feedback 😃
@xammydoh Жыл бұрын
thanks men
@user-ls7lv9he8b 2 жыл бұрын
What a nice explanation!
@Syedhussainipage 2 жыл бұрын
Thank you so much for the feedback. It really helps me to keep motivated. 🙂
@madhurisharma946 Жыл бұрын
thank you!!
@Syedhussainipage 10 ай бұрын
You're welcome!
@sivarath29 Жыл бұрын
great video . i have my exam tommorow this is really helpful
@MohamedAlaa-lh6mo Жыл бұрын
thanks it was really useful
@dakshkumar873 2 жыл бұрын
Thank you sir.
@doctorzacs Жыл бұрын
Rad, thank you!
@aziztalha727 8 ай бұрын
What would be more perfect than this video ❤
@Syedhussainipage 8 ай бұрын
Thank you so much for such lovely feedback, Aziz. You truly made my day 🤩. If you haven't already, please subscribe to my KZfaq channel KZfaq.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@meenaalturki7660 3 жыл бұрын
finally someone can explain clearly
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@arsalanchaush6229 3 жыл бұрын
Thank you sir it is very helpful for me
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@nshobharani7896 3 жыл бұрын
Really thank you Sir very nice explanation
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@divinefavour9329 Ай бұрын
Good Teaching ❤❤❤
@ghufranranjha9700 Жыл бұрын
wow😮😮😮
@mrCetus 2 жыл бұрын
Amazing 😊
@Mrfahadaslam1 3 жыл бұрын
Thanks very helpful
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@christiantetteh9610 Жыл бұрын
Great video.
@kallushare 3 жыл бұрын
ASAKM, nicely explained i like to learn more functions in excel can you please guide me or mention your video detials jazakallah
@Syedhussainipage 3 жыл бұрын
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 KZfaq channel kzfaq.info
@GeorgeEmmanuelMA 3 жыл бұрын
Its good topic sir
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@stumpster671 3 жыл бұрын
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!
@Syedhussainipage 3 жыл бұрын
Would you please share some sample data with your query on my email hussaini.syed@gmail.com and i can take a look
@mohammadhyder3273 2 жыл бұрын
Really it is beautiful Explaination Sir... Ur voice is so sweet.. Tqs sir
@Syedhussainipage 2 жыл бұрын
Thank you for the feedback Mohammad, it helps in keeping me motivated. Kindly subscribe to my KZfaq channel KZfaq.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@manojkumarexcel 3 жыл бұрын
Good
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
@boholandiastore3504 2 жыл бұрын
Sir, do you have tutorial using if function if i want the result in 3 category, instead of 2, example "underpaid", "overpaid", "exactlypaid"
@Syedhussainipage 2 жыл бұрын
Hello Boholandia, Thank you for your message. Did you see this kzfaq.info/get/bejne/kNmoeNZit56cn3U.html let me know if it helps. Best Regards, Syed H
@mohamedconteh3289 2 жыл бұрын
@@Syedhussainipage
@ganesanrao8735 2 жыл бұрын
👍👍👍👍👍
@Sorites Жыл бұрын
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"?
@govardhaniy1222 Жыл бұрын
just combine if & and function then later mention your tag pass/ fail. if(and(b3
@vikingraven4156 Жыл бұрын
where is other video, had trouble with last part?
@dusk3854 2 жыл бұрын
Sank u so mush ser i em using zis vediow in icay tay lol uwu
@cindyben3089 Жыл бұрын
I watched 15 IF functions videos before I found your. Step-showed TAB instead of just saying the word.
@l-0-0l 3 жыл бұрын
3:57 saying they all failed the test isn't quite right, they didn't fail the test
@Syedhussainipage 3 жыл бұрын
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
@TikMojTube 3 жыл бұрын
Sir if test is failed then I want it to show nothing not even 0 what should i type
@Syedhussainipage 3 жыл бұрын
Just type "" and it will set it to blank
@shailuddin2799 2 жыл бұрын
Where is the other video of this sir
@Syedhussainipage 2 жыл бұрын
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. kzfaq.info/sun/PLEvKN_6AClrhT1h_ePfPT5dgUhElJ4mPJ
@diwashkhatri5930 3 жыл бұрын
HOW CAN WE DO FOR MORE THAN 5 SUBJECT ?
@Syedhussainipage 3 жыл бұрын
Yes you can, how many are you planning to go for?
@chamthkawsalya456 Жыл бұрын
මරැ
@Aliojena 2 жыл бұрын
next video?
@car_specialist 2 жыл бұрын
it doesnt work to me...
@Syedhussainipage 2 жыл бұрын
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.
@amolsutar1147 2 жыл бұрын
ha...ha....ha.....
@Syedhussainipage 2 жыл бұрын
I'm glad you found it haha funny. Let me know if you need any help. Have a great day ahead!
@deepakmeerchandani3392 Жыл бұрын
Harry Potter series and Marvel's 😂😂
@Syedhussainipage Жыл бұрын
I may start with more characters from Hollywood soon 🤣 Suggest to me if you want to see any of them in specific 😆
@user-ft3vx3ds6t 4 ай бұрын
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.
@rudrabhungaliya 2 жыл бұрын
Harry Potter 😂
@Appsandtechnicalsupport 2 жыл бұрын
अगर कोई स्टूडेंट सभी 6 विषयों में 17 या इससे कम अंक लाता है तो फैल दिखाए,,, और कोई स्टूडेंट सभी विषयों में "0" लाता है तो absence दिखाए इसके लिए क्या फार्मूला लगाया जाए और कैसे लगाया जाए सर कृपया समाधान करें
@Syedhussainipage 2 жыл бұрын
जहां तक मुझे समझ आया है, आप चाहते हो की 17 या उससे ज्यादा लाने वाला पास होगा और 16 या उससे कम लाने वाला फेल और सब में 0 लाने वाला एब्सेंट। आप अगर 2:06 से वीडियो को देखेंगे तो आप यह अपने आप कर पाएंगे। अगर फिर भी आपको दिक्कत आ रही हो तो मुझे सैंपल डाटा भेजिए जिसे देख कर मैं आपकी अधिक सहायता कर पाऊंगा। नीचे दिए गए लिंक का इस्तेमाल करके अपना सैंपल डाटा भेजें। forms.gle/CxaWGeqdugMktWPx6
@Appsandtechnicalsupport 2 жыл бұрын
@@Syedhussainipage मै एक टेस्ट फोर्मेट भेजा हूँ पर मेरे से नही हो पा रहा है आप करके भेजे सर
@Appsandtechnicalsupport 2 жыл бұрын
@@Syedhussainipage अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए
@Syedhussainipage 2 жыл бұрын
@@Appsandtechnicalsupport डाटा भेजने के लिए शुक्रिया, मैं आपको कल तक जवाब भेज दूंगा। मैं आज सफर कर रहा हू।
@Appsandtechnicalsupport 2 жыл бұрын
मुझे mail कीजियेगा सर
@nazarmohyuddin7043 2 жыл бұрын
oh bhai angrezon ko tau sara pta hy
@Syedhussainipage 2 жыл бұрын
Yeh ghalat-fahmi hai bhai aapki.
@user-cd5fp9zi6t 2 ай бұрын
wrok on your english accent
@AjaySharma-tv6qz Жыл бұрын
mashallha mola bless you brother
@halwahekya3345 3 жыл бұрын
Amazing 😊
@Syedhussainipage 3 жыл бұрын
Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZfaq channel kzfaq.info for regular updates. Best Regards, Syed H
Jopa Excel
Рет қаралды 147 М.
TeachExcel
Рет қаралды 620 М.