| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
ROUNDING
A pledge that I should also make
"BoniM" wrote: Yep... Thanx. And I hereby pledge to henceforth only read (and never write) when I'm suffering from sleep deprivation... ;-) "David Biddulph" wrote: I think BoniM intended to say that MROUND rounds to the nearest, *not* that it will only round up. -- David Biddulph "BoniM" wrote in message ... =MROUND(A1-0.125,0.25) Where A1 contains the number you wish to round. MROUND wil only round up, subtracting 0.125 forces a correction. "Bill Ridgeway" wrote: How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding | Excel Worksheet Functions | |||
| rounding help | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
Hybrid Mode
