Round to the nearest 10,000

[eoinymc]

Hi,

can anyone help me round down to the nearest 10,000

So, if it's 84,000, it'll round to 80,000
If It's 86,000, it'll round to 80,000
etc...

I found this online, but it doesn't work properly past 100,000..it just rounds down to the nearest 100,000 when it gets past 100,000

=ROUNDDOWN(AM41,-INT(LOG(AM41)))

Any ideas how I can modify this to work?

Cheers,

Eoin

 

[Jonmo1]

So it's horrendous that the function is different between versions of XL.
I agree with that..


But I think horrendous is a very strong word for rounding to -infinity.
At the very least, we should have the choice to do it either way, round to 0 OR -infinity.

Say you have $1.60
You buy a beer for $2.00 and tell the bartender to make a tab.
And you and the bartender agree to round it down to the nearest dollar.
Do you owe 1 dollar, or Nothing ?

 

[Jonmo1]

eh, nevermind.
That was a very bad example...

 

[Drrellik]

=A1-(MOD(A1,10000)) works in 2003 and greater.

 

[meytithveasna]

I want roundup/rounddown decimal (only)
ex.. 119.906 to 119.905 & 256.904 to 256.900 kindly help for this.. i would be grateful if you help the above

 

[Drrellik]

the functions you want to look at are =floor(), =ceiling() & maybe even =mround()

I found that in the examples you posted with your data in A1, A2.... I used =floor(A1,0.005) to get the results you asked for.

HTH

Don