0 of 46 lessons complete.

Module 2: Core Functions · Lesson 15 of 46

ROUND Function

Round results to a set number of digits.

Step 1 of 20%

ROUND takes a number and how many decimal places to keep. In B2, round A2 to 2 decimal places.

Target: B2

A1
ABCDEF
1
Raw value
Rounded
2
3.14159
3
1234.567
4
5
6
7
8

Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $

Enjoying the site?

Every tool here is free. If it helped you, consider buying me a coffee.

Buy me a coffee