Java Reporting Tools Finereport usage Summary of common functions (math and trigonometry)

 

Abs

ABS (number): Returns the absolute value of the specified digit. An absolute value is a numeric value that has no sign.

Number: Any real number that requires an absolute value.

Example:

ABS (-1.5) equals 1.5.

ABS (0) equals 0.

ABS (2.5) equals 2.5.

ACOS

ACOS (number): Returns the inverse cosine of the specified numeric value. The inverse cosine value is an angle, and the return angle is expressed in radians.

Number: You need to return the cosine of the angle.

Note:

The parameters of the function must be between 1 and 1, including-1 and 1.

The returned angle value is between 0 and pi.

If you want the returned angle to be expressed in degrees, use 180/PI () to multiply the return value.

Example:

ACOS (1) equals 0 (radians).

ACOS (0.5) equals 1.047197551 (Pi/3 radians).

Acosacosh (0.5) *180/pi () equals 60 (degrees).

Acosh

Acosh (number): Returns the inverse hyperbolic cosine of the given value.

Number: The hyperbolic cosine of the return value.

Note:

The value of the parameter number must be greater than or equal to 1.

Acosh (COSH (number)) =number.

Example:

Acosh (1) equals 0.

Acosh (8) equals 2.768659383.

Acosh (5.5) equals 2.389526435

ASIN

ASIN (number): Returns the inverse chord value of the specified value. Anyway, the chord value is an angle, and the return angle is expressed in radians.

Number: The sine of the angle needs to be returned.

Note:

The specified value must be between 1 and 1 (with 1 and-1).

Returns the angle between-PI/2 to PI/2 (including-PI/2 and PI/2).

When you return a value in angular form, you can multiply the return value by 180/pi ().

Example:

ASIN (0.5) equals 0.523598776 (Pi/6 radians).

ASIN (1) equals 1.570796327 (Pi/2 radians).

ASIN (0.5) *180/pi () equals 30 (degrees).

Asinh

Asinh (number): Returns the inverse hyperbolic sine of the specified numeric value. The hyperbolic sine of the inverse hyperbolic sine value is equal to the specified value. That is: Asinh (SINH (number)) =number.

Number: any real number.

Example:

Asinh (-5) equals-2.312438341.

Asinh (8) equals 2.776472281.

Asinh (16) equals 3.466711038.

ATAN

ATAN (number): Calculates the inverse tangent of the specified numeric value. Specifies that the value is the tangent of the return angle, and the return angle is expressed in radians.

Number: Returns the tangent of the angle.

Note:

Returns the angle between-PI/2 to PI/2.

If the return angle equals-PI/2 or Pi/2,atan returns an error message *num!.

Returns the value multiplied by 180/pi () when the value is returned in angular form.

Example:

ATAN (-1) equals -0.785398163 (-pi/4 radians).

ATAN (0) equals 0 (radians).

ATAN (2) *180/pi () equals 63.43494882 (degrees).

ATAN2

ATAN2 (X_num,y_num): Returns the inverse tangent of the x and Y coordinates. Returns the angle of a line formed by the x-axis and over (X_num,y_num) and the coordinate origin (0,0). The angle is displayed in radians.

X_num: Specifies the x-coordinate of the point.

Y_num: Specifies the y-coordinate of the point.

Note:

A positive value represents an angle counterclockwise from the x-axis, and a negative value indicates the angle that is obtained clockwise from the x-axis.

ATAN2 (A, B) =atan (b/a), except for a 0 o'clock.

When both X_num and Y_num are 0 o'clock, ATAN2 returns an error message *div/0!.

When the return value is displayed by the angle system, multiply the return value by 180/pi ().

The return value is expressed in radians (the return value is greater than-pi and less than or equal to pi).

Example:

ATAN2 ( -2,2) equals 2.356194490 (3*pi/4 in radians).

ATAN2 (2,2) equals 0.785398163 (Pi/4 in radians).

ATAN2 ( -2,2) *180/pi () equals 135 (angle system).

AVERAGE

