618,315 views
CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE 16-CLASS EXCEL MINI-COURSE: http://bit.ly/2syP4BG To receive daily Microsoft Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel tips and Excel tricks so that you can develop in this tool! ----------------------------------------------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/f... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- TOP Videos: ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • How to make your Excel spreadsheet more beautiful and impress your boss • How to make your Excel spreadsheet more beauti... ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make a Table D... ► Learn EVERYTHING about how to create GRAPHICS in EXCEL • Learn EVERYTHING about how to create GRAPHICS... ----------------------------------------------------------------------- In today's video we are going to talk about a formula that is well known to you, the if function in Excel. What we are going to do differently is to show two other functions along with it, because this way we can form an if function in Excel with 3 conditions. These two auxiliary formulas that we are going to use together with the if function in Excel are: the AND function in Excel and the OR function in Excel. Both functions work in the same way that we use words, that is, we use AND when we want two or more things to happen necessarily and we use OR to accept that one thing OR another happens, without the need for both to happen. In today's class we are going to talk a lot about these two formulas and also about the if formula in Excel with 3 conditions. Not necessarily 3, but anything above a condition in the if formula in Excel you could use the AND and OR formulas to help you. ----------------------------------------------------------------------- #excel #vba #hashtagtraining