Remember Me?

#1
August 21st 08, 03:40 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 12
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

#2
August 21st 08, 03:49 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,081
Add "+" plus symbol to positive percentage

Well - if you WANT a positive result
you can eliminate the "-1" from your formula, or
you can use an IF() =A1/A2-IF(A2A1,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%

"Hendrik.Kleine" wrote:

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

#3
August 21st 08, 03:50 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 1,358
Add "+" plus symbol to positive percentage

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

Hope this helps.
--
John C

"Hendrik.Kleine" wrote:

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

#4
August 21st 08, 04:01 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 12
Add "+" plus symbol to positive percentage

Thank you very much both, worked like a charm

"John C" wrote:

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

Hope this helps.
--
John C

"Hendrik.Kleine" wrote:

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

#5
August 21st 08, 06:52 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 1,358
Add "+" plus symbol to positive percentage

Thanks for the feedback.
--
John C

"Hendrik.Kleine" wrote:

Thank you very much both, worked like a charm

"John C" wrote:

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

Hope this helps.
--
John C

"Hendrik.Kleine" wrote:

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM garron Setting up and Configuration of Excel 1 June 21st 07 02:35 AM serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM BCB New Users to Excel 7 May 13th 06 10:02 PM

All times are GMT +1. The time now is 06:20 PM.