| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the Nearest Eighth
I have a problem with rounding down to the nearest eighth. For example: 100.334 and i need it to round to 100.25, I used some of the rounding suggestions found on the forum but it's not the working. I also need the rounding work when it is a negative number. For Example: -.655 it needs to round to -.625. Thanks, L.sean9 -- L.sean9 ------------------------------------------------------------------------ L.sean9's Profile: http://www.excelforum.com/member.php...o&userid=35681 View this thread: http://www.excelforum.com/showthread...hreadid=554767 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Interest to nearest eighth | Excel Discussion (Misc queries) | |||
| rounding to nearest hundred dollar in Excel | New Users to Excel | |||
| Formula for rounding to the nearst eighth of one percent | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
Threaded Mode
