View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default Rounding and formatting

I'm using Excell 2000 and have an IF statement to round values = 10% to 2
decimal places or to 1 decimal place if < 10%. What I now want to be able to
do is show the resultant values with the % sign formatting. When I change
the formatting it changes all the values to 2 decimal places. How can I use
the % format sign and round to certain decimal places??