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