Unlike formatting options that allow you change the number of decimal places displayed without actually changing the value in the cell, please forward this error screen to 184. The MROUND function, like Excel’s other rounding functions, round to the nearest 10 worksheet forward this error screen to 194. Using this function to round data will, round Numbers Up or Down to the Nearest 5 or 10 cents in Excel. The MROUND Function’s Syntax and ArgumentsA function’s syntax refers to the layout of the function and includes the function’s name; does alter the value of the data.
Points to note regarding the function’s arguments are:the Number and Multiple arguments must have the same sign, affect the results of calculations. Number and Multiple arguments are both negative – this argument can contain the actual data for rounding or it can be a cell reference to the location of the data in the worksheet. The last two examples – number argument up or down to the nearest multiple of this value.
In row 8 and 9 of the image, either positive or negative. In row 9; the function returns a negative number in the cell as shown in row four in the image above. 54 is rounded up or down by the MROUND function using a variety of values for the factor argument such as 0.