Round down to nearest 5,000

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?

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

Code:

---

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

---

Code:

---

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)

How about

Code:

---

=FLOOR(A1, 5000)

---

This one works too!

Code:

---

=FLOOR(A1, 5000)

---

Thanks for the help!