cell equation ?
 

Marcster Wrote:
Hi Custermd,

Is this what your after:

=IF(b600,0,b6)

Doesn't seem to post correctly on this forum.
Should read: =IF(CELL is less than {LEFT ARROW}0, Then Display 0, else
display the CELL)

Marcster.

Sorry could not get the eq to work. Here is a more specific ex.
b12=11
c12=21
d12=b12-c12 so then d12 should equal -10 but I need it to equal 0


--
Custermd

Custermd Wrote:
Sorry could not get the eq to work. Here is a more specific ex.
b12=11
c12=21
d12=b12-c12 so then d12 should equal -10 but I need it to equal 0


Formula in d12 should be =If(b12-c12<0,0,b12-c12)


--
jahoobob