Home 
Search 
Today's Posts 
#1




excel function to give the area of a circle?
I'm working my way through learning to build spreadsheets. How would I create
the function to give the area of a circle. I know the formula A=PI*r(squared) but don' know the excel functions. I tried "=(PI)*(Power('diameter cell'/2),2)" but that wouldn't work. 
#2




excel function to give the area of a circle?
With the radius in A1:
=PI()*A1^2 Or, with the diameter in A1: =PI()*(A1/2)^2  Kind regards, Niek Otten Microsoft MVP  Excel "bhoward425" wrote in message ... I'm working my way through learning to build spreadsheets. How would I create the function to give the area of a circle. I know the formula A=PI*r(squared) but don' know the excel functions. I tried "=(PI)*(Power('diameter cell'/2),2)" but that wouldn't work. 
#3




excel function to give the area of a circle?
On 1/27/2010 10:19 AM, bhoward425 wrote:
I'm working my way through learning to build spreadsheets. How would I create the function to give the area of a circle. I know the formula A=PI*r(squared) but don' know the excel functions. I tried "=(PI)*(Power('diameter cell'/2),2)" but that wouldn't work. see Excel help for PI. If radius is in cell A1, either of these formulas should work: =PI()*A1^2 =PI()*A1*A1 Bill 
#4




using ranges to determine aggregate areas
I can get the areas of individual diameters, but I need to get the total for a range of diameters. If I have 10 different measurements of tree limbs, I need the total area of the 10 limbs. Right now, I have to calculate each one separately and then add them up.
=(3.14*(C2/2)^2)+(3.14*(D2/2)^2)+(3.14*(E2/2)^2)+(3.14*(F2/2)^2)+(3.14*(G2/2)^2)+(3.14*(H2/2)^2)+(3.14*(I2/2)^2)+(3.14*(J2/2)^2)+(3.14*(K2/2)^2)+(3.14*(L2/2)^2)+(3.14*(M2/2)^2) There otta be a better way ... and I broke me head trying to find it. Not a math whiz, but competent with simple formulas. This is a practical exercise for a horticulturalist who consults on trees all the time. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do I set up a function in excel to give either a < or =?  Excel Worksheet Functions  
Give me a Function  Excel Worksheet Functions  
How do I make circle within circle graphs in Excel 2003?  Charts and Charting in Excel  
How do I set up a circle within a circle chart?  Charts and Charting in Excel  
How to give function by cell color to sum two value in Excel  Excel Worksheet Functions 