Math
PI
Definition
PI returns the constant 3.14159265358979, the ratio of a circle's circumference to its diameter.
Syntax
=PI()
Arguments
| Argument | Meaning |
|---|---|
(none) |
PI takes no arguments, but the empty parentheses are still required. |
Worked example
A tank lid is a circle. Radii are in B2:B4.
| A: Lid | B: Radius |
|---|---|
| 1 | 2 |
| 2 | 3 |
| 3 | 1 |
Formula: =PI()*B2*B2
Result: 12.56637061. Two squared is 4, and 4 times PI is the area of that lid.
Practice
Cell B2 holds 1. In C2, write PI().
- In C2, write a PI formula.
Step 1 of 1
Enter =PI() in C2.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses PI.
Related functions
SQRT and POWER are the usual partners when a circle formula needs a root or an exponent.
Common mistake
Writing PI without parentheses, as in =PI*B2: Excel does not treat PI as a name, so the formula returns #NAME!.