Remember Me? January 27th 10, 06:19 PM posted to microsoft.public.excel.worksheet.functions
 bhoward425 external usenet poster First recorded activity by ExcelBanter: Jan 2010 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. January 27th 10, 06:45 PM posted to microsoft.public.excel.worksheet.functions
 Niek Otten external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,440 excel function to give the area of a circle?

=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. February 1st 10, 12:07 AM posted to microsoft.public.excel.worksheet.functions
 Bill Sharpe external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 348 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
 yaj Junior Member First recorded activity by ExcelBanter: May 2019 Posts: 1 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.

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post ivory Excel Worksheet Functions 5 July 23rd 09 03:09 PM Fareez Excel Worksheet Functions 1 June 11th 09 01:09 PM Lance Charts and Charting in Excel 2 December 5th 06 01:59 AM Ken Charts and Charting in Excel 3 August 4th 06 12:39 PM viraj Excel Worksheet Functions 4 April 28th 06 09:59 AM

All times are GMT +1. The time now is 12:36 AM. Copyright ©2004-2020 ExcelBanter.