Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
November 24th, 2003, 11:15 AM
I'm making a small macro function in Excel and need to calculate an angle. For this I'm gonna use the Atan function, but I can't find it. Wery weird, cos all the oter functions are there on either the Math libary or the WorksheetFunction libary. The Atan2 function will not do in my case.
Anyone who knows where the function is hidden?
Have tried searching the forum, but found no answers on my problem.
Last edited by cirus; November 24th, 2003 at 11:21 AM.
November 24th, 2003, 12:10 PM
Worked around the problem by calculating the hypotenuse and then used the ACos function. If anyone finds the Atan function, I will appreciate if you post it here
November 25th, 2003, 12:38 AM
I have Excel 97 and there is an Atan function in the usual place.
November 25th, 2003, 02:09 AM
Thank you for your reply. I'm using office xp, and Atan is alvailable in the normal excel functions. It is just in the VBA editor that I can't find it.
December 5th, 2003, 11:11 PM
The required number argument is a Double or any valid numeric expression.
The Atn function takes the ratio of two sides of a right triangle (number) and returns the corresponding angle in radians. The ratio is the length of the side opposite the angle divided by the length of the side adjacent to the angle.
The range of the result is -pi/2 to pi/2 radians.
To convert degrees to radians, multiply degrees by pi/180. To convert radians to degrees, multiply radians by 180/pi.
It is called Atn and not Atan. That was the reason. I have pasted from bol.
By Teakster in forum ASP Development
Last Post: January 29th, 2004, 09:55 AM
By vb123 in forum Visual Basic Programming
Last Post: November 13th, 2003, 05:56 AM
By aluminum in forum ASP Development
Last Post: November 10th, 2003, 03:34 PM
By DaronTan in forum ASP Development
Last Post: August 25th, 2003, 07:46 AM
By johnphilip in forum ASP Development
Last Post: August 4th, 2003, 03:43 PM