This article describes the =ROUNDDOWN formula and how to use it to round-down a set number of decimal places
The ROUNDDOWN function rounds a number down away from zero. The syntax is very simple and works in the same way as the ROUND function discussed in this article and the ROUNDUP function discussed in this article
The ROUNDDOWN syntax is:
=ROUNDDOWN(5.2,0) would round-up to 5
=ROUNDDOWN(7.65326,2) would round-up to 7.65
But instead of manually typing the numbers into the formula you can link the ‘number’ portion of the syntax to a cell reference e.g
=ROUNDDOWN(A1,0) would round-down the value in cell A1
Or take it a step further.
If you have lots of values that need to be rounded and you may need to change the ‘num_digits’ value, link that portion of the syntax to a control cell e.g
=ROUNDDOWN(A1,A3) where the ROUNDDOWN digits value is held in cell A3
There will be a future article discussing control cells.