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.