Solved: Round down to nearest 5,000

[Klartigue]

Is there a way to roundown to the nearest 5,000?

So if its 8,000 - that would be rounded down to 5,000
If its 480,000 - that would be rounded down 450,000

and if its below 5,000 - round down to zero


Any ideas?

I know about the rounddown function but am not sure what to put in there to make it round down to the nearest 5,000?

[BrianMH]

I believe you need the analysis pack installed for this. I got this from a google search.

=MROUND((A1-5000/2),5000)

[CatDaddy]

roundedInteger = (CInt(unroundedNumber)/5000)*(5000)
integer division uses whole numbers so the result of an integer divided by 5000 will be the largest whole number quotient (the modulus would give the remainder of this division)

[mikerickson]

How about =FLOOR(A1, 5000)

[Klartigue]

This one works too!

=FLOOR(A1, 5000)

Thanks for the help!