# Circle & Sphere calculations in Excel using Pi 𝜋

Use these handy Excel formulas for circle and sphere calculations! Whether they’re a distant memory from school days or a recent discovery, you can easily compute them using Pi π, or as Excel dubs it, Pi().

Many formulas rely on Pi 𝜋 so Excel has a simple function Pi() which inserts Pi to 14 decimal places.  That’s accurate enough for almost any purpose including calculating planetary motions and saves everyone typing 3.14159265358979 over and over again.

## Circle formulas in Excel

Formulas to work out the Circumference, Area, Arc Length and Arc Area of a circle.

Copy any of these formulas into Excel, replace the names with cell references/names and you’re good to go!

## Sphere formulas in Excel

For a sphere or ball, here’s the Excel formulas for Surface Area and Volume.

## Earth, Moon and Sun calcs in Excel

Here’s the sphere formulas in practice for the surface area and volume of our planet and some near neighbors.

Pedantic Note: all the above assumes the Earth, Moon and Sun are completely spherical. The Earth and its moon are both oblate spheroids (they bulge at the equator due to axis spin). The Sun also has a slight bulge but it’s unexpectedly small.