Rounding up or down depending on number

[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?

 

[Pete_UK]

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

Try this:

=ROUND(A1,-3)

Hope this helps.

Pete

 

[Ron Coderre]

Try this:

=ROUND(A250,-3)

Does that help?

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

Regards,

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

 

[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.

 

[David Biddulph]

=IF(MOD(A250,100000)<10000,ROUNDDOWN(A250,-3),ROUNDUP(A250,-3))

 

[Pete_UK]

Ah, I see what you mean now. David seems to have cracked it.

Pete