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.
📥 Download this Advanced IF Function Tips for Excel workbook so you can practice along with us: https://www.myexcelonline.com/blog/if-function-combined-with-the-and-function/
⌚ 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…
Join Now ► https://www.myexcelonline.com/107-42.html
📚 Download Our Free 101 Excel Tips & Tricks E-Book: https://www.myexcelonline.com/101-excel-tips-e-book-youtube-channel
💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: https://www.myexcelonline.com/107-125.html
🔥 OUR BEST EXCEL RESOURCES 🔥
Get All Our Excel E-Books: https://go.myexcelonline.com/101-excel-formulas-1616369600448
101 Most Popular Formulas Paperback on Amazon: https://www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: https://www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: https://www.amazon.com/Best-Excel-Tips-Tricks-MyExcelOnline-com/dp/B08Z9W125P
👷 Excel Consulting Services: https://www.myexcelonline.com/microsoft-excel-consulting-services/
💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: https://www.youtube.com/channel/UCMaVSMuAqV5j9WRdUz9UQfw
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 🙂
Chief Inspirational Officer & Microsoft MVP
❤️ Let’s connect on social ❤️