All functions / Logical
IFS
Checks conditions in order and returns the value for the first TRUE one.
Syntax
=IFS(logical_test, value_if_true, [logical_test1, [logical_test2], …])
Arguments
logical_test: A condition.value_if_true: Result when that condition is TRUE.logical_test(optional): More condition/result pairs.
Example
=IFS(B2>=90, "A", B2>=80, "B", TRUE, "C") → A letter grade