formulas and functions - part 4

Round a number up by entering the ROUNDUP function manually

Let's round the average number of working hours up to the nearest whole number by entering the ROUNDUP function manually.

1. Click cell G11.

2. Click the formula bar.

3. Move the cursor to the point between “=” and “AVERAGE” by pressing the left arrow key.

4. Press the R key.

The function candidates that start with r automatically appear.

5. Press the O key.

The function candidates that start with ro automatically appear.

6. Click ROUNDUP in the list.

7. Press the Tab key.

The ROUNDUP function is entered into the formula bar. The popup menu appears and shows the syntax of the function.

Tip: The syntax of the ROUNDUP function ROUNDUP(number,num_digits) Number: The number which you want to round up. Num_digits: The number of digits to which you want to round the number.

8. Let’s enter the arguments for the ROUNDUP function. Firstly, set the number which you want to round up. Enclose the AVERAGE function (“AVERAGE(J5:J9)”) in parentheses.

9. Enter a comma.

10. Next, set the digits to which you want to round the number. In this case, enter zero (0) to round the number up to the nearest whole number of hours.

11. Enter a right parenthesis.

12. Press the Enter key.

The average number of working hours is rounded up.