If Neg Number in a cell

[Guest]

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

 

[JE McGimpsey]

One way:

To show zero:

=MAX(0,B14-B15)

to show positive

=ABS(B14-B15)

 

[Frank Kabel]

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

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

 

[Guest]

Use

=MAX(0,B14-B15)

and

=ABS(B14-B15)


Regards,

Peo Sjoblom

 

[Guest]

I Thank All Of YOU.

KEITH

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

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