ROUND, ROUNDUP, ROUNDDOWN in Excel - Cell-by-Cell Formula Trace

Sample Data

This data shows three decimal numbers in column A and the number of decimal places to round to in column B.

Cell	Value
A1	3.14159
A2	2.71828
A3	-1.23456
B1	2
B2	1
B3	0

Formula Trace

=ROUND(A1,B1)

Step 1: ROUND(3.14159, 2)

Cell Reference Map

    A       B
1 |3.14159 | 2 |
2 |2.71828 | 1 |
3 |-1.23456| 0 |

The formula uses the value in cell A1 (3.14159) and rounds it to the number of decimal places specified in B1 (2).

Result

    A       B       C
1 |3.14159 | 2 | 3.14 |
2 |2.71828 | 1 |      |
3 |-1.23456| 0 |      |

The result of the formula ROUND(A1,B1) is 3.14 shown in cell C1.

Sheet Trace Quiz - 3 Questions

What does ROUND(2.71828, 1) return?

A 2.7

B 3

C 2.72

D 2.71

Key Result

ROUND(number, digits) rounds to nearest; ROUNDUP always rounds away from zero; ROUNDDOWN always rounds towards zero.