cell value constraint

B

Balder

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

Bob Phillips

=MAX(0,A-B-C)

--

HTH

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