Скачать с ютуб The AND function and OR function in Excel formulas (with examples) в хорошем качестве

The AND function and OR function in Excel formulas (with examples)

Discover how the AND function and OR function provide an easy way in Excel to flag data that meets certain conditions. For your convenience, topic time codes are listed below. All logic functions in Excel work with conditions that have TRUE or FALSE answers. ‘AND’ allows you to test multiples things and if they are ALL true then your AND formula result is true. ‘OR allows you to test multiples things and if ANY of them are true then your OR formula result is true. Both of these functions provide an easy way to test data in a table and flag any row where particular conditions are true. This is the first of a 3-video series. In the next video (   • How to combine AND and OR in Excel to...  ) you’ll see how to combine AND functions and OR functions into one super-formula. That’s where the magic really happens. 😃 TIME CODES (click the link to go directly to that spot in the video) (0:00) Intro (0:29) My example table (0:51) Overview of the AND function (0:59) Overview of the OR function (1:07) What is a LOGICAL and what are the 3 parts that make a logical? (1:18) 2 examples of a LOGICAL (1:45) Example 1: AND function to flag any Plasterer who drives a Holden (2:24) Why it's useful to use the fx button (3:23) Example 2: AND function to flag any QLD tradie charging less than $60 per hour (apology - in the video I say "check Trade" instead of "check State") (4:22) Example 3: OR function to flag any Brickie or Roofer (5:02) Introducing the next video (   • How to combine AND and OR in Excel to...  ) which takes the concept further I trust you found this video useful. What ONE thing resonated with you the most? Let me know by adding a quick comment below and click the thumbs up button under the video! Much appreciated. 😃 USEFUL LINKS: Share this Video:    • The AND function and OR function in E...   😃 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!