Today I want to explore a simple formula ROUNDDOWN and its
brother ROUNDUP.
There are times when you don’t want to display the entire
value. In my below example, column A shows an entire value.
So what does ROUNDDOWN do?
The ROUNDDOWN function returns a number rounded down to a
specified number of digits. Always rounding towards 0.
The ROUNDDOWN function returns a number rounded upward to a
specified number of digits. Always rounding away from 0.
Here is an example of ROUNDDOWN and ROUNDUP.
A

B

C

D

E

F


1

Value

Result

Formula

Result

Formula


2

15.75654

15

=ROUNDDOWN(A2,0)

16

=ROUNDUP(A2,0)


3

15.75654

15.7

=ROUNDDOWN(A3,1)

15.8

=ROUNDUP(A3,1)


4

15.75654

15.75

=ROUNDDOWN(A4,2)

15.76

=ROUNDUP(A4,2)


5

15.75654

15.756

=ROUNDDOWN(A5,3)

15.757

=ROUNDUP(A5,3)


6

15.75654

15.7565

=ROUNDDOWN(A6,4)

15.7566

=ROUNDUP(A6,4)


7

15.75654

15.75654

=ROUNDDOWN(A7,5)

15.75654

=ROUNDUP(A7,5)

Now it’s important to understand what happens when you
multiply a number based on the ROUNDDOWN or ROUNDUP function.
Let’s look at cell A2, The ROUNDDOWN result is 15 and the
ROUNDUP is 16
If I was to multiply the original value by 2 my result would
be 31.51308 (2 X 15.75654).
However if I multiply my ROUNDDOWN or ROUNDUP result, I get
a very different answer.
15 X 2 = 30
16 X 2 = 32
So use caution when using ROUNDDOWN or ROUNDUP since
calculations downstream may not produce the result you are expecting.
BEGINNER, ROUNDDOWN, ROUNDUP