| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to 5.0 or 0.0
How would I Round up to 5 as in 10.1 to 15 9.9 to 10 105.3 to 110 123.6 to 125 -- mgtyper ------------------------------------------------------------------------ mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402 View this thread: http://www.excelforum.com/showthread...hreadid=570891 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to 5.0 or 0.0
On Fri, 11 Aug 2006 14:58:52 -0400, mgtyper
wrote: How would I Round up to 5 as in 10.1 to 15 9.9 to 10 105.3 to 110 123.6 to 125 Try: =CEILING(A1,5) --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to 5.0 or 0.0
=roundup( A1/5,0) *5
mgtyper wrote: How would I Round up to 5 as in 10.1 to 15 9.9 to 10 105.3 to 110 123.6 to 125 -- mgtyper ------------------------------------------------------------------------ mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402 View this thread: http://www.excelforum.com/showthread...hreadid=570891 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to 5.0 or 0.0
Both these answers will work in the positive domain.
Mine will round -101 to -105 Ron's will round -101 to -100 Take your pick depending on how you want to handle negatives. wrote: =roundup( A1/5,0) *5 mgtyper wrote: How would I Round up to 5 as in 10.1 to 15 9.9 to 10 105.3 to 110 123.6 to 125 -- mgtyper ------------------------------------------------------------------------ mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402 View this thread: http://www.excelforum.com/showthread...hreadid=570891 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to 5.0 or 0.0
Thanks guys that works perfect. -- mgtyper ------------------------------------------------------------------------ mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402 View this thread: http://www.excelforum.com/showthread...hreadid=570891 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to 5.0 or 0.0
another way
=MROUND(E7+2.5,5) -- paul remove nospam for email addy! "mgtyper" wrote: How would I Round up to 5 as in 10.1 to 15 9.9 to 10 105.3 to 110 123.6 to 125 -- mgtyper ------------------------------------------------------------------------ mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402 View this thread: http://www.excelforum.com/showthread...hreadid=570891 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Rounding or not rounding | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Hybrid Mode
