# Circle & Sphere Formulas in Excel using Pi 𝜋

Here’s some common circle and sphere calculations that you might remember from school (or long forgotten) but now as Excel formula using Pi 𝜋 or as Excel calls it, Pi().

Many formulas rely on Pi 𝜋 so Excel has a function Pi() which inserts it 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.