## Tuesday, 18 October 2011

### Calculate circumference of a circle in excel

With using excel we can find circumference of a circle. If we know the radius value, diameter value or area value then we can calculate and find circumference of a circle.

There are some formula to calculate circumference of a circle in excel, is defined on below table :

With :
A = area of cirle
d = diameter of circle
C = circumference of cirles

For more detail, you can see table below :

1. Create table data

a. Cell B5 is a radius data
If we know radius value, then we can calculate the circumference of circle
b. Cell B9 is a diameter data
If we know diameter value, then we can calculate the circumference of circle
c. Cell B13 is a area data
If we know area value, then we can calculate the circumference of circle

2. Create formula below

2. Create formula to calculate area of circle
a. On cell E5 type formula :
=2*PI()*B5
b. On cell E9 type formula :
=PI()*B9
c. On cell E17 and E18 type formula :
=SQRT(B13/PI())
=2*PI()*E17
c. On cell E22 type formula :
=2*PI()*SQRT(B13/PI())

Result from above formula will show on below table

If you interest with this posting, you can download example files in excel format . You can download here Calculate circumferences of Circle