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

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

IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?
Continue »