Positive or negative sign in a calculated cell

[Michel Khennafi]

Good morning

I have 2 cells I need to compare:
- 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

 

[Don Guillett]

Old Lotus habits won't die? Try this custom format
"+" #,##0.00_);"-"#,##0.00

 

[Peo Sjoblom]

One way

+0.00;-0.00;0.00

or add the dollar sign if you want currency format

+$#,##0.00;-$#,##0.00;$#,##0.00

 

[Mike H]

Try:-
"+"#,##0 ;[Red]"-"#,##0

Mike

 

[Rick Rothstein \(MVP - VB\)]

I have 2 cells I need to compare:

- 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

 

[Michel Khennafi]

Thanks so much

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