Brackets on negative percents.

T

Tracey C.

Hello,

I am trying to get brackets to appear on a negative percentage from a
formula. I know that I can retype it as '(2.1%) and it will show what
brackets correctly, but I am wondering if there is something in the formula
that can be added to display it correct.

=-(C15-C16)/ABS(C15)
 

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

Similar Threads

Displaying negatives with (brackets) 3
Negative Numbers in Brackets 2
Formating Negative Figures in Brackets 2
Negative figures in brackets 13
Excel Excel 2010-how to display negative % with brackets 0
Negative Numbers in Brackets - HELP! 21
Formula to calculate % using negative values 3
Negative numbers use braces 4

Top