PDA

View Full Version : Solved: Round down to nearest 5,000



Klartigue
08-10-2012, 01:05 PM
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
08-10-2012, 01:43 PM
I believe you need the analysis pack installed for this. I got this from a google search.

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

CatDaddy
08-10-2012, 01:45 PM
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
08-11-2012, 08:15 AM
How about =FLOOR(A1, 5000)

Klartigue
08-13-2012, 06:19 AM
This one works too!

=FLOOR(A1, 5000)

Thanks for the help!