| Home |
| Search |
| Today's Posts |
|
#5
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
"John Williams" wrote in message ... Hi Thanks for the two replies both of you. They both work, but if the sum does equal say 15.5 then they both round that up to 16 and not leave it at 15.5 =ROUNDUP((A1-0.1)/5,1)*5 -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) |
| 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
