| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up numbers to either a half or a whole depending on which side of 0.5 it is
Hi
Is there any way in Excel 2002 to do the above. E.g. My vertical sum comes to 15.2 so I want that changed to 15.5 or My vertical sum comes to 15.6 so I want that changed to 16 It doesn't matter if the rounding takes place in a different cell to the sum. TIA John |
| 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 to round negative and positive numbers | Excel Worksheet Functions | |||
| Round up to next half number | New Users to Excel | |||
| round to one of two numbers | Excel Worksheet Functions | |||
| numbers dont round up | Excel Discussion (Misc queries) | |||
Threaded Mode
