PI Function in Microsoft Excel: Examples, Pitfalls & Compatibility
PI in Microsoft Excel: use the mathematical constant pi in circle and angle calculations without typing a rounded approximation. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Microsoft Excel. How formula examples are checked
Quick answer: Use PI in Microsoft Excel to use the mathematical constant pi in circle and angle calculations without typing a rounded approximation. The official PI reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=PI()
no arguments: Keep the empty parentheses; no radius or angle is passed into PI itself.
Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use PI as a constant inside a larger expression. Multiply it by a radius or diameter for circumference, or by the square of the radius for area. The function itself does not know the dimensions or units of your shape.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Microsoft Excel.
Example 1: Display pi to six decimal places
=ROUND(PI(),6)
Expected result: 3.141593.
Rounding is applied to the final displayed constant, not to a typed approximation used as an input.
Example 2: Calculate area from a radius of five
=ROUND(PI()*5^2,6)
Expected result: 78.539816.
The area is pi multiplied by 25. The unit is the square of the radius unit.
Example 3: Calculate circumference from a radius of five
=ROUND(2*PI()*5,6)
Expected result: 31.415927.
Circumference is twice pi times the radius. It has the same length unit as the radius.
Put it to work safely
Write down whether the input is a radius or diameter before building a formula. Using a diameter as if it were a radius makes the calculated area four times as large. Keep dimensions in a consistent unit and round only the displayed or final reported result, rather than replacing PI with a short typed decimal before the calculation.
Common mistakes and fixes
A circle area is four times too large. The supplied dimension may be a diameter rather than a radius. Review the geometric input before changing the formula.
The formula omits parentheses. PI is written as PI() even though it takes no arguments.
Displayed decimals are mistaken for a precision guarantee. The display and the underlying numerical approximation are separate. Do not infer a guaranteed internal digit count solely from a formatted cell.
Microsoft Excel-specific notes
Microsoft describes its returned constant as accurate to 15 digits. The examples deliberately round final answers to six decimals so their intended reporting precision is explicit. See the vendor reference for the current definition.
Excel and Google Sheets comparison
The geometric formulas are portable in meaning. Display settings and precision descriptions do not prove bit-for-bit equivalence. Keep the radius-versus-diameter distinction explicit when moving a workbook.
Compare the PI guide for Google Sheets and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Microsoft Excel calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.