Hi
1. Question: Use
=MAX(0,B14-B15)

2. Question: Use
=ABS(B14-B15)

--
Regards
Frank Kabel
Frankfurt, Germany

"KAnoe" schrieb im Newsbeitrag
...
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