Excel IF Function (including multiple conditions)

The Excel IF function is one of the most popular Excel functions. This video shows how to use the IF function, how the arguments work, and provides several options for using IF with 2, 3, or more (multiple) conditions. These include:
-Nested IF/IF
-AND
-OR
-IFS

Chapters in this video:
00:00 - Introduction
00:14 - IF
01:12 - Nested IF
02:38 - AND / OR
04:22 - IFS

and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

[Easyhaypp]

I am from Germany and my English is not really great and yet can I understand every word you say. It's because you speak so casually and professionally. I enjoy watching a few of your videos every night and I have a lot of fun watching your videos

Best Danke 🙏🏽

[dvkiwi]

I have been fighting and fighting and fighting this for DAYS and lo and behold, found this, fluffed about and OMG IT Thank

[jayhenayon]

I am glad I found this video. It's been more than 1 week trying to figure out what functions should I use for multiple arguments. This video answered my questions. And my project is done. Thank you so much!

[NabBCB]

What a great little blurb on IF Functions! IFS have been scratching my brain for the better half of today... Super grateful for your content - I've happily subscribed! :)

[PaulEBrownbill]

Thanks, good overview which is easy to understand. Paul

[expldegaming]

You are absolutely stellar. Thank you so much for your videos. Just found your channel and it has helped SO much. Easily the most deserved sub I've ever given.

[VAA]

Greatly appreciate the detailed explanations

[YogeshPatil-wfew]

Really Helpful....Simple and sweet explanations.

[CliffBarber]

Great explanation thanks! Also congrats on completing the Souix Falls Marathon :-)

[igsram]

Hi! Can the IF function and the AND function be combined to check an table array of multiple values?

Supposing I have name of the person in one array and the departments in another array, , how to use the IF and AND Function?

[hanrealistic]

can you test this with an example on 3 or 4 columns please?

[msalimn]

Sir help me in defining (Excel format)
IF "Duration less than 10 years" AND "Achievement 100%", then return 1000 or IF "Duration less than 10 years" AND "Achievement >=105%" then return 1500 OR IF "Duration more than 10 years" AND "Achievement >=100%" then return 2000

[matt]

I have a question...I have a drop down menu of categories(>25) that all determine different percentage fees based on the selected category relative to the purchase price. Can I use an 'if' function to input a formula based on the category selected and the price of an item to yield a fee?

[shaunalee]

HELP! I am trying to create an if formula based on text. In one box I have the name of a ship. I would like it to return the capacity of that ship. I have multiple ships and each has a different capacity I know this could potentially be a very long formula but it would save me so much time I am willing to put in the work. Any help is appreciated!

[collegeguy]

Hi sir, I'm trying to create a spreadsheet that will keep track of my studying and preparation for a big exam. I'm using space repetition to learn. So in my spreadsheet I have the date that I studied and I would like to add different values to this date depending on the ranking I give it. So for example, if I studied a Economics today but I don't feel like I know the material well I'll rank it a 3 (in a scale 1-10) and it will add 2 days from my last study session whereas a 10 will set it 21 days later. How can I do this? Thank you.