The function Ifs Checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition.
Syntax:
=Ifs (logical function 1, value if true 1, logical function 2, value if true 2,…)
Logical function 1. Is any expression that can be evaluated to a True or False.
Value if True 1. Is the value to be returned if logical test 1 is true.
Logical function 2. Is any expression that can be evaluated to a True or False.
Value if True 2. Is the value to be returned if logical test 2 is true.