Excel IF Function (including multiple conditions)

[@GrenadeDave]

This is exactly what i was looking for THANK YOU!!!!!!

[@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! :)

[@dv8kiwi]

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

[@ExcelU]

Awesome ... glad you got it working, and thanks for your kind comment :)

[@jayhenayon8251]

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!

[@expl0degaming298]

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.

[@ExcelU]

Thank you for your kind note … and welcome :)

[@PaulEBrownbill]

Thanks, good overview which is easy to understand. Paul

[@YogeshPatil-wf4ew]

Really Helpful....Simple and sweet explanations.

[@ExcelU]

Glad you think so!

[@VAA1962]

Greatly appreciate the detailed explanations

[@ExcelU]

Glad you liked it

[@CliffBarber]

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

[@ExcelU]

Thank you :)

[@aravindrameshpiano]

Thank you for the tutorial, sir.

[@ExcelU]

You bet!

[@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 🙏🏽

[@ExcelU]

Thank you for your kind note, and I'm glad my videos are helpful :)

[@MyDearFriend]

great video!!!!!!!!!!!!

[@ExcelU]

Glad you enjoyed it! You're invited to get free Excel tips straight to your inbox, sign up here www.excel-university.com/subscribe/

[@LittleMissVigor]

I'm SO glad I found you because you explain this so well. HOWEVER... this particular option seems not to apply to my situation: I have two columns; I want to return $30 if only one is checked (I use an "x" as a check), $60 if both are checked, but $0 if none is checked. I can't figure out, for the life of me, how the heck to do that. HAAAALP!!!

[@ramyadel4881]

Thanks alot

[@ExcelU]

Most welcome

[@hanrealistic]

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

[@igsram233]

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?

[@matt81487]

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?

[@ExcelU]

I hope this video helps with your question: kzbin.info/www/bejne/qHWaqWemid92j9U Thanks Jeff

[@collegeguy799]

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.

[@msalim394n10]

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

[@shaunalee2522]

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!

[@shaunalee2522]

For instance, the capacity of the Norwegian Bliss is 4004. The capacity of the Norwegian jewel is 2974. I would like the function to pop up the correct capacity based on the ship in an adjacent box.

[@srinivascv2001]

Text is displayed,pl edit and upload

[@KhaLed-pb4pu]

so what about having 5 functions? 8? more? it says: You've entered too many arguments for this function.