IFS
Syntax
=IFS(lofical_test1; value_if_true1; [logical_test2; value_if_true2]; ...)
Description
Checks whether multiple conditions are met and returns a value for the first TRUE.