View Single Post
  #1   Report Post  
Old January 27th 10, 06:19 PM posted to microsoft.public.excel.worksheet.functions
bhoward425 bhoward425 is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default 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.