Excel Secrets: Shorten Long Formulas by 80%β€”A Trick Youll Love! @chandoo_
Excel Secrets: Shorten Long Formulas by 80%β€”A Trick Youll Love!  @chandoo_
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
Excel Secrets: Shorten Long Formulas by 80%β€”A Trick Youll Love!How to calculate Compound Interest in Excel - Formula with Examples πŸ’»Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily!How to make a Column Chart with TOTALS in Excel (perfect for data analysis)Learn SQL + Database Concepts in 20 Minutes35 Must have Excel ShortcutsExcel Data Cleaning TrickπŸ’‘for uneven rows of data #EXCELPower Query MAGIC! ⚑Auto-Categorize Text Like a PRO!Stop Dragging in Excel, there is a BETTER way!UNPIVOT: Data Cleaning Power Tricks πŸ’‘Powerful trick to get data from any folder in Excel (works even after renaming!)Excel formula to get CLOSEST Matching Value
Chandoo |

Excel Secrets: Shorten Long Formulas by 80%β€”A Trick You'll Love!

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER