Add "+" plus symbol to positive percentage

H

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
 
D

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%
 
Top