Round a number down

Round a number down

To do this task, use the ROUNDDOWN function.

EXAMPLE

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

1 2 3 4

A Data 20.3 -5.9 12.5493 Formula Description (Result) =ROUNDDOWN(A2,0) Rounds 20.3 down to the nearest whole number ( 20) =ROUNDDOWN(A3,0) Rounds -5.9 down (-5) =ROUNDDOWN(A4,2) Rounds the number down to the nearest hundredth, two decimal places ( 12.54)

Categories: ROUND