How do I show negative percentage in a fomula?

T

Terri

We are doing a profit/loss spreadsheet. We can set it up to show a positive
or negative dollar value. We also want to use a percentage in the same way.
We want to be able to have the percentage show as a negative (i.e. red and
with brackets) automatically, so that when the inputted values change, the
resulting percentage is black if positive and red if negative. Is this
possible?

If you need me to make this clearer, please let me know. Thank you for any
assistance.
 
R

Rick Rothstein \(MVP - VB\)

I think the following Custom Format will do what you want...

0.00%;[Red](0.00%)

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top