IF.EAGER Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Uses eager execution.
IF.EAGER ( LogicalTest, ResultIfTrue [, ResultIfFalse] )
LogicalTest – Any value or expression that can be evaluated to TRUE or FALSE.
ResultIfTrue – The value that is returned if the logical test is TRUE.
ResultIfFalse – (Optional) The value that is returned if the logical test is FALSE; if omitted, BLANK is returned.
Any type of value that can be returned by an expression.