Thread: Atan function

    #1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2003
    Location
    Trondheim, Norway
    Posts
    3
    Rep Power
    0

    Atan function


    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 12:21 PM.
  2. #2
  3. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2003
    Location
    Trondheim, Norway
    Posts
    3
    Rep Power
    0
    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
  4. #3
  5. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Oct 2003
    Location
    Queensland, Australia
    Posts
    256
    Rep Power
    12
    I have Excel 97 and there is an Atan function in the usual place.
  6. #4
  7. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2003
    Location
    Trondheim, Norway
    Posts
    3
    Rep Power
    0
    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.
  8. #5
  9. No Profile Picture
    Registered User

    Join Date
    Dec 2003
    Location
    Honolulu, Hawaii
    Posts
    5
    Rep Power
    0
    Atn(number)

    The required number argument is a Double or any valid numeric expression.

    Remarks

    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.

Similar Threads

  1. Hyperlink Problem!
    By Teakster in forum ASP Development
    Replies: 7
    Last Post: January 29th, 2004, 10:55 AM
  2. function writing problem
    By vb123 in forum Visual Basic Programming
    Replies: 13
    Last Post: November 13th, 2003, 06:56 AM
  3. passing an array to a function via a form
    By aluminum in forum ASP Development
    Replies: 0
    Last Post: November 10th, 2003, 04:34 PM
  4. Call ASP function in VBScript function
    By DaronTan in forum ASP Development
    Replies: 0
    Last Post: August 25th, 2003, 08:46 AM
  5. Replies: 1
    Last Post: August 4th, 2003, 04:43 PM

IMN logo majestic logo threadwatch logo seochat tools logo