Link to home
Start Free TrialLog in
Avatar of samiam41
samiam41Flag 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)
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Apply a custom number format to the cell of:
0%;(0%);"-"
adding any decimal places you want.
Avatar of 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
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%
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?
use

=(c8-b8)/b8

and conditional formatting as suggested by rory
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@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
No worries as long as you got what you are looking for.

Saqib
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!