If Neg Number in a cell
 

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

If Neg Number in a cell
 

One way:

To show zero:

=MAX(0,B14-B15)

to show positive

=ABS(B14-B15)

In article ,
"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

If Neg Number in a cell
 

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

If Neg Number in a cell
 

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

If Neg Number in a cell
 

I Thank All Of YOU.

KEITH

"Frank Kabel" wrote:

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