Round to nearest 5000

Woody13 · Jul 7, 2006

Is there a way to round down (always) to the nearest 5000? If the
calculation yielded 13,000, the answer would show as 10,000. Thanks

Toppers · Jul 7, 2006

Try:

=Floor(A1,5000)

HTH

Biff · Jul 7, 2006

Hi!

One way:

A1 = 13000

=FLOOR(A1,5000)

Biff

Woody13 · Jul 7, 2006

I'm kind of looking for an MROUND function that is combined with ROUNDDOWN.

daddylonglegs · Jul 7, 2006

Assuming you have only positive numbers

=FLOOR(A1,5000)

where A1 contains your number