Advanced IF Function Tips for Excel

Watch this video to learn Advanced ways to use the Excel IF Function! In this Advanced IF Function Tips for Excel tutorial, you are going to learn a few basic tips for advanced logic in the Excel IF Function.

This is a great video for Beginner or Intermediate Excel users and it shows several Advanced examples of the Excel IF Function.

This Advanced IF Function Tips for Excel tutorial was recorded using Microsoft Office 365.

⌚ Time Stamps:
00:00 - Introduction
00:25 - Explanation of Spreadsheet
01:27 - Usng OR Within an IF Statement
03:20 - Locking Excel Reference Cells
04:27 - Usng AND Within an IF Statement
05:09 - Using a Simple IF
06:06 - Sum a Nested IF and Use IF to Evaluate Results
09:05 - Using IFS to return case specific criteria for 4 criteria
12:09 - Inserting Emojis
13:04 - Review
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline #MsExcel #IF #Excel

[johnreeve]

Two criteria is what I needed, thank you.

[bskrmusic]

Thanks a lot for Informative session !

[patrickschardt]

Informative and straight to the point. Plus you make them the length they need to be. Some are short and some are long

Also what’s your name? I know John’s name but not yours

To reduce the number of IF statements, couldn’t you reference all 3 values in the table, TRANSPOSE them, and then compare them to all the threshold values?
Example for at least one criteria —>
Two criterion example —>
All 3 criterion example —>