10 Advanced IF formulas every analyst should know

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-tricks/ 👉Checkout my online course on Advanced Excel & Data analysis =================================================== 💻📗💥 https://chandoo.org/wp/excel-school-program/ #IFLove #Excel