Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
Good morning
I have 2 cells I need to compa - one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? Thanks for your help Regards, Michel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
Old Lotus habits won't die? Try this custom format
"+" #,##0.00_);"-"#,##0.00 -- Don Guillett SalesAid Software "Michel Khennafi" wrote in message ... Good morning I have 2 cells I need to compa - one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? Thanks for your help Regards, Michel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
One way
+0.00;-0.00;0.00 or add the dollar sign if you want currency format +$#,##0.00;-$#,##0.00;$#,##0.00 -- Regards, Peo Sjoblom "Michel Khennafi" wrote in message ... Good morning I have 2 cells I need to compa - one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? Thanks for your help Regards, Michel |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
Try:-
"+"#,##0 ;[Red]"-"#,##0 Mike "Michel Khennafi" wrote: Good morning I have 2 cells I need to compa - one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? Thanks for your help Regards, Michel |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
I have 2 cells I need to compa
- one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? And if you wanted to apply this formatting to only one cell rather than the entire column... =TEXT(A2-A1,"+0.00;-0.00;0.00") or =TEXT(-4,"+$#,##0.00;-$#,##0.00;$0.00") if you want the $ sign. Rick |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Positive or negative sign in a calculated cell
Thanks so much
"Rick Rothstein (MVP - VB)" wrote in message ... I have 2 cells I need to compa - one cell is the baseline (assume $100) - the other cell is the real cost obtained after a calculation from other cells (assume the resulkt of the calculation is $106) - I would like to calculate the difference between cell 1 and cell 2 and present it with a + or - sign, in my situation cell 2 is equal to +6 Any idea as to how I would need to format the cell? creation of a custom format? And if you wanted to apply this formatting to only one cell rather than the entire column... =TEXT(A2-A1,"+0.00;-0.00;0.00") or =TEXT(-4,"+$#,##0.00;-$#,##0.00;$0.00") if you want the $ sign. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a cell color to reflect positive or negative total | New Users to Excel | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
change cell from negative to positive | Excel Discussion (Misc queries) | |||
Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) |