Add "+" plus symbol to positive percentage

[Hendrik.Kleine]

Hi, Im calculating a precentage of two figures:
A1= 100 A2=200

=(A1/A2)-1

This gives me a negative result "-50%"

When A1 is greater than A2, resulting in a positve result, I'd like it to
display "+50%". Right now the plus symbol is not included.

Tried to concatenate but can't figure it out.

Many thanks for all suggestions.
Hendrik

 

[Duke Carey]

Well - if you WANT a positive result
you can eliminate the "-1" from your formula, or
you can use an IF() =A1/A2-IF(A2>A1,1,0), or
you can use ABS(A1/A2-1)

Or, you can use a custom format

0.00%;"+"0.00%

that will put a plus sign in front of negative percentages. If you want it
in front of both...

"+"0.00%;"+"0.00%

 

[John C]

Format|Cells|Custom
Custom number format:
+ #0.0# %;- #0.0# %

Hope this helps.

 

[Hendrik.Kleine]

Thank you very much both, worked like a charm

Format|Cells|Custom
Custom number format:
+ #0.0# %;- #0.0# %

Hope this helps.

 

[John C]

Thanks for the feedback.
--
John C

Thank you very much both, worked like a charm