| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round Number to Nearest 50
I am looking for a formula that will round my numbers to the nearest 50
multiple. i.e. From: To: 237,730 237,750 235,112 235,100 57,567 57,550 =mround(A1,50) doesn't seem to work.. Any ideas? Thanks for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round Number to Nearest 50
DOH. I just had to un-install and then re-install the Analysis toolpak, and
the mround worked.. Please disregard. Thanks- "ELeigh" wrote: I am looking for a formula that will round my numbers to the nearest 50 multiple. i.e. From: To: 237,730 237,750 235,112 235,100 57,567 57,550 =mround(A1,50) doesn't seem to work.. Any ideas? Thanks for your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round Number to Nearest 50
How about:
=ROUND(A1/50,0)*50 -- Gary''s Student - gsnu200823 "ELeigh" wrote: I am looking for a formula that will round my numbers to the nearest 50 multiple. i.e. From: To: 237,730 237,750 235,112 235,100 57,567 57,550 =mround(A1,50) doesn't seem to work.. Any ideas? Thanks for your help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round Number to Nearest 50
=ROUND(2*A1,-2)/2 should do it.
"ELeigh" wrote: I am looking for a formula that will round my numbers to the nearest 50 multiple. i.e. From: To: 237,730 237,750 235,112 235,100 57,567 57,550 =mround(A1,50) doesn't seem to work.. Any ideas? Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| How can you round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How do I round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How can you round a number to the nearest 900? | Excel Worksheet Functions | |||
| Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
Hybrid Mode
