I have a list of numbers in column A that go to several decimal places (e.g. A1 is
27.34). Is there a way to fill column B with the same values as column A, but rounding to the nearest integer?
excel has a floor() funcion
The syntax for the FLOOR function is:
FLOOR( number, significance )
number is the number that you wish to round down.
significance is the multiple of significance that you wish to round a number to.
Another way, without using functions, is to use the Decrease Decimal button from the Number group in the Home tab.
Click cell B1 , type
I would use the RoundDown function, as it is designed specifically for what you are asking.
It takes two arguments, the first being the number [or cell reference] you want to round down, the second being the amount of decimals it should have.
=ROUNDDOWN(3.1456,0) becomes 3
=ROUNDDOWN(3.1456,1) becomes 3.1
=ROUNDDOWN(3.1456,2) becomes 3.14
=ROUNDDOWN(3.1456,3) becomes 3.145
=ROUNDDOWN(3.1456,4) becomes 3.1456