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
Formating Negative Figures in Brackets 2
Negative Numbers in Brackets 2
Cumulative formula for word table 0
percentage in brackets 2
Option to put brackets around negative numbers not available in 20 3
Standard formatting not being applied to negative percents 0
Negative Number Display -- need Brackets 7

Top