#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default degree or angle

I'm currently entering info on a graphic,and would like some help to get the
angle if a x and y number has been done.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 620
Default degree or angle

=DEGREES(ATAN2(X1,Y1))
--
David Biddulph

"ekkeindoha" wrote in message
...
I'm currently entering info on a graphic,and would like some help to get
the
angle if a x and y number has been done.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default degree or angle

THE ACTUAL THING I WOULD LIKE TO DO ARE AS FOLLOWS
I GOT A GRAPHIC -COLLUMS ARE 80000 TO 180000 AND LINES ANRE 460 TO 560.
WHAT I WOULD LIKE TO DO ARE AS FOLLOW.
LETS SAY X = 500 AND Y ARE 160000 IT SHOULD GIVE ME 90º AS 500 ARE 90º.
IF I CHANGE IT TO X 490 AND Y 160000 IT SHOULD GIVE ME ANOTHER ANGLE.

"David Biddulph" wrote:

=DEGREES(ATAN2(X1,Y1))
--
David Biddulph

"ekkeindoha" wrote in message
...
I'm currently entering info on a graphic,and would like some help to get
the
angle if a x and y number has been done.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default degree or angle

Please explain why when x=500 and y=16000, the angle is 90°
By the way - please turn off the CAPS key - a message in all block letters
is called shouting and considered poor manners (and is hard to read).
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ekkeindoha" wrote in message
...
THE ACTUAL THING I WOULD LIKE TO DO ARE AS FOLLOWS
I GOT A GRAPHIC -COLLUMS ARE 80000 TO 180000 AND LINES ANRE 460 TO 560.
WHAT I WOULD LIKE TO DO ARE AS FOLLOW.
LETS SAY X = 500 AND Y ARE 160000 IT SHOULD GIVE ME 90º AS 500 ARE 90º.
IF I CHANGE IT TO X 490 AND Y 160000 IT SHOULD GIVE ME ANOTHER ANGLE.

"David Biddulph" wrote:

=DEGREES(ATAN2(X1,Y1))
--
David Biddulph

"ekkeindoha" wrote in message
...
I'm currently entering info on a graphic,and would like some help to
get
the
angle if a x and y number has been done.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Imputting an angle degree. Degree, minute, second Graham Excel Discussion (Misc queries) 6 October 19th 06 03:07 PM
Imputting an angle degree. Degree, minute, second Graham Excel Worksheet Functions 1 October 13th 06 07:58 PM
Excel should be able to default to a degree mode William Lipsky Excel Discussion (Misc queries) 0 January 15th 06 05:11 PM
How to angle columns? Please Help! Elara Excel Discussion (Misc queries) 3 October 18th 05 03:31 PM
Convert decimal degree (lattitude/longitude) into Degree, Tim Ashcom Excel Discussion (Misc queries) 5 August 17th 05 04:53 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"