| 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 | |||
Hybrid Mode
