10 Advanced IF formulas every analyst should know

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=-yFpzIRifK4

Almost 70% of spreadsheets contain IF formula. So how well do you know it? In this ADVANCED video, learn all about: • -- Using IF to check ONLY One of condition • -- Any Two out of Three conditions • -- Between condition with MEDIAN function • -- Replacing nested if formulas with NEW IFS function • -- Speeding up IF logic with Boolean replacement hack • -- Check List membership • -- Using Arrays with if (MedianIF example) • -- Wildcard comparisons in IF formula • -- Using IF with Conditional Formatting • -- IF + Charts for awesome results • Timestamps: • =========== • 0:00 - Intro • 0:25 - Only One of condition (XOR) • 2:12 - Any two out of three conditions • 4:58 - Between formula (AND method MEDIAN method) • 7:00 - Nested IF replacement with IFS() • 9:03 - Pop Quiz • 9:16 - Avoiding IF formulas with Boolean Replacement Hack • 11:42 - List membership check with IF formula • 13:35 - Using Arrays with IF - Median IF example • 16:10 - Wildcard check with IF • 17:45 - Conditional formatting with IF • 19:48 - Charts with IF formula • 21:23 - Closing remarks • Example files: • =========== • https://chandoo.org/wp/advanced-if-tr... • 👉Checkout my online course on Advanced Excel Data analysis • =================================================== • 💻📗💥 https://chandoo.org/wp/excel-school-p... • • • #IFLove #Excel

#############################

New on site