software

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
Give this a go:
=DEGREES(ATAN2(D20,C20))--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=536230Hello 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

quot;davesexcelquot; wrote:

gt;
gt; Give this a go:
gt; =DEGREES(ATAN2(D20,C20))
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=536230
gt;
gt;

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

remove nospam for email addy!
quot;Sergequot; wrote:

gt; Hello Dave,
gt; Thank you very much. It works great now. First I discovered I missed the 'S'
gt; in DEGREES, then I had a '/' instead of comma.
gt; Would you have any more example to send to me? If not, that's ok. I'm very
gt; greatfull for the help you have given me.
gt; Serge
gt;
gt; quot;davesexcelquot; wrote:
gt;
gt; gt;
gt; gt; Give this a go:
gt; gt; =DEGREES(ATAN2(D20,C20))
gt; gt;
gt; gt;
gt; gt; --
gt; gt; davesexcel
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=536230
gt; gt;
gt; gt;

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

quot;paulquot; wrote:

gt; degrees(atan(a1/b1) is perhaps more like the way we would do it on a
gt; calculator.
gt; --
gt; paul
gt;
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Sergequot; wrote:
gt;
gt; gt; Hello Dave,
gt; gt; Thank you very much. It works great now. First I discovered I missed the 'S'
gt; gt; in DEGREES, then I had a '/' instead of comma.
gt; gt; Would you have any more example to send to me? If not, that's ok. I'm very
gt; gt; greatfull for the help you have given me.
gt; gt; Serge
gt; gt;
gt; gt; quot;davesexcelquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Give this a go:
gt; gt; gt; =DEGREES(ATAN2(D20,C20))
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; davesexcel
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=536230
gt; gt; gt;
gt; gt; gt;


Check out this site

phoenix.phys.clemson.edu/tuto...xcel/trig.html--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=536230Thankyou Dave,

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

quot;davesexcelquot; wrote:

gt;
gt; Check out this site
gt;
gt; phoenix.phys.clemson.edu/tuto...xcel/trig.html
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=536230
gt;
gt;