There are some formula to calculate circumference of a circle in excel, is defined on below table :
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 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