cell value constraint

[Guest]

We have columnA, columnB, column C, columnD. the formula is D=A-B-C.
D must be above at least zero. In case the result is below 0, i need to
convert the value obtained to 0. in case it's above zero, it should remain
so.
Thank you.

 

[PCLIVE]

One way,

=IF(A1-B1-C1<0,0,A1-B1-C1)

HTH,
Paul

 

[Bob Phillips]

=MAX(0,A-B-C)

--

HTH

RP
(remove nothere from the email address if mailing direct)