View Single Post
  #2   Report Post  
Old January 27th 10, 06:45 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default excel function to give the area of a circle?

With the radius in A1:


Or, with the diameter in A1:


Kind regards,

Niek Otten
Microsoft MVP - Excel

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