Pyramid calculate

[Michel Norway]

How do I calculate a pyramid using existing formels in exel. Exampel if the
pyramid is 10x10 m² and 45˚, and I want to find out m² wall surface.

 

[Stefi]

This is not an Excel specific question but if I recall my school studies, in
case of a 45Ëš pyramid the formula is
=(2*A1^2)/SQRT(2)+A1^2 (=241,4213562)

10 being in A1

Sorry if I made a mistake!

Regards,
Stefi

„Michel Norway†ezt írta:

 

[Michel Norway]

Thank you for right answer!!!
Sorry I put the question in wrong group!
Still, if 45Ëš is 30Ëš or something else. (Excuse my english) How can I do that?

Stefi skrev:

 

[Stefi]

http://www.easycalculation.com/area/pyramid.php
stefi


„Michel Norway†ezt írta:

 

[Dana DeLouis]

Still, if 45Ëš is 30Ëš or something else...how can I do that?

I believe this is the equation. x is the side, and d is the angle in
Degrees.

=x^2*(1+SQRT(1+TAN(RADIANS(d))^2))

If x=10, and d=45, then I get the same answer 241,4213562

HTH
Dana DeLouis