Let's say the cell reference of A2 below has a value of 111.13:
=trunc(A2,1)
The value that would be displayed as a result of the formula above would be. 111.1. The number 1 after the cell reference of A2 and the comma is telling excel to truncate the value of 111.13 back 1 decimal place. Giving 111.1
=trunc(A2,1)
The value that would be displayed as a result of the formula above would be. 111.1. The number 1 after the cell reference of A2 and the comma is telling excel to truncate the value of 111.13 back 1 decimal place. Giving 111.1
0 comments:
Post a Comment