# PI function in Excel

> PI returns the constant π, accurate to 15 digits (3.14159265358979).

Source: https://spreadsheetpractice.com/functions/pi · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** PI returns the constant π, accurate to 15 digits (3.14159265358979).
- **Syntax:** `=PI()`
- **Most common use:** `=PI()` returns 3.141592654 (π itself; the cell shows as many digits as fit)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** π, to 15 significant digits.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

PI returns the constant π, accurate to 15 digits (3.14159265358979). It takes no arguments, but it still needs its empty brackets. Use it for anything with circles: areas, circumferences, cylinder volumes and converting degrees to radians.

## Syntax

`=PI()`



## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=PI()` | 3.141592654 | π itself; the cell shows as many digits as fit |
| D3 | `=PI()*B3^2` | 153.94 | Area of a 14-inch pizza: about 153.94 sq in |
| D4 | `=2*PI()*B3` | 43.98 | Circumference of the same pizza: about 43.98 in |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  |  |
| 2 | Pizza diameter (in) | 14 |  | 3.141592654 |
| 3 | Radius (in) | 7 |  | 153.94 |
| 4 |  |  |  | 43.98 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NAME? | PI was typed without its brackets. Write =PI(), not =PI. |
| The area is four times too big | You squared the diameter. Area uses the radius: half the diameter. |
| Small differences from a textbook | Typing 3.14 loses accuracy. Use PI() instead. |

## Tips

- Degrees to radians: =A2*PI()/180, the same as RADIANS(A2).

## Related functions

- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.
- [SQRT](https://spreadsheetpractice.com/functions/sqrt): SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.

## Questions

### How do I use pi in Excel?

Type =PI(). For a circle's area, use =PI()*r^2.

### How many digits of pi does Excel use?

15 significant digits: 3.14159265358979.

## Practice

A graded PI exercise ("Tank volumes") is on [the PI page](https://spreadsheetpractice.com/functions/pi). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
