Formula question

[nyrfan]

I have the following formula in a cell:

=IF(OR(L7=0,$L$2=0),"",SUM(D7-L7))


It works fine BUT what I'd like to emilminate is negative numbers. So if the number being generated is < or = 0 I want the cell to be left blank.

Is there a way do do that?

 

[Jonmo1]

=IF(OR(L7=0,$L$2=0,D7-L7<=0),"",SUM(D7-L7))

Hope that helps..

 

[nyrfan]

=IF(OR(L7=0,$L$2=0,D7-L7<=0),"",SUM(D7-L7))

Hope that helps..

Like a charm, thank you.

 

[nyrfan]

The only thing is when the cells are empty I an now getting the word "#value" in the calculating cell. Is there a way to get rid of this?

 

[DonkeyOte]

sorry...incorrect formula added originally - revision below


=IF(OR(ISNUMBER(D7)=FALSE,ISNUMBER(E7)=FALSE),"",IF(OR(L7=0,$L$2=0,D7-L7<=0),"",SUM(D7-L7)))

 

[nyrfan]

sorry...incorrect formula added

Just seen your fix, let me try it