Quick Navigation

PI Function

Excel 2007+

Summary

The PI function returns the mathematical constant π (pi) with high precision, accurate to 15 decimal places. This is essential for geometric calculations, trigonometry, and any formula requiring the circle constant.

Syntax

PI()

Using the PI Function

PI() provides the value of pi for calculations involving circles, spheres, trigonometry, and other mathematical operations requiring this fundamental constant. It's more reliable than hardcoding the value.

Common PI Examples

Basic PI Value

=PI()

Returns the value of pi: 3.14159265358979

Half Circle Calculation

=PI()/2

Returns π/2 ≈ 1.57079632679, useful for quarter-circle areas or semicircle perimeters

Circle Area

=PI()*A1^2

Calculates area of circle with radius in A1. For radius=3, returns ≈28.27433388

Circumference

=2*PI()*A1

Calculates circumference with radius in A1. For radius=5, returns ≈31.41592654

Frequently Asked Questions

PI() provides full precision (15 digits) vs. limited decimal places, preventing cumulative rounding errors in complex calculations.

Yes, PI() has been available since early Excel versions and works in Excel 365, 2021, 2019, and all prior versions.

Yes, PI() always returns 3.14159265358979 - the same precise value across all calculations and workbooks.

Common Errors and Solutions

#NAME? error

Cause: PI misspelled or unavailable (very rare)

Solution: Check spelling: must be PI() exactly, no arguments needed

Unexpected results in calculations

Cause: Cell formatted to show fewer decimals

Solution: Use more decimal places or format as Number with 15+ decimals to see full precision

Notes

PI() returns exactly 3.14159265358979 (15 digits)
Faster than calculating 4*ATAN(1)
Use with POWER() for cleaner formulas: PI()*POWER(radius,2)
Combine with trigonometric functions like SIN(), COS()

Compatibility

Available in: Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, All earlier versions

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+