Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Custom format %

Can someone advise of the custome format to display the opposite in percentages

e.g. my formula = =(D4-C4)/C4*-1

If the result is -21%, i want to view this on the ss as 21% and vica versa

Many thanks
0
Seamus2626
Asked:
Seamus2626
  • 2
  • 2
1 Solution
 
Rory ArchibaldCommented:
I think that's a really bad idea, but anyway:
-0%;0%
will do it. :)
0
 
Seamus2626Author Commented:
Why such a bad idea?!
0
 
Rory ArchibaldCommented:
Because I think at some point someone will either get very confused by the fact the actual value has the opposite sign to the way it looks, or won't notice and will base some calculation off it.
0
 
Seamus2626Author Commented:
Fair enough, this is all for PP slides anyhow

But i have posted another question to see can i get to my destination in a cleaner way

Thanks
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now