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

R

Rona

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!
 
D

Dave Peterson

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.
 
D

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.
 
Top