finding yhe area of a polygon

bengoodwin · Feb 15th 2003

how do i work out the area of a polygon in excel 97 this is for my maths coursework which has to be in very soon so any help would be most appreciated

s_u_resh · Feb 15th 2003

TELL ME CLEALY

bengoodwin · Feb 15th 2003

i need to know the forulas for tan radians etc. to find the area of a polygon

blue · Feb 17th 2003

Hi there! Hope not too late for you! I started this first thing this morning but a little detail like work interfered!

=((I11/4)*1/TAN(RADIANS(I13/2)))*(I12^2)
Where I11 = Number of Sides
I12 = Length of One Side
I13 = Angle (360/Number of Sides)

Hope this is what you were looking for!

imported_Anonymous · Feb 18th 2003

Hi blue,
very neet solution, impressive.
Regards, Manfred

finding yhe area of a polygon

Participate now!

Share