We help IT Professionals succeed at work.

Show parentheses around negative percent

1,125 Views
Last Modified: 2012-05-11
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)
Comment
Watch Question

Rory ArchibaldGrand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

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

Author

Commented:
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 ArchibaldGrand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
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%

Author

Commented:
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 HusainEngineer
CERTIFIED EXPERT

Commented:
use

=(c8-b8)/b8

and conditional formatting as suggested by rory
Grand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
@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 HusainEngineer
CERTIFIED EXPERT

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

Saqib

Author

Commented:
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/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27290225.html

Thanks in advance!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.