ROUND, ROUNDUP, ROUNDDOWN in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the ROUND function do in Excel?

The ROUND function rounds a number to a specified number of digits. It rounds up or down depending on the value of the next digit.

beginner

How does ROUNDUP differ from ROUND in Excel?

ROUNDUP always rounds a number up, away from zero, regardless of the next digit.

beginner

What is the behavior of ROUNDDOWN in Excel?

ROUNDDOWN always rounds a number down, towards zero, no matter what the next digit is.

beginner

Write the formula to round the number in cell A1 to 2 decimal places using ROUND.

Use =ROUND(A1, 2) to round the number in A1 to 2 decimal places.

beginner

If you want to round the number 3.14159 down to the nearest whole number, which function and formula would you use?

Use =ROUNDDOWN(3.14159, 0) to round down to the nearest whole number, which gives 3.

What does =ROUND(2.678, 2) return?

A 2.67

B 3.00

C 2.60

D 2.68

ROUND rounds to the nearest value. Since the third decimal is 8 (greater than or equal to 5), it rounds up to 2.68.

Which function always rounds numbers up, no matter what?

A ROUND

B ROUNDDOWN

C ROUNDUP

D INT

ROUNDUP always rounds numbers up, away from zero.

What is the result of =ROUNDDOWN(-3.7, 0)?

A -3

B -4

C -3.7

D -3.0

ROUNDDOWN rounds towards zero, so -3.7 becomes -3.

How would you round the number 123.456 to the nearest ten using ROUND?

A =ROUND(123.456, -1)

B =ROUND(123.456, 1)

C =ROUNDUP(123.456, 1)

D =ROUNDDOWN(123.456, 1)

Using -1 rounds to the nearest ten place.

What does =ROUNDUP(4.321, 1) return?

A 4.3

B 4.4

C 4.0

D 5.0

ROUNDUP rounds up to 1 decimal place, so 4.321 becomes 4.4.

Explain the difference between ROUND, ROUNDUP, and ROUNDDOWN functions in Excel.

Think about how each function treats the digits after the rounding place.

Describe how to round a number to the nearest hundred using the ROUND function.

Digits argument controls decimal places or places to the left of decimal.