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]

Try

=FLOOR(AM41,10000)


FYI, the opposite is Ceiling..To round UP

 

[Drrellik]

=b1-mod(b1,10000)

 

[eoinymc]

Jonmo, you're a genius! That's easier to understand than your solution drrellik....but thanks for the help!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[eoinymc]

Jonmo...just ran into a bit of an issue...

What is my number is negative? It is throwing up an error...

Any ideas?

Thanks,

Eoin

 

[Jonmo1]

What error?

It doesn't error for me..

If the cell is -18000, then it returns -20000

 

[eoinymc]

That's strange...

I have an embedded formula instead of just AM41, so maybe that's the problem.

I'll try to play around with it.

Thanks again...Eoin

 

[shg]

Try =FLOOR(AM41, SIGN(AM41)*10000)

FLOOR rounds toward 0, so -18000 will return 10000.

 

[Jonmo1]

FLOOR rounds toward 0, so -18000 will return 10000.

I doesn't appear that way

Excel Workbook
	A	B
1	-18000	-20000
Sheet1