Excel Logical Functions - IF, AND, OR

[@Yodalearning]

👉 *_Join now our QnA Community_* - bit.ly/335Fic7

[@a.s2791]

Nicely explained, No Bs, No uselessly long intro, clear voice, you've done a great job, my man.

[@Yodalearning]

Glad you liked it!

[@ainagilani1747]

Our man

[@vasiliskout8601]

The only video i understood. Congratulations!

[@giovanniosorio4759]

THANK YOUUUUUUUUUUU!!!!! I WAS LOOKING FOR SOMETHING EXACTLY LIKE THIS!!!

[@ameeeeesh]

THANK YOU SO MUCH, VERY CLEAR, I UNDERSTOOD EVERYTHING, AND YOU ALSO POINTED OUT THE MISTAKES WHICH MADE ME BE CAREFUL BEFOREHAND

[@rlove9730]

One of the BEST tutorials I've found used!!!!!

[@benita3567]

Thank you! Your explanation was immaculate!🤩

[@sushimi2311]

You'll save me on my exam, thanks!

[@vramarathnam]

you have choen a topic worth explaining. Good efforts and good teaching. Thank You. All the best

[@michaeljoshua4503]

Man, you can teach!!!! I understood it

[@Mountainbiking100]

thank you kind sir, solved my problem, double the IF statement and drop in a vlookup

[@excoviixbrawler9520]

Good job of explaining short and simple. Easy to understand keep it up.👍

[@Yodalearning]

Glad you liked it

[@JP-ed5lh]

Very well and clearly explained 👏👏

[@colonybud]

What if you have different worksheets, it’s hard to find scenarios that fit your situation.

[@newsandvlogs9130]

Very useful video. Dhanyavaad.

[@takawirabote4251]

Many thanks for this, perfecto 🙅

[@fifaham]

Good explanation.

[@Yodalearning]

Glad you liked it

[@ВиталийОвчаренко-т7й]

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

[@aliahilyana5249]

i want to ask why i cant use the formula same like the video in my excel ? please help me

[@ajysingh2038]

Can we subscribe to your online learning for excel topics?

[@supundikaPriyashani]

Thankyou very much sir...

[@cezannevanderwesthuizen3895]

I have a specific question that I don't know how to create a formula for. Please help?

[@chathurangawjd1518]

Very helpful video and a Simply explanation, Thanks

[@Yodalearning]

You are welcome!

[@ajysingh2038]

very nice explanation. thanks to YLA.

[@Yodalearning]

Thanks to you

[@rajeevgosavi4514]

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 .

[@amb.agbesuyiolufemijosh.9319]

Awesome!!!

[@mixentertainment9542]

love you sir, thank you very much

[@boswellopio5483]

use of v- lookup excel

[@BaljinderSingh-ju7kt]

Thanks for the video

[@Yodalearning]

Our pleasure!

[@rogerb737-z9w]

How to use dates and make a true false ?

[@yurialexkov2797]

very good and helpful video

[@ayushmishra5778]

Gd Morning Sir

[@ItachiUchiha-bb9jn]

Rather than using multiple functions, In this case using 'IFS' would be much easy method.

[@emmanuelmwakyolile6592]

OR function confusing the symbol of ask.

[@devshr7059]

bro why it is not working in my laptop

[@tiazz9275]

It's not working in my pc too 😒

[@fishmeng8023]

hug thank to you sir.

[@mdfarhad2938]

great

[@anisshaikh5325]

Super

[@Yodalearning]

Thanks Anis, Keep Learning...

[@MyWatchP1]

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?

[@WaterFlash]

btw if shit wont work like me try using ; instead of ,

[@excoviixbrawler9520]

Good job of explaining short and simple. Easy to understand keep it up.👍

[@Yodalearning]

Thanks a lot 😊