=7/PI()
The excel formula above will give you the diameter of the circumference value of 7. Which is 2.22816.
The excel formula above will give you the diameter of the circumference value of 7. Which is 2.22816.
Saturday, January 12, 2013
PI circumference formula
=3*PI()
The excel formula above will display the circumference value for the diameter of 3. Whch is 9.42477.
The excel formula above will display the circumference value for the diameter of 3. Whch is 9.42477.
PI formula
=PI()
The excel formula above will display the value of PI. Which is 3.141593.
The excel formula above will display the value of PI. Which is 3.141593.
SIGN formula
The excel "Sign" formula indicates if the value of a cell is positive, negative, or zero. The Sign formula does this by displaying a '1' for a positive value higher than zero. Displays a '-1' for negative values below zero. Also displays '0' for values equal to zero. So, =SIGN(2) will display a value of 1. =SIGN(0) will display a value of 0. Finally =SIGN(-7) will display a value of -1.
Wednesday, January 9, 2013
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.
=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.
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.
=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.
Saturday, January 5, 2013
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.
=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.
Subscribe to:
Posts (Atom)