angle from atan
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 |
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 |
angle from atan
Thanks Bernard,
or more properly called =atan2(run, rise) "Bernard Liengme" wrote in message ... 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 |
All times are GMT +1. The time now is 11:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com