Rounding and formatting

S

Silena K-K

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??
 
P

Peo Sjoblom

Post your formula. Regardless to change the display you can use TEXT

look it up in help
 
Top