"IF" formula help needed
 

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

"IF" formula help needed
 

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

Regards
FSt1

"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

"IF" formula help needed
 

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.
--
Denster


"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

"IF" formula help needed
 

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

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






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

--

Dave Peterson

"IF" formula help needed
 

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