View Single Post
  #3   Report Post  
Old February 1st 10, 12:07 AM posted to microsoft.public.excel.worksheet.functions
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 348
Default 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