Trigonometry with excel

[Serge]

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.
I did go through the help files,
Can someone help? It's probably simple but my thick head just can see it.
Thanks in advance
Serge

 

[davesexcel]

Give this a go:
=DEGREES(ATAN2(D20,C20))

 

[Serge]

Hello Dave,
Thank you very much. It works great now. First I discovered I missed the 'S'
in DEGREES, then I had a '/' instead of comma.
Would you have any more example to send to me? If not, that's ok. I'm very
greatfull for the help you have given me.
Serge

 

[paul]

degrees(atan(a1/b1) is perhaps more like the way we would do it on a
calculator.
--
paul
(e-mail address removed)
remove nospam for email addy!

Hello Dave,
Thank you very much. It works great now. First I discovered I missed the 'S'
in DEGREES, then I had a '/' instead of comma.
Would you have any more example to send to me? If not, that's ok. I'm very
greatfull for the help you have given me.
Serge

 

[Serge]

Thank you for your input. I like it also.
Serge

degrees(atan(a1/b1) is perhaps more like the way we would do it on a
calculator.

 

[davesexcel]

Check out this site

http://phoenix.phys.clemson.edu/tutorials/excel/trig.htm

 

[Serge]

Thankyou Dave,

That's great. I will take some lessons.
Serge