Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 10, 06:19 PM posted to microsoft.public.excel.worksheet.functions
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.

  #2   Report Post  
Old January 27th 10, 06:45 PM posted to microsoft.public.excel.worksheet.functions
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:

=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   Report Post  
Old February 1st 10, 12:07 AM posted to microsoft.public.excel.worksheet.functions
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
  #4   Report Post  
Old May 6th 19, 06:10 AM
yaj yaj is offline
Junior Member
 
First recorded activity by ExcelBanter: May 2019
Posts: 1
Cool 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a function in excel to give either a < or =? ivory Excel Worksheet Functions 5 July 23rd 09 03:09 PM
Give me a Function Fareez Excel Worksheet Functions 1 June 11th 09 01:09 PM
How do I make circle within circle graphs in Excel 2003? Lance Charts and Charting in Excel 2 December 5th 06 01:59 AM
How do I set up a circle within a circle chart? Ken Charts and Charting in Excel 3 August 4th 06 12:39 PM
How to give function by cell color to sum two value in Excel viraj Excel Worksheet Functions 4 April 28th 06 09:59 AM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017