Select the FormulasВ tab of the ribbonВ menu.Select cell C3 to make it the active cellВ - this is where the results of the ROUNDUP function will be displayed.

With this method, it's not necessary to key in commas between each of the function's argumentsВ as you must when typing the function into a cell.

Using the dialog box simplifies entering the function's arguments.

Select the function and arguments using the function's dialog box.

Type the complete function: =ROUNDUP(A2,2)В into cell C3 in the worksheet or.

Options for inputting the function and its arguments include: In the process, the function will increase the value of the rounding digit by one. In this example, we're going to reduce the number in cell A2 (above) to two decimal places using the ROUNDUP function.

If the Num_digits argument is negative, the function removes all decimal places and rounds up that number of digits to the left of the decimal point.ДЇor example, if the value of the Num_digits argument is -2, the function will remove all digits to the right of the decimal point and round the first and second digits to the left of the decimal point up to the nearest 100.

If the Num_digits argument is 1, the function leaves only one digit to the right of the decimal pointВ and rounds it up to the next number.

If the Num_digits argument is 0, the function rounds the value up to the nearest integer.

Num_digits (required) is the number of digits that you want to round the Number argument to. 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. Number (required) is the value you want to round up. This is the syntax for the ROUNDUP function:ДЄ function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

Excel for mac 2016 review