ATAN2 - Returning the Arctangent of X and Y Coordinates

  • Last update：July 14, 2023

    • Overview

    Grammar

    ATAN2(x_num, y_num)

    Returns the arctangent of X and Y coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and the point  (x_num, y_num).

    Parameter 1

    x_num

    The x-coordinate of the point.

    Parameter 2

    y_num

    The y-coordinate of the point.

    Notes

    • The function supports two numerical parameters.

    • A positive result represents a counterclockwise angle from the x-axis; a negative result represents a clockwise angle. ATAN2(a,b)=ATAN(b/a), except when a equals 0. If both x_num and y_num are 0, ATAN2 returns the *DIV/0! error value. To express the returned angle in degrees, multiply the result by 180/PI(). The returned value is expressed in radians between -pi and pi, excluding -pi.

    Example

    FormulaResultNotes
    ATAN2(-2,2)2.3561944901923453*pi/4 radians
    ATAN2(2,2)0.785398163pi/4 radian
    ATAN2(-2,2)*180/PI()135135 degrees


    附件列表


    主题： System Management
    Previous：CEILING - Rounding Up
    Next：ATAN - Calculating the Arctangent of a Number
    • Helpful
    • Not helpful
    • Only read
    中文（简体） 中文（繁體） 日本語
    English

    滑鼠選中內容，快速回饋問題

    滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    How to Get Quotes：
    FineReport FineBI
    Demonstration Booking：
    FineReport FineBI
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy