How can i imput a formula in excel for finding the area of a regu.
 

Please help! I have come up with a mathematical formula for finding the area
of a regular sided polygon with n number of sides but i can't get it to work
in excel as its not exactly my strongest aspect of ict! If anyone can help
please do!

One way:

=0.25*A1*(A2^2)*(1/TAN(RADIANS(180/A1)))

With the number of sides in A1
and the length of each side in A2.



Rona wrote:

Please help! I have come up with a mathematical formula for finding the area
of a regular sided polygon with n number of sides but i can't get it to work
in excel as its not exactly my strongest aspect of ict! If anyone can help
please do!

--

Dave Peterson

Or this simpler formula:

=0.25*A1*(A2^2)*(1/TAN(PI()/A1))

Still with the number of sides in A1
and the length of each side in A2.


Dave Peterson wrote:

One way:

=0.25*A1*(A2^2)*(1/TAN(RADIANS(180/A1)))

With the number of sides in A1
and the length of each side in A2.

Rona wrote:

Please help! I have come up with a mathematical formula for finding the area
of a regular sided polygon with n number of sides but i can't get it to work
in excel as its not exactly my strongest aspect of ict! If anyone can help
please do!

--

Dave Peterson

--

Dave Peterson