ROUND

Rounds a number to a specified number of decimal places

Updated over a week ago

Description

The ROUND() function is used to round a given number to a specified number of decimal places. It's helpful for simplifying data or financial calculations to a specific precision.

Syntax

ROUND(number, [decimals])

Output

number

Variables

  1. number: The numeric value you want to round.

  2. decimals: (Optional) The number of decimal places to which you want to round. If omitted, defaults to 0.

Example

ROUND(`Price (USD)`,1)

Product

Price (USD)

Quantity Sold - NY

ROUND

Product A

25.99

150

26

Product B

14.75

280

15

Product C

7.99

500

8

Product D

35.20

90

35

Product E

50.00

120

50

Did this answer your question?