Truncate to zero decimal place formula

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

Read More..

Truncate minus 2 decimal places

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.

Read More..

Truncate back minus 1 decimal place

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. 110. The negative number, -1 after the cell reference of A2 and the comma is telling excel to truncate the value of 111.13 back minus 1 decimal place. Giving  the value of 110.

Read More..

Truncate to 1 decimal place formula

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

Read More..

Truncate to 2 decimal places formula

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.

Read More..