Uploaded April 2023 | Updated November 2026, 1 hour ago
I took our 1,121 character long nested IF formula and made it 80% shorter. In this fun and insightful video, let me show you how I made that happen.
Welcome to the "Honey, I shrunk" series.
In this video β±
=============
0:00 - The long nested IF formula for calculating discount rate
1:15 - Making the original long formula.
4:10 - How I shrunk the formula.
π Sample file with the formula + explanation
======================================
To know more about this problem and get the sample data, visit π
chandoo.org/wp/a-clever-technique-to-simplify-your-long-nested-if-formulas
π Do more with SUMIFS
=====================
Want to unlock the godly powers of SUMIFS? Check out below article + two videos.
π° Basics of SUMIFS - chandoo.org/wp/introduction-to-excel-sumifs-formula
SUMFS - 15 practical uses - youtu.be/B5hayFelHDU
SUMIFS - 10 advanced examples - youtu.be/YEt-aYbDTrs
On XLOOKUP - youtu.be/DDlZXXEI1bU
~
#Ishrunktheformulas #excel
I took our 1,121 character long nested IF formula and made it 80% shorter. In this fun and insightful video, let me show you how I made that happen.
Welcome to the "Honey, I shrunk" series.
In this video β±
=============
0:00 - The long nested IF formula for calculating discount rate
1:15 - Making the original long formula.
4:10 - How I shrunk the formula.
π Sample file with the formula + explanation
======================================
To know more about this problem and get the sample data, visit π
chandoo.org/wp/a-clever-technique-to-simplify-your-long-nested-if-formulas
π Do more with SUMIFS
=====================
Want to unlock the godly powers of SUMIFS? Check out below article + two videos.
π° Basics of SUMIFS - chandoo.org/wp/introduction-to-excel-sumifs-formula
SUMFS - 15 practical uses - youtu.be/B5hayFelHDU
SUMIFS - 10 advanced examples - youtu.be/YEt-aYbDTrs
On XLOOKUP - youtu.be/DDlZXXEI1bU
~
#Ishrunktheformulas #excel










