| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding to nearest 250 by 125s
i would like to round a number to the nearest 250 in increments of 125.
(i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would round to 1250) pleas advise and thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding to nearest 250 by 125s
Rounding to the nearest 250 would automatically be in increments of 125.
Try: =mround(a1,250) If you get a #Name error, install the Analysis Toolpak Regards, Fred. "tcek" wrote in message ... i would like to round a number to the nearest 250 in increments of 125. (i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would round to 1250) pleas advise and thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding to nearest 250 by 125s
thank you
"Fred Smith" wrote: Rounding to the nearest 250 would automatically be in increments of 125. Try: =mround(a1,250) If you get a #Name error, install the Analysis Toolpak Regards, Fred. "tcek" wrote in message ... i would like to round a number to the nearest 250 in increments of 125. (i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would round to 1250) pleas advise and thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding to nearest 250 by 125s
Glad I could help. Thanks for the feedback.
Regards, Fred "tcek" wrote in message ... thank you "Fred Smith" wrote: Rounding to the nearest 250 would automatically be in increments of 125. Try: =mround(a1,250) If you get a #Name error, install the Analysis Toolpak Regards, Fred. "tcek" wrote in message ... i would like to round a number to the nearest 250 in increments of 125. (i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would round to 1250) pleas advise and thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up or down to the nearest $.09 | Excel Discussion (Misc queries) | |||
| rounding to nearest 100 | Excel Worksheet Functions | |||
| Rounding to the nearest 5 | Excel Discussion (Misc queries) | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding to Nearest 250 | Excel Worksheet Functions | |||
Linear Mode
