cell value constraint
 

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.

One way,

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

HTH,
Paul


"Balder" wrote in message
...
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.

=MAX(0,A-B-C)

--

HTH

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


"Balder" wrote in message
...
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.