top of page

Excel IF, IFS, SWITCH Function - A Subtle Difference

Updated: Dec 7, 2020

IF and IFS function in Excel are very useful decision-making functions. Do you know that IF and IFS function work differently? Although IF and IFS provide the same result, the way they are executed may create unexpected side-effects. This is especially important when they are used with User Defined Function (UDF).

This video will first show you the difference between the Excel IF and IFS functions. We will then see whether the same behaviour appears in other decision-making operators such as IFERROR, SWITCH, and CHOOSE. As an added bonus, we will also examine logical operators AND and OR at the end.

Please let us know what you think in the comment below.

Find out more on how ajWriteFile works:

Download our community edition today to try it out yourself:

Video on How to setup AlchemyJ:

How AJ works:


bottom of page