Question

a logical function in CALC that first evaluate the condition specifeid and returns one value if the condition is met and another value if the condition is not met

Answer 1

Answer:

IFS function. The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.