Excel IF, IFS, SWITCH Function - A Subtle Difference
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 o