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


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

[Elkar]

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

[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)
"Javster095" <Javster095@discussions.microsoft.com> wrote in message
news:93E1E1F6-AE9C-4656-8A19-348D6BB96652@microsoft.com...
> 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.
>