=Round(A2,1)
The excel formula above rounds the value in cell A2 up 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 round formula is 1.3. The comma followed by the number one in the formula above tells excel to round the value in A2 up by 1 decimal place.
The excel formula above rounds the value in cell A2 up 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 round formula is 1.3. The comma followed by the number one in the formula above tells excel to round the value in A2 up by 1 decimal place.
