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
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%
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?
@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.
0%;(0%);"-"
adding any decimal places you want.