| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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 |
| 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 | |||
Threaded Mode
