To round down to the nearest specified place use the ROUNDDOWN function. For example if cell A1 contains 237825 and you want to round that value to two decimal places you can use the following formula. To round to the nearest multiple use the MROUND function.
How the Excel ROUNDUP function works The Excel roundup formula asks you to reference a specific number and then indicate how many units decimal places you want to round it to.
This function is present in all the versions of MS Excel. A function that rounds a number up away from 0 zero. Press Enter or Return. As a worksheet function the ROUNDUP function can be entered as part of a formula in a cell of a worksheet.