PI function

PI() returns the mathematical constant pi (approximately 3.14159), essential for calculating areas, circumferences, and circular measurements in any domain.

=PI()

Generate a PI formula

Describe what you need. The generator will reach for PI where PI is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

ArgumentRequiredDescription

Returns

A number representing pi to 15 decimal places (3.14159265358979).

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Calculate tire circumference from wheel diameter

VehicleService DateTire Diameter (inches)
Truck-012024-03-1532
=PI()*32

Result: 100.53

A tire with 32-inch diameter has a circumference of 32 × PI() = 100.53 inches. Maintenance teams use this to predict wear patterns—knowing the circumference helps estimate rotations per mile and predict tire replacement intervals based on odometer readings.

2. Calculate storage area from circular garage lift pads

Garage LocationLift Pad Radius (feet)
North Bay2
=PI()*2^2

Result: 12.57

Lift pads in the North Bay garage are circular with a 2-foot radius. The area covered is PI() × 2² = 12.57 square feet. Facility planners use this to allocate workspace, calculate how many lifts fit in the bay, and optimize vehicle throughput.

3. Estimate fuel tank capacity using cylindrical tank dimensions

VehicleTank Diameter (feet)Tank Height (feet)Cost (refuel)
Truck-0134$85
=PI()*(3/2)^2*4

Result: 28.27

A cylindrical fuel tank with 3-foot diameter (1.5-foot radius) and 4-foot height has volume PI() × 1.5² × 4 = 28.27 cubic feet. Fleet managers use this to estimate fuel capacity, calculate refueling frequency, and plan logistics based on vehicle range.

Common errors

Which PI error are you seeing?
PI returned an error#NAME?
Use exactly =PI() with both parentheses and no arguments. Function names are case-insensitive, but parentheses are required.
#VALUE!
Remove all arguments and write =PI() with empty parentheses. Perform calculations outside: =PI()*diameter instead of =PI(diameter).
#NUM!
Break complex calculations into multiple steps using intermediate cells. Verify that exponents and operands are within reasonable ranges for your spreadsheet.
ErrorWhy it happensHow to fix it
#NAME?PI is misspelled or missing parentheses, such as Pi(), pi(), or =PI without ().Use exactly =PI() with both parentheses and no arguments. Function names are case-insensitive, but parentheses are required.
#VALUE!PI() is called with arguments, such as =PI(2), =PI(diameter), or =PI(cell), when the function expects zero parameters.Remove all arguments and write =PI() with empty parentheses. Perform calculations outside: =PI()*diameter instead of =PI(diameter).
#NUM!In formulas using PI() with extremely large exponents or operations exceeding numerical limits, such as =PI()^10000, calculation overflow occurs.Break complex calculations into multiple steps using intermediate cells. Verify that exponents and operands are within reasonable ranges for your spreadsheet.

Tips and when to use something else

  • Use ROUND() after PI() calculations to limit decimal places for readability: =ROUND(PI()*diameter, 2) displays 100.53 instead of 100.53096...
  • Combine PI() with MOD() when working with angles or rotational values to normalize results to a standard range, useful for cyclic calculations in drivetrains.
  • For volume and area calculations requiring multiplication, use PRODUCT() to chain multiple values: =PRODUCT(PI(), radius, radius, height) computes cylinder volume clearly.
  • Always use PI() instead of hardcoding 3.14; PI() provides 15-decimal precision, which is essential for technical calculations in fleet maintenance and engineering.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).PRODUCTReturns the product of all numeric values supplied as arguments, multiplying them together into a single result.MODMOD returns the remainder after dividing one number by another, making it useful for identifying patterns, cycles, and divisibility in data.MROUNDMROUND rounds a number to the nearest multiple of a specified value, useful for rounding to standard increments like 5, 10, or 100.IFERRORIFERROR returns the result of a formula unless that formula generates an error, in which case it returns a user-specified alternative value.

Frequently asked questions

What is the exact value that PI() returns?
PI() returns the mathematical constant to 15 decimal places: 3.14159265358979. This precision is sufficient for virtually all engineering and scientific calculations. Excel and Google Sheets return identical values.
Can I use PI() for calculations other than circles?
Yes. PI() is essential for any periodic, rotational, or oscillating calculation—gear ratios, shift frequencies, wave analysis, or probability distributions. Any domain involving cycles, angles, or periodicity benefits from PI().
Should I use PI() or the number 3.14?
Always use PI(). It provides 15 decimal places of precision, making results far more accurate than 3.14 (2 decimals). Hardcoding 3.14 introduces a 0.001% error—appropriate only for rough estimates, never for engineering work.
Do Excel and Google Sheets return different PI() values?
No. Both platforms return the identical PI() value to the same precision. Formulas using PI() are fully compatible across spreadsheet applications, so you can safely share workbooks without precision concerns.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17