AVERAGE (Number1,number2,...): Returns the average of the specified data.

Number1,number2: The parameter used to calculate the mean.

Note:

The argument must be a number, or a name, array, or reference that contains a number.

If the array or reference parameters contain text, logical values, or blank cells, the values are ignored, but the 0 value in the cell participates in the calculation.

Example:

If A1:a6 is named "Ages", which equals 10,23,14,24,33 and 25 respectively, then:

AVERAGE (A1:A6) equals 21.5.

AVERAGE (Ages) equals 21.5.

If there is another age of 18, the average of all ages is: AVERAGE (a1:a6,18) equals 21.

Bitnot

Bitnot (int): binary negation of a decimal integer.

int: The decimal number to be converted.

Example:

Bitnot (3) equals-4.

Bitnot (12) equals-13.

Bitoperation

The Bitoperatioin (INT,INT,OP) bitwise operation returns the result of a bitwise operation of two integers based on op.

int: decimal integer.

OP: bitwise operator, support "&" (with), "|" (or), "^" (XOR), "<<" (shift left), ">>" (move right).

Example:

Bitoperation (4,2, "&") represents 4 and 2 for the "and" operation, and the result is equal to 0.

Bitoperation (4,2, "|") Represents 4 and 2 for the "or" operation, and the result equals 6.

Bitoperation (4,2, "^") represents 4 and 2 for an "XOR" operation, and the result is equal to 6.

Bitoperation (4,2, "<<") represents 4 bitwise left 2 bits, and the result equals 16.

Bitoperation (4,2, ">>") indicates that 4 bitwise right shifts 2 bits and the result equals 1.

Bitoperation (4,1, "^~") indicates that 4 and 2 perform the "Same or" operation with a result of-7.

CEILING

CEILING (number,significance): Rounds the parameter number in the direction of the absolute value, rounded to the minimum multiple of the cardinality.

Number: Refers to the value to be rounded.

Significance: Cardinality.

Note:

When number,significance any of the non-numeric types, ceiling returns an error message *value?.

When the number,significance symbol is not the same, ceiling returns an error message *value?.

Regardless of the number symbol, rounding is in the direction away from zero. If number is already a multiple of significance, no rounding is done.

Example:

CEILING (2.5,-1) equals *value?

CEILING ( -2.5,-1) equals-3.

CEILING (0.5,2) equals 2.

COMBIN

COMBIN (Number,number_chosen): Returns the number of combinations of several specified objects. The function is the same as the mathematical expression for the CNK function.

The "n" in number or mathematical expression refers to the sum of the objects.

The "K" in a Number_chosen or mathematical expression refers to the number of a combination in the total number of objects.

Note:

Number and Number_chosen must be non-negative integers and number>=number_chosen. Otherwise, return *value?.

Object composition is a subset of the overall object. Unlike permutations, a combination does not involve ordering inside an object.

Assuming number=n,number_chosen= K, then: COMBIN (n,k) =cnk=n!/(k! ( N-K)!).

Example:

COMBIN (5,2) equals 10.

COS

COS (number): Returns the cosine of an angle.

Number: The angle in radians that you want to find the cosine.

Note:

To convert an angle to a radian value, multiply the angle by the PI ()/180.

COS (N*2*pi () +number) =cos (number) (where n is an integer, number from-pi to PI).

Example:

COS (0.5) equals 0.877582562.

COS (30*PI ()/180) equals 0.866025404.

COSH

COSH (number): Returns the hyperbolic cosine of a numeric value.

Number: A real value whose hyperbolic cosine is to be asked.

Note:

The hyperbolic cosine value is calculated as:, where E is the base of the natural logarithm, e=2.71828182845904.

Example:

COSH (3) equals 10.06766200.

COSH (5) equals 74.20994852.

COSH (6) equals 201.7156361.

COUNT

Count (value1,value2,...): Calculates the number of numeric items contained in an array or data region.

Value1,value2,...: Parameters that can contain any type of data, but this function only calculates data of the numeric type.

Note:

Numbers, dates, or numeric parameters that are represented by text are counted, but error values or text value parameters that cannot be converted to numbers are ignored.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

