Need help with rounding percentages

[lat0782]

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.

 

[joeu2004]

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.

 

[lat0782]

Thank you for your help.