View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hendrik.Kleine Hendrik.Kleine is offline
external usenet poster
 
Posts: 12
Default Add "+" plus symbol to positive percentage

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