| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding results to nearest quarter (in decimals)
I have a formula that results gives results like 22.63. Is there a way to get it to round up to the nearest quarter number. For example 22.63 would round up to 22.75 or 133.10 would round up to 133.25. Is this possible? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
|
#2
|
|||
|
|||
|
Rounding results to nearest quarter (in decimals)
Good evening djarcaian Certainly is - just use the CEILING function. Assume that your 22.63 is in A1. Put this formula in B1: =CEILING(A1,0.25) HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
|
#3
|
|||
|
|||
|
Rounding results to nearest quarter (in decimals)
I figured this out- =ROUND(SUM(G25/2)*4,0)/4 Is there any reason to use the CEILING system instead of this system? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
|
#4
|
|||
|
|||
|
Rounding results to nearest quarter (in decimals)
Hi djarcadian Noy really. It's just tidier, and does exactly what it was designed to. DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
|
#5
|
|||
|
|||
|
Rounding results to nearest quarter (in decimals)
Thanks! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
|
#6
|
|||
|
|||
|
Rounding results to nearest quarter (in decimals)
If you can use the Analysis toolpack, there's a very cool function called
MROUND =MROUND(G25,.25) would be the formula, I believe. ************ Anne Troy www.OfficeArticles.com "djarcadian" wrote in message ... I figured this out- =ROUND(SUM(G25/2)*4,0)/4 Is there any reason to use the CEILING system instead of this system? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=479639 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
| Rounding number to the nearest quarter | Excel Worksheet Functions | |||
Linear Mode
