Example: Calculate Pi (3.1415926) in Microsoft Excel

You are wondering what is Pi and how it is calculated. Find out here.

Pi is the ratio of a circle and the square that surrounds this circle.

The area of a square is

Side x Side = Area

The Area of a circle is

PI x r^2

r being the radius.

As the radius is equal to half the Side of the square. The area of the circle can be rewritten to

1/4 x Pi x Side^2

So the ration of the circle to the square is Pi/4.

Lets try this with Excel.

Look at the following screenshot and download the spreadsheet.

Beware the sheet has 1600 lines so it is quite big.

Pi example

and this is the Graph

Pi circel

You can see in blue the items in the circle and in red the items outside.

The ratio of Blue / (Blue+Red) = Pi/4

Have fun.

Here the value of Pi to a few hundert digits....of course this example will not allow you this but one thing it will let you know

is if your random (RAND) number generator is of good quality. If it is, the value of PI should be approached quite fast. If not, then

the RAND generator cannot be trusted fully.


You can download this example here.

and in older Excel format here.