The (K108<"") term evaluates to a boolean TRUE/FALSE. When TRUE/FALSE
is used in a math operation, here *, XL coerces TRUE/FALSE to 1/0. So if
the term evaluates to FALSE, the first term will be multiplied by zero,
otherwise it is multiplied by 1.

You could do the same thing with the formula I gave:

=(1-K108*0.0045)*(K108<"")


In article .com,
"Ardy" wrote:

Could you explain (K108<"") is this another way of saying IF null