ROUND() to tens or hundreds (not tenth/hundredths)!

T

Tom

Office/Excel 2003 SP3
Windows XP Pro SP3

I need to round to a value in the ROUND() function. WHen rounding to 0
decimals I sometimes see $14,483.00 but I'd like to round to, say, $14,400 or
$14,950 or even $14,500.00 or even $15,000.00. $19,560 might go to $19,995
or $19,950 or even $20,000.
How do I do this to ROUND based upon a specific value or 'near' value? I'm
looking for some guidance here without just 'entering' the specific value
into a cell. The ROUND may round up or round down.
TIA
 
R

Rick Rothstein

You have not really pinned down with any consistency how you want your
rounding to go. Give one of these a try and see if it meets your needs...

=ROUND(A19,-1)

=ROUND(A19,-2)
 
S

Shane Devenshire

Hi,

There are some pretty strange roundings you are asking for, but

for 14,483 --> 14,400 use
=ROUNDDOWN(A1,-2)
for 14,483 --> 14,950 use (very strange, not at all clear on what you
actually trying to do
=ROUNDUP(A1,-3)-50 or
=FLOOR(D13,50)+500
for 14,483 --> 14,500
=ROUND(A1,-2)
for 14,483 --> 15,000
=ROUNDUP(A1,-3)
19,560 --> 20,000
=ROUNDUP(A1,-3)
for 19,560 --> 19,995 Im not sure what you want, this is an extremely
strange rounding. But you could use
=ROUND(A1,-3)-5
and 19,560 --> 19,950 another strange one
=ROUND(D10,-3)-50

if this helps, please click the Yes button

cheers
Shane Devenshire
 
Top