Round to nearest 5000

[Guest]

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

 

[Guest]

Try:

=Floor(A1,5000)

HTH

 

[Biff]

Hi!

One way:

A1 = 13000

=FLOOR(A1,5000)

Biff

 

[Guest]

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

 

[daddylonglegs]

Assuming you have only positive numbers

=FLOOR(A1,5000)

where A1 contains your number