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