Building IFS functions

Building IFS functions The IFS function was first introduced in Office 2016, so it is not a new function. It is so much easier to construct and evaluate multiple IF conditions instead of using the old clunky nested IF formula. The IFS syntax is extremely simple: =IFS(logical_test1,value_if_ true1,[logical_test2,value_if_true2], and so on up to 127 conditions. […]