# 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

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

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%
samiam41

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
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.
samiam41

@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
Saqib Husain

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

Saqib
samiam41