Function

[Javster095]

If my result is a negative number, how can I setup the function to display a
zero as suppose to a negative number. Example, if 2- 3= -1, but I would
rather have my cell to display a zero as suppose to a negative number?

Thanks.

 

[Roger Govier]

Hi

Something like
=IF(A1-B1<0,0,A1-B1)
or
=MAX(0,A1-B1)

Regards

Roger Govier

 

[Elkar]

=MAX(2-3,0)

Replace 2-3 with your original function.

 

[Bob Umlas]

to DISPLAY 0 (but calc as -1), use Format/Cells, select Custom, and enter:
General;"0"
To CALCULATE as 0, change the formula to be =MAX(0,yourcurrentformula)