"IF" formula help needed

[cjborntorun]

I have the following formula:

=IF((E10>E11),((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

 

[FSt1]

hi
what do you want to happen if E11 is null?

Regards
FSt1

 

[Den]

additional "if" could be if(e10<>"", which would indicate that cell e10 is
other than an empty cell, that is, could be a value or a text.

 

[Dave Peterson]

=IF(and(e11<>"",E10>E11),(E10-E11)*D10*C10,0)

or maybe check for a number
=IF(and(isnumber(e11),E10>E11),(E10-E11)*D10*C10,0)

 

[francis]

try this
=IF(AND(E11<>"",E10>E11),((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