samiam41
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)
=IF($C$8=0,"-",$C$8/B8)
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
=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%
[<1](0%);0%
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?
use
=(c8-b8)/b8
and conditional formatting as suggested by rory
=(c8-b8)/b8
and conditional formatting as suggested by rory
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
@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
Saqib
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!
https://www.experts-exchange.com/questions/27290225/Calculate-amount-of-ingredients-depending-on-number-of-batches.html
Thanks in advance!
0%;(0%);"-"
adding any decimal places you want.