View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tracey C. Tracey C. is offline
external usenet poster
 
Posts: 1
Default Brackets on negative percents.

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)