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.

Hi

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

Regards

Roger Govier


Javster095 wrote:
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.

=MAX(2-3,0)

Replace 2-3 with your original function.


"Javster095" wrote:

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.

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