### ROUNDDOWN vs ROUNDUP

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