
Any other result will cause IFS to return a #VALUE! error.

In addition, SWITCH can accept a default value. One advantage of SWITCH over IFS is that the expression appears just once in the function and does not need to be repeated. Both functions make it easier to write (and read) a formula with many conditions. Like the SWITCH function, the IFS function allows you to test more than one condition in a single self-contained formula.

Note: IFS is a new function available in Excel 365 and Excel 2019.
EXCEL FOR MAC IF STATEMENT WITH MULTIPLE CONDITIONS CODE
Without this final condition, IFS will return #N/A when a code is not recognized. When A1 contains any other value (including when A1 is empty) IFS will return "Invalid".


When the value in A1 is 100, 200, or 300, IFS will return the messages shown above.
