Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
Hi all, What will be the formula to round the percentage to two
decimal places like I have percentage in cell A1 "17.83333331%". Whith which formula I can make it "17.83%". Please can any friend can help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
Hi,
The simplest way is to format the cell as % to 2 decimal places but you could use =ROUND(A1,2) Mike "K" wrote: Hi all, What will be the formula to round the percentage to two decimal places like I have percentage in cell A1 "17.83333331%". Whith which formula I can make it "17.83%". Please can any friend can help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
Hi Mike H, Thanks for replying. actually i got formula in cell A1
and i have formated cell as 0.00%.if i look in in formula bar i see the result 17.8333333% but it appear in cell 17.83%. I know about Round formula but when i put in cell A1 "=ROUND(B1/C1,2)" i get result 0.00%. I tried CELING formula but i get result 17.84 as it rounds up the last digit. Round formula works on normal numbers but for percentage i am looking for something that i get 17.83% in cell as well as in formula bar. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
Looks like you want 0.1783 displayed as 17.83%, that's 4 places
=ROUND(B1/C1,4) and numberformat 0.00% Regards, Peter T "K" wrote in message ... Hi Mike H, Thanks for replying. actually i got formula in cell A1 and i have formated cell as 0.00%.if i look in in formula bar i see the result 17.8333333% but it appear in cell 17.83%. I know about Round formula but when i put in cell A1 "=ROUND(B1/C1,2)" i get result 0.00%. I tried CELING formula but i get result 17.84 as it rounds up the last digit. Round formula works on normal numbers but for percentage i am looking for something that i get 17.83% in cell as well as in formula bar. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
"K" wrote:
i see the result 17.8333333% but it appear in cell 17.83%. Remember that 17.8333% is actually the number 0.178333 (about). So if you want to round percentages to 2 decimal places, you need ROUND(A1,4). However.... I know about Round formula but when i put in cell A1 "=ROUND(B1/C1,2)" i get result 0.00%. Something else is wrong. If B1/C1 results in 17.8333%, ROUND(B1/C1,2) should result in 18%, not 0%. And.... I tried CELING formula but i get result 17.84 as it rounds up the last digit. If you are saying that you tried CEILING(B1/C1,0.01) with that result, then B1/C1 resulted in 17.8333, not 17.8333%. Not only is that inconsistent with your statement about ROUND(B1/C1,2), but also it means that you really do not have a percentage result (i.e. formatted as Percentage). Can you explain these inconsistencies? ----- original message ----- "K" wrote in message ... Hi Mike H, Thanks for replying. actually i got formula in cell A1 and i have formated cell as 0.00%.if i look in in formula bar i see the result 17.8333333% but it appear in cell 17.83%. I know about Round formula but when i put in cell A1 "=ROUND(B1/C1,2)" i get result 0.00%. I tried CELING formula but i get result 17.84 as it rounds up the last digit. Round formula works on normal numbers but for percentage i am looking for something that i get 17.83% in cell as well as in formula bar. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round Percentage
Thanks peter, you have solved my problem. i should be putting Round
(B1/C1,4) intead of Round(B1/C1,2). Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
How do I round down a tax percentage | Excel Discussion (Misc queries) | |||
round up a percentage formular | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |