Avatar of samiam41
samiam41
Flag for United States of America asked on

Show parentheses around negative percent

Hi Experts.  I am calculating percent increases or decreases and would like to show a negative percent change in ( ).  I appreciate your help.  Below is the portion of code I am using so far.

=IF($C$8=0,"-",$C$8/B8)
Microsoft ExcelWindows 7Microsoft Office

Avatar of undefined
Last Comment
samiam41

8/22/2022 - Mon
Rory Archibald

Apply a custom number format to the cell of:
0%;(0%);"-"
adding any decimal places you want.
samiam41

ASKER
Thanks rorya.  I imagine I am doing something wrong but under format cells > custom > type, I copied and pasted what you put in your response but am not seeing the ( ) around 50%.

=IF($C$8=0,"-",$C$8/B8)

B8= 100
C8= 50
Rory Archibald

50% is not a negative percent. if you mean you want anything less that 100% to be in parens then something like:
[<1](0%);0%
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
samiam41

ASKER
Fair enough.  I apologize for the confusion.  I am trying to reflect a decrease in revenue from one period to another as negative growth and therefore going from 100k to 50k as a 50% decrease in revenue or (50%).  How can I reflect that?
Saqib Husain

use

=(c8-b8)/b8

and conditional formatting as suggested by rory
ASKER CERTIFIED SOLUTION
Rory Archibald

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
samiam41

ASKER
@ssaqibh, thank you for your response.  I wasn't sure how to take what you provided and apply it to the formula for that cell (I'm still a novice and I apologize).

@rorya, that is exactly what I was looking for.  Thanks for your help and sticking with the question regardless of how much confusion I created.

It was great to work with you both and hope to do so again in the near future.

Regards,
Aaron
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Saqib Husain

No worries as long as you got what you are looking for.

Saqib
samiam41

ASKER
Hey super experts, if anyone has a minute to take a look at this question, I would greatly appreciate it:

https://www.experts-exchange.com/questions/27290225/Calculate-amount-of-ingredients-depending-on-number-of-batches.html

Thanks in advance!