Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
command to return the row number or cell number in excel? | Excel Programming |