Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round to the nearest 5? | Excel Worksheet Functions | |||
Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
Round to nearest thousand | Excel Discussion (Misc queries) | |||
Round Up to Nearest 10 | Excel Worksheet Functions | |||
Round time to nearest quarter hr | Excel Worksheet Functions |