DEGREES

DEGREES (angle): converts radians to degrees.

Angle: The angle of curvature to be converted.

Example:

DEGREES (PI ()/2) equals 90.

DEGREES (3.1415926) equals 179.9999969.

Even

Even (number): Returns the nearest even number after rounding in the absolute value increment direction. Use this function to work with objects that appear paired.

Number: The value to be rounded.

Note:

Regardless of the sign, the values are rounded in a direction away from 0. If number happens to be an even number, no rounding is required.

Example:

Even (1.5) equals 2

Even (3) equals 4

Even (2) equals 2

Even (-1) equals-2

BX7

EXP (number): Returns the n-th power of E. The constant e is the base of the natural logarithm, equal to 2.71828182845904.

Number: As an exponent of the constant e, for any real number.

Note:

If you want to return other constants as a power to the base, you can use the exponential operator (^). For example: In 4^2, 4 is the base, and 2 is the exponent.

The EXP function and the LN function are mutually inverse functions.

Example:

EXP (0) equals 1.

EXP (3) equals 20.085536 to 2

EXP (LN (2)) equals 2.

FACT

FACT: The factorial of the number returned, and the factorial of a number equals 0!*1*2*3*...*number (where 0!=1).

Number: The non-negative number whose factorial is to be computed. If the number entered is not an integer, the truncation is rounded.

Example:

FACT (1) equals 1

Fact (1.9) equals fact (1) equals 1

FACT (0) equals 1

FACT (5) equals 0!*1*2*3*4*5 equals 120

Floor

Floor (number,significance): Rounds the parameter number in a direction that decreases in absolute value so that it equals the nearest multiple of the cardinality.

Number: The value to be rounded.

Significance: Cardinality.

Note:

When number and significance are either non-numeric arguments, the function floor returns an error message *value?.

When the symbol for number and significance is not the same, the function floor returns the error message *value?.

Regardless of the symbol of number, the absolute value of the rounding parameter is reduced. If number happens to be a specified multiple, no rounding is required.

Where significance can not take 0.

Example:

Floor (2.5,-1) equals *value?

Floor ( -2.5,-1) equals-2.

Floor (2.5,2) equals 2.

Floor (0.143,0.03) equals 0.12.

Int

INT (number): Returns the nearest integer value after rounding (the direction in which the value is reduced) under a digit.

Number: The real number that needs to be rounded to an integer.

Example:

INT (4.8) equals 4.

INT (-4.8) equals-5.

INT (4.3) equals 4.

INT (-4.3) equals-5.

The formula Int (A1) returns the integral part of a positive real number in cell A1.

Less

Less (value1,value2,..., value): Calculates the number of data items in an array or data region that are smaller than the last item of data.

Value1,value2,...: Parameters that can contain any type of data, but this function only calculates data of the numeric type.

Note:

Numbers, dates, or numeric parameters that are represented by text are counted, but error values or text value parameters that cannot be converted to numbers are ignored.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

Value generally takes a numeric parameter. Returns "0" if it is a non-numeric type.

Example:

Less (10,2, 20) = 2

Less (12,2, 10, 20) = 3

Suppose A1 is a, A2 is, A3 is (A1:A3, 200, 200, 400) = 4

Less (20) =0

LN

LN (number): Returns the natural logarithm of one count. The natural logarithm is the base of the constant term e (2.71828182845904).

Number: Is the positive real number that is used to calculate its natural logarithm.

Example:

LN (86) equals 4.45437

LN (2.7182818) equals 1

LN (EXP (3)) equals 3

LOG

Log (Number,base): Returns the logarithm of a numeric value by any specified base.

Number: The positive real number of the logarithm is required.

Bases: The Base of the logarithm. The default value is 10.

Example:

LOG (16,2) equals 4.

LOG (10) equals 1.

LOG (24,3) equals 2.892789261.

LOG10

LOG10 (number): Returns the base 10 logarithm.

Number: The positive real number used for common logarithm calculations.

Example:

