how to use trigonometric functions in Excel?

C

Carlos Antenna

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

paul

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

Serge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Degrees in trigonometric functions 1
How do you calculate cotangent in Excel 2003? 1
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal 2
Cos help remark should say "RADIANS" rather than "COS". 0
Trigonometric functions 3
Changing Radians to Degrees 5
Can you do inverse trigenometry on excel - i.e Tan-1 1
Trigonometric functions in Degrees 5

Top