| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round Down to the nearest multiple
could anyone help me out with a formula similar to MROUND but that always
rounds down? for example I have in cell A1 5.99 and I want to round this to the nearest LOWER 1/8th. So as where MROUND would give me 6.00, i need this formula to round to 5.875. any help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
| How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
| How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
| Round to nearest multiple | Excel Discussion (Misc queries) | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
Threaded Mode
