Round Up Numbers In Excel With The Roundup Function

Options for inputting the function and its arguments include:

Type the complete function: =ROUNDUP(A2,2) into cell C3 in the worksheet; or Select the function and arguments using the function’s dialog box.

Using the dialog box simplifies entering the function’s arguments. 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. (In this case between A2 and 2.) Select cell see the function = ROUNDUP(A2, 2 ) in the formula bar above the worksheet. A function’s syntax refers to the layout of the function and includes the function’s name, brackets, and arguments. Number (required) is the value you want to round up. 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. Num_digits (required) is the number of digits that you want to round the Number argument to.

If the Num_digits argument is 0, the function rounds the value up to the nearest integer. 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 negative, the function removes all decimal places and rounds up that number of digits to the left of the decimal point.

For 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. That image also displays examples and explanations for several results returned by Excel’s ROUNDUP function for data in column A of the worksheet. The results, shown in column B, depends on the value of the Num_digits argument.