Excel IFS Function
Syntax
=IFS(logical_test1, value1, [logical_test2, value2], ...)
Description
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
Looking for ready templates?