LOG10 (86) equals 1.934498451

LOG10 (10) equals the integer portion of a positive real number in cell A1.

MAX

Max (Number1,number2,...): Returns the maximum value in the argument list.

Number1,number2,...: 1 to 30 parameters that need to find the maximum value.

Note:

Parameters can be numeric, blank cells, logical values, or text expressions of numbers.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

If there is no number in the parameter, max returns 0.

Example:

MAX (0.1,0,1.2) equals 1.2.

Maxlessvalue

Maxlessvalue (number,dictionary): Returns the largest number in the data dictionary dictionary, which is smaller than numbers.

Example:

Data dictionary: Customdictionary

Key value

11

22

33

44

Maxlessvalue (2.4, "customdictionary") equals 2.

MIN

Min (number1,number2,...): Returns the minimum value in the argument list.

Number1,number2,...: 1 to 30 parameters that need to find the minimum value.

Note:

If there is no number in the argument, the function min returns 0.

The parameter should be a number, a blank cell, a logical value, or a text string that represents a value. If the parameter is an error value, MIN returns an error message.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

Example:

If B1:b4 contains 3,6,9,12, then:

MIN (B1:B4) equals 3.

MIN (b1:b4,0) equals 0.

Minbigvalue

Minbigvalue (number,dictionary): Returns the smallest number in the dictionary that is larger.

Example:

Data dictionary: Customdictionary

Key value

11

22

33

44

Minbigvalue (2.4, "customdictionary") equals 3.

MOD

MOD (Number,divisor): Returns the remainder of dividing two numbers. The sign of the result is the same as the divisor.

Number: for dividend.

Divisor: the divisor.

Example:

MOD (3,2) equals 1

MOD ( -3,2) equals 1

MOD (3,-2) equals-1

MOD ( -3,-2) equals-1

More

More (value1,value2,..., value): Calculates the number of number items in an array or data region that are larger than the last item of data.

Value1,value2,...: Parameters that can contain any type of data, but this function only calculates data of the numeric type.

Note:

Numbers, dates, or numeric parameters that are represented by text are counted, but error values or text value parameters that cannot be converted to numbers are ignored.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

Value is generally taken as a numeric value, otherwise the returned result is zero.

Example:

More (100,200, 20) = 2

More (100,200, 200, 20) = 3

Assuming that A1 is a, A2 is ten, A3 is the more (A1:A3, 20omDictionary, a. 3

ODD

ODD: Returns the odd number after rounding the specified numeric value.

Number: is the numeric value to round to find odd.

Regardless of the sign, the values are rounded in a direction away from 0. If number happens to be odd, no rounding is required.

Example:

ODD (1.5) equals 3

ODD (3) equals 3

ODD (2) equals 3

ODD (-1) equals-1

Pi

PI: is a mathematical constant, and the function returns a value of exactly 15 bits to 3.141592653589793.

Example:

SIN (PI ()/2) equals 1.

The formula for calculating the area of a circle: S=pi () * (r^2), where S is the area of the circle and R is the radius of the circle.

POWER

Number,power: Returns the POWER of the specified number.

Number: base, can be any real number.

Power: Index. The number of the parameter is the power of the exponent.

Note:

You can use the symbol "^" instead of power, such as: Power (5,2) equals 5^2.

Example:

POWER (6,2) equals 36.

POWER (14,5) equals 537824.

POWER (4,2/3) equals 2.519842100.

POWER (3,-2.3) equals 0.079913677.

PRODUCT

Product (Number1,number2,...): Multiplies all the numbers given as arguments and returns the product value.

Number1,number2, ...: 1 to n number parameters that need to be multiplied. (Maximum number of parameters is 30)

Example:

PRODUCT (3,4) equals 12

PRODUCT (3,4,5) equals 60

PROMOTION

PROMOTION (value1,value2): Returns the proportion of value2 promoted on value1.

Example:

PROMOTION (12,14) equals 0.166666666, which increases by 16.6666666%.

PROMOTION ( -12,14) equals 2.166666666, which increases by 216.6666666%.

RADIANS

RADIANS (angle): Converts the angle to radians.

Angle: The angle that needs to be converted to radians.

Example:

RADIANS (90) equals 1.570796327 (Pi/2 radians).

RAND

RAND (): Returns a random number. Values are in the 1 area [0,1] each time the worksheet is calculated, the function returns a new random value.

Note:

To generate a random number between A and B, you can use the following formula: C=rand () * (b-a) +a.

If you want a randomly generated value to not change with the cell's recalculation, you can enter =rand () in the edit box and leave the edit state, and then press F9 to permanently change the formula to a random number.

Example:

If you need to generate a random number greater than or equal to 0, less than 60, use the formula: =rand () *60.

If you need to generate a random number greater than or equal to 0, less than 19, use the formula: =rand () *19.

If you need to generate a random number greater than or equal to 0, less than 50, use the formula: =rand () *50.

Randbetween

Randbetween (value1,value2): Returns a random integer between value1 and value2.

Example:

Randbetween (12.333,13.233) will only return 13.

Randbetween (11.2,13.3) may return 12 or 13.

RANK

Rank (Number,ref,order): Returns the rank of a number in an array. (If you sort the array, the rank of the number is the ordinal of it in the array.) )

