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
No comments:
Post a Comment