All articles with 'ifs' Tag
{ 4 Comments }
A clever technique to simplify your long, nested IF formulas
Published on Apr 11, 2023 in Formula Forensics, Learn Excel
![A clever technique to simplify your long, nested IF formulas](https://chandoo.org/wp/wp-content/uploads/2023/04/SNAG-2570.png)
Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.
Continue »{ 16 Comments }
10 Advanced IF formula tricks you must know
Published on Mar 31, 2021 in Learn Excel
![10 Advanced IF formula tricks you must know](https://chandoo.org/wp/wp-content/uploads/2021/03/advanced-if-formula-tricks.jpg)
IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?
Continue »