Number of the rank to be evaluated. (Can be Boolean type, true=1,false=0)

Ref can be an array, a reference, or a series of numbers, and non-real values are ignored for processing (accept Boolean, true=1,false=0).

order Specifies the argument for rank, nonzero to ascending, 0 to descending

Note:

Rank returns the same rank on the number of repetitions, but the number of repetitions affects the rank of the subsequent number, for example, in a set of ascending integers, if 5 appears 2 times, and the rank is 3, then the rank of 6 is 5 (the rank with no number is 4).

In the previous example, if you want to get a 5 correction with a rank of 3.5, you can add a modifier on the basis of the return rank. This correction factor is suitable for both ascending and descending conditions.

The correction factor is [COUNT (ref) + 1–rank (number, ref, 0) –rank (number, ref, 1)]/2.

In the following example, RANK (a2,a1:a5,1) = 3. The correction factor is (5 + 1–2–3)/2 = 0.5 The corrected rank is 3 + 0.5 = 3.5. If number appears only once in ref, the correction factor equals 0, and the rank does not change.

Example:

A1:a5= 6, 4.5, 4.5, 2, 4

Rank (a1,a1:a5,1) is 6 and rank is 5.

RANK (3,1,2, "Go", 3,13.3) may return 12 or 13.

ROUND

ROUND (number,num_digits): Returns the number after which a number is rounded by a specified number of digits.

Number: Numbers that need to be rounded.

Num_digits: The specified number of digits, rounded by this number of digits.

If Num_digits is greater than 0, it is rounded to the specified number of decimal digits.

If Num_digits equals 0, it is rounded to the nearest integer.

If Num_digits is less than 0, rounding is done to the left of the decimal point.

Example:

ROUND (2.15,1) equals 2.2

ROUND (2.149,1) equals 2.1

ROUND ( -1.475,2) equals-1.48

ROUND (21.5,-1) equals 20

RoundDown

RoundDown (number,num_digits): The number is rounded down (in the direction of the absolute decrease) near the 0 value.

Number: Any real number that needs to be rounded down.

Num_digits: The number of digits after the rounded number.

Note:

The function RoundDown is similar to the function round function, except that the function RoundDown always rounds down the number.

Example:

RoundDown (3.2,0) equals 3

RoundDown (76.9,0) equals 76

RoundDown (3.14159,3) equals 3.141

RoundDown ( -3.14159,1) equals-3.1

RoundDown (31415.92654,-2) equals 31,400

ROUNDUP

ROUNDUP (number,num_digits): Away from the 0 value, rounding the number up (in the direction of the absolute value increase).

Number: Any real number that needs to be rounded up.

Num_digits: The number of digits after the rounded number.

Note:

The function roundup is similar to the function round function, except that the function roundup always rounds the number up.

Example:

ROUNDUP (3.2,0) equals 4

