| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round to nearest multiple
Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info
online about MROUND formulas but I can't seem to get it to work on my 2003 excel and it is not listed as a valid formula within the selection. I also saw posts about ceilings and floors but I wanted a formula that would round both up and down to the approprate multiple. James |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round to nearest multiple
Hi James
The hard way: =ROUND(A1/25,0)*25 HTH. Best wishes Harald "James M" wrote in message ... Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info online about MROUND formulas but I can't seem to get it to work on my 2003 excel and it is not listed as a valid formula within the selection. I also saw posts about ceilings and floors but I wanted a formula that would round both up and down to the approprate multiple. James |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round to nearest multiple
Thank you! I feel guilty to say it but I just found a similar response after
I submitted my question. Thanks for your help! "Harald Staff" wrote: Hi James The hard way: =ROUND(A1/25,0)*25 HTH. Best wishes Harald "James M" wrote in message ... Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info online about MROUND formulas but I can't seem to get it to work on my 2003 excel and it is not listed as a valid formula within the selection. I also saw posts about ceilings and floors but I wanted a formula that would round both up and down to the approprate multiple. James |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round to nearest multiple
MROUND is part of the Analysis Tool Pack which must be installed before you
can use the function. If you don't want have to install the ATP then try: =ROUND(E11/25,0)*25 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "James M" wrote in message ... Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info online about MROUND formulas but I can't seem to get it to work on my 2003 excel and it is not listed as a valid formula within the selection. I also saw posts about ceilings and floors but I wanted a formula that would round both up and down to the approprate multiple. James |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round to nearest multiple
Did you look up MROUND in Excel help?
-- David Biddulph "James M" wrote in message ... Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info online about MROUND formulas but I can't seem to get it to work on my 2003 excel and it is not listed as a valid formula within the selection. I also saw posts about ceilings and floors but I wanted a formula that would round both up and down to the approprate multiple. James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
| How do you round up to nearest 10??? | Excel Discussion (Misc queries) | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
| How do I round to the nearest 5? | Excel Worksheet Functions | |||
| I need to round up to the nearest 50. | Excel Discussion (Misc queries) | |||
Hybrid Mode
