Excel 2013: IF, AND & OR Functions

1,109 views · Published 29 August 2017 · 9:48 · Indexed 23 October 2026

Channel: Kirt Kershaw · 2017 · Education

Watch on YouTube

Excel 2013 training video on the IF function that will return a value if the logical test meets a condition you set that is true, and if false, another value you can choose to return, if any at all.  The AND function requires that two or more conditions or criteria be met to make the result true and thereby return the desired value, as opposed to the OR function where any one of two or more conditions can be met in order to return desired result.  You can watch how I combine the IF, AND, OR functions in this Excel 2013 training video.

All 157 of my Excel 2013 training videos contain everything you need to help pass both the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007.  New videos will be constantly uploaded to Patreon so you will get new content: Visit and sign up at:
https://www.patreon.com/KirtKershaw 

DVD & DOWNLOAD AVAILABLE: 
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET'S CONNECT!
-- http://www.facebook.com/KirtKershaw 
 
-- http://www.linkedin.com/in/kirt-kershaw-33874410

More from this channel