| 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 |
| 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) | |||
Threaded Mode
