| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with rounding up to whole integer
How do I make a formula (within the same cell) round to the nearest 5? Thanks - Kim -- kjcramp ------------------------------------------------------------------------ kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753 View this thread: http://www.excelforum.com/showthread...hreadid=531548 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with rounding up to whole integer
One way:
=ceiling(a1,5) or =ceiling(yourformulahere,5) kjcramp wrote: How do I make a formula (within the same cell) round to the nearest 5? Thanks - Kim -- kjcramp ------------------------------------------------------------------------ kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753 View this thread: http://www.excelforum.com/showthread...hreadid=531548 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with rounding up to whole integer
The second choice with the formula works, although it rounds up if there is any value behind the decimal at all, but it's close enough. Thanks again! -- kjcramp ------------------------------------------------------------------------ kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753 View this thread: http://www.excelforum.com/showthread...hreadid=531548 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with rounding up to whole integer
Sorry, I misread the question...
Maybe... =ROUND(A1/5,0)*5 or =ROUND(YourFormulaHere/5,0)*5 kjcramp wrote: The second choice with the formula works, although it rounds up if there is any value behind the decimal at all, but it's close enough. Thanks again! -- kjcramp ------------------------------------------------------------------------ kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753 View this thread: http://www.excelforum.com/showthread...hreadid=531548 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Possible Combinations | Excel Discussion (Misc queries) | |||
| Need help with Combinations, told to come here | Excel Worksheet Functions | |||
| Number anagram | Excel Worksheet Functions | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
Hybrid Mode
