Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with rounding percentages
I'm trying to figure federal, state and local tax based on the sales amount.
My problem is sometimes Excel rounds up and sometimes it rounds down. I've tried the round, roundup, and rounddown functions and neither of them work the way I need them to. Is there any other way to get the rounding correctly. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with rounding percentages
On Jun 17, 10:54*am, lat0782
wrote: I'm trying to figure federal, state and local tax based on the sales amount. * My problem is sometimes Excel rounds up and sometimes it rounds down. *I've tried the round, roundup, and rounddown functions and neither of them work the way I need them to. *Is there any other way to get the rounding correctly. Post your formulas. Excel does not sometimes "round up" and sometimes "round down" -- it simply "rounds" according to normal rules (not so-called banker's rounding). By example, 1.50 can be rounded to 2, 1.49 can be rounded to 1. As to your subject line, keep in mind that numbers that display as percentages are really stored as decimal fractions. For example, if you want to round 1.235% to 1.24% (2 places), note that it is stored as 0.01235. So you need to round to 4 places, no 2. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with rounding percentages
Thank you for your help.
"lat0782" wrote: I'm trying to figure federal, state and local tax based on the sales amount. My problem is sometimes Excel rounds up and sometimes it rounds down. I've tried the round, roundup, and rounddown functions and neither of them work the way I need them to. Is there any other way to get the rounding correctly. |
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 percentages problem need a solution for | Excel Discussion (Misc queries) | |||
Percentages | Excel Worksheet Functions | |||
Bug in Rounding percentages of Bar of Pie chart | Charts and Charting in Excel | |||
percentages | Excel Discussion (Misc queries) |