A circle is one of the geometric shapes, sometimes we need to calculate the radius, diameter, area or circumferences of circle. With using excel we can find the radius, diameter, area or circumferences of circle using formula below :

For example :

1. Create table below

There are 3 cell contain data .

a. Cell B5 is a radius data

If we know radius value, then we can calculate the area of circle

b. Cell B9 is a diameter data

If we know diameter value, then we can calculate the area of circle

c. Cell B13 is a circumferences data

If we know circumferences value, then we can calculate the area of circle

2. Create formula to calculate area of circle

a. On cell E5 type formula :

=PI()*(B5^2)

b. On cell E9 type formula :

=PI()*(B9^2)/4

c. On cell E17 and E18 type formula :

=(B13/(2*PI()))

=PI()*(E17^2)

c. On cell E22 type formula :

=PI()*(B13/(2*PI()))^2

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 Area of Circle

This was some enormous content, I had some troubles getting out of the issue, but your step by step guidance made it simple to figure out the issue. Thanks a lot for this great post. Cheers!

This was some enormous content, I had some troubles getting out of the issue, but your step by step guidance made it simple to figure out the issue. Thanks a lot for this great post. Cheers!

ReplyDelete