FormulaCraft

PI

PI() takes no arguments and returns π to 15 significant digits. Use it in geometric formulas for areas and circumferences, angle conversions between degrees and radians, and any trigonometric calculation.

Excel
=PI()*A2^2
Google Sheets
=PI()*A2^2
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

RadiusArea
1
3
5
10

=PI()*A2^2→3.1415926536

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1PI() takes no arguments — the parentheses are required but empty.
  2. 2A2 is the radius of a circle; the formula computes area = π × r².
  3. 3You can also use PI() in =2*PI()*A2 to compute circumference.

Need a version for your data?

Try: “Calculate the area of circles given a column of radii”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: