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