Problem with functions (2)

[icedearth23]

Thanx!! The formula helped me a lot!
1)But I was wondering if there is a function that returns the corresponding cell (cell in the same row, previous column) so that I don't have to type in a different formula every time but to have only one formula. If there is, can I put it inside
(A1*SIN(360/A1))/2 ?
2)Is there a function that returns the value of ð (the circle constant)?

 

[PaddyD]

there is no need to start new threads for the same topic:

http://mrexcel.com/board/viewtopic.php?topic=27885&forum=2&3