Thread
:
Positive or negative sign in a calculated cell
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett