Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and formatting
Post your formula. Regardless to change the display you can use TEXT
look it up in help -- Regards, Peo Sjoblom "Silena K-K" wrote in message ... 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding and Number Formatting | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
After rounding/formatting to whole numbers... | Excel Worksheet Functions |