how to use trigonometric functions in Excel?
 

how to use trigonometric functions in Excel?
 

Syntax

SIN(number)

Number is the angle in radians for which you want the sine.

Remark

If your argument is in degrees, multiply it by PI()/180 or use the RADIANS
function to convert it to radians.

--
Carlos



"JohnP" wrote in message
...

how to use trigonometric functions in Excel?
 

In Excel HELP, search for trigonometry

--
Kind regards,

Niek Otten

"JohnP" wrote in message ...

how to use trigonometric functions in Excel?
 

=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 ...

how to use trigonometric functions in Excel?
 

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 ...