"IF" formula help needed

  • Thread starter Thread starter cjborntorun
  • Start date Start date
C

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
 
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.
 
=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)
 
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
 
Back
Top