Try this...

=MAX(0,C1-C2)

--
Biff
Microsoft Excel MVP


"Jay M 0425" wrote in message
...
I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks