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

a logical function in CALC that first evaluate the condition specifeid

1.	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» 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.