Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Function
I am using Excel 2007 and need some helping on a rounding formula. I would
like my cell to either round to the nearest whole num or ".5" of the number but it needs to round down. For example: 5.1 would round to 5.0 5.4 would round to 5.0 5.5 would round to 5.5 5.7 would round to 5.5 5.9 would round to 5.5 6.0 would round to 6.0 I am using the Mround function but that rounds up so 5.8 and 5.9 rounds to 6.0 but I need them both to round to 5.5. Any thoughts? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round up function | Excel Discussion (Misc queries) | |||
Round Len Function Help | Excel Worksheet Functions | |||
how do i set up round function | Excel Worksheet Functions | |||
The ROUND function | Excel Worksheet Functions | |||
help with round function | Excel Worksheet Functions |