Excel PI function
The PI function returns the number 3.14159265358979 of the mathematical constant called pi.
It returns a numeric value.
The examples below demonstrate how to use the PI function in Excel.
# Example 1
To return the result of pi, just enter the formula below into a cell (such as D6 in this case), and then press Enter.
# Example 2
To calculate the area of a circle with the radius provided in B9, you need to enter the following formula into a blank cell (such as cell D9 in this case), and then press Enter to get the result.
# Example 3
Cell D12 returns the result of multiplying pi by a number provided in cell B12 with the formula below:
# Example 4
The PI function can also be used to convert angle degrees to radians.
As shown in the screenshot below, in range B6:B14, there is a list of angel degrees, to convert these angle degrees to corresponding radians, you need to:
Select a blank cell, enter the following formula and press the Enter key to get the first result. Then drag its AutoFill Handle down to get the radians of other angle degrees.