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: https://docs.alchemyj.io/docs/4.1/Reference/AJExtendedFunctions/ajWriteFile


Download our community edition today to try it out yourself: https://www.alchemyj.io/download


Video on How to setup AlchemyJ: https://youtu.be/eTyYTf1sw9k


How AJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ


Let's connect: https://www.linkedin.com/company/alchemyj


#alchemyj #axisoft #howitworks #restapi #IFS #IF #UDF #DecisionMaking