PI function

The PI function in Excel returns the mathematical constant π (Pi), which is approximately 3.14159. This function doesn’t require any arguments and is commonly used in mathematical, engineering, and scientific calculations that involve circles, spheres, and trigonometry.

Syntax

=PI()

Description

• The PI function provides the value of π (Pi) to 15 decimal places, which is typically used in formulas that require Pi.
• This function doesn’t require any parameters or arguments.

Example

To use the PI function in a calculation, such as calculating the area of a circle:

Example 1: Calculate the area of a circle with a radius of 5 units.

The formula for the area of a circle is:

$$\text{Area} = \pi \times \text{radius}^2$$

Using the PI function:

=PI() * 5^2

Result:

The result will be 78.5398163397448, which is the area of the circle with radius 5.

Example 2: Calculate the circumference of a circle with a radius of 7 units.

The formula for the circumference of a circle is:

$$\text{Circumference} = 2 \pi \times \text{radius}$$

Using the PI function:

=2 * PI() * 7

Result:

The result will be 43.9822971502571, which is the circumference of the circle with radius 7.

Usage Notes

• The PI function is useful in many areas of math, physics, and engineering, especially for calculations involving circles, waves, and periodic functions.
• The value of π returned by the function is highly precise, and for most common applications, it is accurate to 15 decimal places.