Skip to main content
ROUNDDOWN

Rounds a number down to the nearest integer

Updated over a year ago

Description

The ROUNDDOWN() function rounds a given number down to the nearest whole number or integer. It's useful for scenarios where you need to truncate decimal values without rounding.

Syntax

ROUNDDOWN(number)

Output

integer

Variables

  1. number: The numeric value you want to round down to the nearest integer.

Example

ROUNDDOWN(`Price (USD)`)

Product

Price (USD)

Quantity Sold - NY

ROUNDDOWN

Product A

25.99

150

25

Product B

14.75

280

14

Product C

7.99

500

7

Product D

35.20

90

35

Product E

50.00

120

50

Did this answer your question?