ROUNDUP (76.9,0) equals 77

ROUNDUP (3.14159,3) equals 3.142

ROUNDUP ( -3.14159,1) equals-3.2

ROUNDUP (31415.92654,-2) equals 31,500

Sign

Sign: Returns the symbol for the number. Returns 1 when the number is positive, returns 0 for zero, and returns-1 if it is negative.

Number: Is any real number.

Example:

Sign (10) equals 1

Sign (4-4) equals 0

Sign (-0.00001) equals-1

SIN

SIN (number): Calculates the sine of a given angle.

Number: The angle to be expressed in radians for the sine value.

Note:

If the unit of the parameter is a degree, multiply it by pi ()/180 to convert to radians.

Example:

SIN (10) equals-0.544021111.

SIN (45*PI ()/180) equals 0.707106781.

SINH

SINH: Returns the hyperbolic sine of a number.

Number: Is any real number.

Example:

SINH (1) equals 1.175201194

SINH (-1) equals-1.175201194

SQRT

SQRT (number): Returns the square root of a positive number.

Number: The sum of the square root requirements.

Note:

Number must be a positive number, otherwise the function returns the error message Nan.

Example:

SQRT (64) equals 8.

SQRT (-64) returns Nan.

SUM

SUM (Number1,number2,...): Specifies the sum of all numbers in a specified range of cells.

Number1,number2,...: 1 to 30 parameters or all numbers in a specified range of cells.

Note:

The function calculates the numeric values, logical values, and text expressions that are directly typed into the parameter.

If the argument is an array or reference, only the values in the array or cell reference are evaluated.

Example:

SUM (70,80) equals 150.

SUM ("80,true") equals 151, the logical value "TRUE" as a calculation, "FALSE" as 0, and the text "70" as the zero calculation.

SUM (A1:A5) sums the values in the lattice between A1 to A5.

SUM (a1:a5,50) sums the numeric value and the value 50 in the lattice between A1 to A5.

Sumsq

SUMSQ (Number1,number2,...): Returns the sum of the squares of all parameters.

Number1,number2, ...: For n parameters that require a sum of squares (the upper limit of N is 30), you can also use arrays or array references instead of comma-separated arguments.

Example:

SUMSQ (3,4) equals 25

TAN

TAN (number): Returns the tangent of the specified angle.

Number: The angle of the tangent value to be asked, expressed in radians. If the parameter is in degrees, it is converted to radians by multiplying pi ()/180.

Example:

TAN (0.8) equals 1.029638557.

TAN (45*PI ()/180) is equal to 1.

TANH

TANH (number): Returns the hyperbolic tangent of a value.

Number: Is any real number.

Example:

TANH (-2) equals-0.96403

TANH (0) equals 0

TANH (0.5) equals 0.462117

Tobinary

Tobinary (int): Converts a decimal integer to a string in binary notation.

int: Represents a decimal integer that needs to be converted.

Example:

Tobinary (10) equals "1010".

Tobinary (20) equals "10100".

Tohex

Tohex (int): Converts a decimal integer number to a hexadecimal-represented string.

int: Represents a decimal integer that needs to be converted.

Example:

Tohex (15) equals "F".

Tohex (20) equals "14".

Tooctal

Tooctal (int): Converts a decimal integer to a string in octal notation.

int: Represents a decimal integer that needs to be converted.

Example:

Tooctal (10) equals "12".

Tooctal (20) equals "24".

TRUNC

TRUNC (number,num_digits): Rounding. The fractional part of the number is truncated to return an integer.

Number: You need to truncate the rounding numbers.

Num_digits: The number used to specify the rounding precision.

Example:

TRUNC (8.9) equals 8

TRUNC (-8.9) equals-8

TRUNC (PI ()) equals 3.

Uuid

UUID (): Returns the random number of machines.

Note:

The default value here is 36.

Example:

The UUID () returns the 36-bit random number of machines.

The UUID (32) returns the 32-bit random number of machines.

Java Reporting Tools Finereport usage Summary of common functions (math and trigonometry)