Round to nearest 5000
 

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

Round to nearest 5000
 

Try:

=Floor(A1,5000)

HTH

"Woody13" wrote:

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

Round to nearest 5000
 

Hi!

One way:

A1 = 13000

=FLOOR(A1,5000)

Biff

"Woody13" wrote in message
...
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

Round to nearest 5000
 

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

"Woody13" wrote:

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

Round to nearest 5000
 

Assuming you have only positive numbers

=FLOOR(A1,5000)

where A1 contains your number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559497