Tuesday, 18 October 2011

How to Calculate the Area of a Circle

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

Related Posts by Categories



1 comment:

  1. 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

Random Posts