Excel Logical Functions - IF, AND, OR

  Рет қаралды 159,602

Yoda Learning Academy

Yoda Learning Academy

Күн бұрын

In this video, we will learn about How To use Logical Functions in Excel - IF, AND, OR in Advanced Excel for example.
OR: means if any of the given conditions are met then show true.
👉 Join now our QnA Community - bit.ly/335Fic7
00:00 Introduction to Excel Logical Function
00:40 Basic Logical Formula in Excel
01:34 How to use IF Formula in Excel
02:42 How to use AND Function in Excel
03:50 How to use OR Function in Excel
05:12 How to use IF with AND Formula in Excel
05:42 How to use NESTED IF Formula in Excel
👉 Check out Excel tutorial Playlist - • Excel Tips & Tricks
Excel Logical Functions - IF, AND, OR
#logicalfunction #loficalformula #IFformula
Let's Connect:
👉 Follow us on Instagram / yodalearning
👉 Follow our boards at / pins

Пікірлер: 47
@Yodalearning
@Yodalearning 2 жыл бұрын
👉 *_Join now our QnA Community_* - bit.ly/335Fic7
@a.s2791
@a.s2791 2 жыл бұрын
Nicely explained, No Bs, No uselessly long intro, clear voice, you've done a great job, my man.
@Yodalearning
@Yodalearning 2 жыл бұрын
Glad you liked it!
@ainagilani1747
@ainagilani1747 Жыл бұрын
Our man
@giovanniosorio4759
@giovanniosorio4759 3 жыл бұрын
THANK YOUUUUUUUUUUU!!!!! I WAS LOOKING FOR SOMETHING EXACTLY LIKE THIS!!!
@newsandvlogs9130
@newsandvlogs9130 3 жыл бұрын
Very useful video. Dhanyavaad.
@ameeeeesh
@ameeeeesh 3 ай бұрын
THANK YOU SO MUCH, VERY CLEAR, I UNDERSTOOD EVERYTHING, AND YOU ALSO POINTED OUT THE MISTAKES WHICH MADE ME BE CAREFUL BEFOREHAND
@takawirabote4251
@takawirabote4251 9 ай бұрын
Many thanks for this, perfecto 🙅
@sushimi2311
@sushimi2311 Жыл бұрын
You'll save me on my exam, thanks!
@amb.agbesuyiolufemijosh.9319
@amb.agbesuyiolufemijosh.9319 2 жыл бұрын
Awesome!!!
@yurialexkov2797
@yurialexkov2797 3 жыл бұрын
very good and helpful video
@supundikaPriyashani
@supundikaPriyashani Жыл бұрын
Thankyou very much sir...
@mixentertainment9542
@mixentertainment9542 2 жыл бұрын
love you sir, thank you very much
@excoviixbrawler9520
@excoviixbrawler9520 2 жыл бұрын
Good job of explaining short and simple. Easy to understand keep it up.👍
@Yodalearning
@Yodalearning 2 жыл бұрын
Thanks a lot 😊
@chathurangawjd1518
@chathurangawjd1518 3 жыл бұрын
Very helpful video and a Simply explanation, Thanks
@Yodalearning
@Yodalearning 2 жыл бұрын
You are welcome!
@Mountainbiking100
@Mountainbiking100 5 ай бұрын
thank you kind sir, solved my problem, double the IF statement and drop in a vlookup
@ajysingh2038
@ajysingh2038 3 жыл бұрын
very nice explanation. thanks to YLA.
@Yodalearning
@Yodalearning 2 жыл бұрын
Thanks to you
@rajeevgosavi4514
@rajeevgosavi4514 3 жыл бұрын
Very helpful video sir. Concept is quite clear.Thank you. Would appreciate if you could make a video combining all these 3 criteria ( IF,AND & 0R) IN ONE EXAMPLE .
@BaljinderSingh-ju7kt
@BaljinderSingh-ju7kt 2 жыл бұрын
Thanks for the video
@Yodalearning
@Yodalearning 2 жыл бұрын
Our pleasure!
@fifaham
@fifaham 3 жыл бұрын
Good explanation.
@Yodalearning
@Yodalearning 2 жыл бұрын
Glad you liked it
@mdfarhad2938
@mdfarhad2938 2 жыл бұрын
great
@aliahilyana5249
@aliahilyana5249 2 жыл бұрын
i want to ask why i cant use the formula same like the video in my excel ? please help me
@colonybud
@colonybud 2 жыл бұрын
What if you have different worksheets, it’s hard to find scenarios that fit your situation.
@fishmeng8023
@fishmeng8023 10 ай бұрын
hug thank to you sir.
@ayushmishra5778
@ayushmishra5778 2 жыл бұрын
Gd Morning Sir
@ajysingh2038
@ajysingh2038 3 жыл бұрын
Can we subscribe to your online learning for excel topics?
@anisshaikh5325
@anisshaikh5325 4 жыл бұрын
Super
@Yodalearning
@Yodalearning 4 жыл бұрын
Thanks Anis, Keep Learning...
@boswellopio5483
@boswellopio5483 7 ай бұрын
use of v- lookup excel
@cezannevanderwesthuizen3895
@cezannevanderwesthuizen3895 3 ай бұрын
I have a specific question that I don't know how to create a formula for. Please help?
@user-uc2iw5gp8j
@user-uc2iw5gp8j 3 ай бұрын
How to use dates and make a true false ?
@user-ft3vx3ds6t
@user-ft3vx3ds6t 4 ай бұрын
Excel Logical Functions, including IF, AND, and OR, are essential tools for data analysis and decision-making within spreadsheets. They allow users to create custom conditions and perform specific actions based on those conditions. Let's discuss each function briefly. 1. IF Function: The IF function in Excel evaluates a specific condition and returns a value if the condition is met. It has three arguments: logical_test, value_if_true, and value_if_false. The logical_test is the condition to be evaluated, and the function returns value_if_true if the condition is TRUE, and value_if_false if the condition is FALSE. Syntax: =IF(logical_test, value_if_true, value_if_false) Example: =IF(A1>10, "Greater than 10", "Less than or equal to 10") 2. AND Function: The AND function checks whether multiple conditions are true simultaneously. It takes two or more logical tests as arguments and returns TRUE if all the tests are true, and FALSE otherwise. Syntax: =AND(logical1, [logical2], ...) Example: =AND(A1>10, B110, B1
@MyWatchP1
@MyWatchP1 2 жыл бұрын
I am currently working on a file using the IF Function but I am facing some challenges. Can I get your email address so I can send the file to you for help?
@devshr7059
@devshr7059 3 жыл бұрын
bro why it is not working in my laptop
@tiazz9275
@tiazz9275 3 жыл бұрын
It's not working in my pc too 😒
@WaterFlash
@WaterFlash 3 жыл бұрын
btw if shit wont work like me try using ; instead of ,
@excoviixbrawler9520
@excoviixbrawler9520 2 жыл бұрын
Good job of explaining short and simple. Easy to understand keep it up.👍
@Yodalearning
@Yodalearning 2 жыл бұрын
Glad you liked it
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 388 М.
IF AND OR Formula in Excel with MULTIPLE CONDITIONS
17:32
Presentation Mastery
Рет қаралды 626 М.
Khó thế mà cũng làm được || How did the police do that? #shorts
01:00
Me: Don't cross there's cars coming
00:16
LOL
Рет қаралды 15 МЛН
Excel Logical Functions IF, AND, OR
5:26
Syed Shah Zahurullah Hussaini
Рет қаралды 310 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Using the New IFS Function in Excel
11:10
Technology for Teachers and Students
Рет қаралды 144 М.
Excel Logic Functions - IF, AND, and OR
9:59
Six Minutes. Smarter.
Рет қаралды 407 М.
Next level FILTER Function tricks | Excel Off The Grid
13:23
Excel Off The Grid
Рет қаралды 13 М.
10 Advanced IF formulas every analyst should know
21:55
Chandoo
Рет қаралды 197 М.