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
Hi,
ReplyDeleteLast 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
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.
ReplyDeleteWant 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