Hello Paul,
If I wanted my answer in degrees for the following: opp side 8.3ft divided
by adjacent side 5.8ft should give me 55.05 degrees. I have no problem with
my little calculator but I'm having a difficult time trying to do this in
excel.
Can you help?
Thanks in advance
Serge

"paul" wrote:

=DEGREES(ATAN(((TAN((RADIANS(H2))))/1.414213562)))

this formula for example calculates the pitch of the valley or hip rafter
when you type the common rafter roof pitch in cell H2 in degrees(assumes the
roof planes are at right angles to each other.A roof pitch of 25 degrees will
have a hip or valley rafter angle of 18.24890239 degrees

--
paul
remove nospam for email addy!



"Niek Otten" wrote:

In Excel HELP, search for trigonometry

--
Kind regards,

Niek Otten

"JohnP" wrote in message ...