try this
=IF(AND(E11<"",E10E11),((E10-E11)*D10*C10),0)

if E11 is blank, it will return 0.
you can replace "" to 0 in the formula

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"cjborntorun" wrote:

I have the following formula:

=IF((E10E11),((E10-E11)*D10*C10),0)

I'm trying to add an additional "IF" clause to this formula where cell E11
is not NULL. I haven't seemed to hit upon the correct formula. Ideas?
Please advise. Thank you