Thread: angle from atan
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default angle from atan

Have a look in Help at the ATAN2 function
Called with =ATAN2(rise, run)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Randall_Fos" wrote in message
...
The atan returns the angle (in radians) of a number, which in my case is
in the rise over run format.
Where either rise, run or both may be negative; the combinations of signs
place the true location of the
angle in +/+, +/- , -/- and -/+ quadrants.

Lacking a proper atan function that preserves the quadrant information;
would one construct if statements
or is there some other (better) way to hande in spreadsheet cell formulas.

TIA
canopy