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
Seamus2626Asked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.