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
r = radius of circles
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


Related Posts by Categories



3 comments:

  1. Hi,
    Last many days I am searching some good article and I am very glad to find your article. This is very essential and informative information for me. I would like to say your post is superb and relevant my topics.
    Thanks

    ReplyDelete
  2. Thanks for sharing the best information. It is very useful information for us. I really like your way of expressing the opinions. I like your blog because your posts are always informative me.

    ReplyDelete
  3. Want to make a program by using Circumference of Circle Formula and all such relevant forumlas to calculate areas .Please help me in finding logic .

    ReplyDelete

Random Posts