It returns the remainder of L3 divided by 2.

Going beyond what MOD() is doing, that result is then compared to zero,
returning a TRUE/FALSE result. TRUE would indicate that the value of L3
is both integral and even. FALSE would indicate that it is not integral
and even.

That result is an input to the AND() function. If L3 is not integral and
even, the AND() function will return FALSE, and the result of the False
branch of the IF statement (i.e., "ERROR") will be returned to the cell.



In article ,
"Murph" wrote:

okay with that being said, what exactly is it doing in this formula?