Use

=MAX(0,B14-B15)

and

=ABS(B14-B15)


Regards,

Peo Sjoblom

"KAnoe" wrote:

I have a cell "B16" that gets its data for two other cells "=B14-B15"

I would like the cell to do the following.
If it is less that 0 it will change the Neg number to a 0

So if B14-B15 = -$10.00 it would change it to a 0

I would like to also have a cell that would Show B14-B15 = -$10.00 it would
change it to Pos Number like this Profit $10.00

Thanks for your help