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!
ReplyDelete