| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| excel formula | Excel Discussion (Misc queries) | |||
| How do figure excel formula out? | Excel Discussion (Misc queries) | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
