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

Видео 10 Advanced IF formulas every analyst should know канала Chandoo