=ROUNDDOWN(A2,1)
The excel formula above rounds the value in cell A2 down by 1 decimal place. Let's say the value in A2 is 1.27. Well the value that will be displayed as a result of the rounddown formula is 1.2. The comma followed by the number one in the formula above tells excel to round the value in A2 down by 1 decimal place.
The excel formula above rounds the value in cell A2 down by 1 decimal place. Let's say the value in A2 is 1.27. Well the value that will be displayed as a result of the rounddown formula is 1.2. The comma followed by the number one in the formula above tells excel to round the value in A2 down by 1 decimal place.
