Rounding up or down depending on number

J

JNAP101

Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell
would read 512,000?
 
P

Pete_UK

Surely the first one would round up also, to 507,000.00 ?

Try this:

=ROUND(A1,-3)

Hope this helps.

Pete
 
R

Ron Coderre

Try this:

=ROUND(A250,-3)

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
J

JNAP101

Hi Pete, Thanks for the quick response!! That's the problem if the
"thousands" is less than 10k they want the number to round down and round up
if over 10.0k.

I totally stuck on what formula would work.
 
Top