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)

--
Rick (MVP - Excel)


"Tom" wrote in message
...
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