反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Overview of mathematics and trigonometric functions

  • Recent Updates: April 15, 2022

    • 1. Overview

    1.1 Version

    FineBIJARFunction Changes
      5.1--
    5.1.72020-11-05

    Function interpretation optimization

    clarify function parameter legality

    5.1.112021-04-02Real-time data formula verification enhancement
    5.1.12-Sampling data formula calibration enhancement

    1.2 Use location


    		Use locationUsing field types
    Self-service DatasetAdd new column、FilterNumeric fields (some functions allow adding some specified parameter values)
    DashboardAdd calculated fields

    2. Function list

    FunctionDescription
    RANDReturns a uniformly distributed random number. Each time the worksheet is calculated, the function returns a new random value.
    SQRTReturns the square root of an arithmetic number that is not negative. You can find any non-negative number that is the square root of an arithmetic number.
    LOG10Returns the logarithm with a base of 10.
    FLOORRound the parameter number to the end in the direction of decreasing absolute value.
    LOGReturns the logarithm of the value by any base number specified.
    MAXReturns the maximum value in the parameter list
    MINReturns the minimum value in the parameter list
    TRUNCTruncates a number by a certain number of digits and returns an integer or decimal.
    FACTReturns the factorial of a number. The factorial of a number is equal to 1*2*3*... *number
    RANDBETWEENReturns a random integer between value1 and value2
    LNReturns the natural logarithm of a number. The natural logarithm is underlain by the constant term e(2.71828182845904).
    SIGNReturns the sign of the number. Returns 1 when the number is positive, 0 when it is zero, and -1 when it is negative
    CEILINGRounds the parameter number to the nearest integer along the direction of increasing absolute value.
    MODReturns the remainder of the division of two numbers. The positive and negative signs of the result are the same as the divisor.

    PROMOTION

    		Returns the percentage of value2 lifted over value1
    EXPReturns the nth power of e. The constant e is the base of the natural logarithm and is equal to 2.171828182845904.
    ACOSReturns the inverse cosine of the specified value. The inverse cosine value is an angle, and the return angle is expressed in radians.
    ASINReturns the inverse sine of the specified value. The inverse sine value is an angle, and the return angle is expressed in radians.
    ATANCalculates the arctangent of the specified value. The specified value is the tangent of the returned angle, and the returned angle is expressed in radians.
    ATAN2Returns the arctangent of the x and y coordinates. Returns the angle formed by the x-axis and a line through (x_num,y_num) with the coordinate origin (0,0).
    COSReturns the cosine of an angle.
    DEGREESConverts radians into degrees.
    PIA mathematical constant

    POWER

    		Returns the multiplication power of the specified number

    RADIANS

    		Convert angles to radians
    SINCalculate the sine of a given angle
    TANReturns the tangent of the specified angle


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