How to use IF, AND and OR in Excel (it's easier than you think)
If you have some logic formulas that use AND and OR, it's simple to add a IF function to clean up your results. For your convenience, topic time codes are listed below.
This is the final video of a 3-part series on logic functions.
In video 1 ( • The AND function and OR function in Excel ... ) and video 2 ( • How to combine AND and OR in Excel to test... ) you saw how to use AND and OR to test data in a table and flag any row where particular conditions are true. And then how to combine them into a super-formula.
In this video I show you how bring another logic function into play – IF – to tidy up your TRUE and FALSE answers into a much more usable format.
😃 TIME CODES (click the link to go directly to that spot in the video)
(0:00) Intro
(0:45) The problem with just using AND and OR functions
(0:56) A reminder of how the IF function works
(1:10) How to modify the existing formula to incorporate the IF function
(1:46) How to display nothing (a blank cell) if the condition is FALSE
(1:52) The result of the new formula that combines AND, OR and IF
(2:05) How to modify the IF function to give a different result
How did this video help you? What is the ONE most most valuable tip you took away? Let me know by adding a quick comment below and click thumbs up button under the video! Much appreciated.
😃 USEFUL LINKS:
Share this Video:
• How To Create Multilevel Numbering In Word...
😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrel...
😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-trouble...
😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
/ officemastery
/ jkmorrell
/ jasonmorrell
Have a fantastic day!