Compilation of syntax and functions in the mathematical and trigonometric function group

Compilation of syntax and functions in the mathematical and trigonometric function group.

To learn more about the functions in this function group, follow the article below, which compiles the functions in the mathematical and trigonometric function group in Excel.

MATHEMATICAL FUNCTIONS.

ABS(number): This function returns the absolute value of a number, which is the number without its sign (always positive).

CEILING(number, significance): This function returns a number rounded up, away from zero, to the nearest multiple of significance.

COMBIN(number, number_chosen): This function returns the number of combinations for a given number of items.

EVEN(number): This function returns the nearest even integer by rounding.

EXP(number): This function returns the exponential value of the base e raised to a specified power. The constant e is equal to 2.71828182845904.

FACT(number): This function returns the factorial of a number. The factorial of a number is the product of all integers from 1 to the given number.

FACTDOUBLE(number): This function returns the double factorial of a number.

FLOOR(number, significance): This function returns a number rounded down, towards zero, to the nearest multiple of significance.

GCD(number1, number2,...): This function returns the greatest common divisor of two or more integers.

INT(number): This function returns the integer part of a number, rounding down to the nearest integer.

LCM(number1,number2,…): This function returns the least common multiple of integers.

LN(number): This function returns the natural logarithm of a number, based on the constant e (=2.71828182845904).

LOG(number, [basel]): This function returns the logarithm of a number to a specified base.

LOG10(number): This function returns the base-10 logarithm of a number.

MDETERM(array): This function returns the determinant of a matrix represented by an array.

MINVERSE(array): This function returns the inverse matrix of the matrix stored in an array.

MMULT(array1, array2): This function returns the matrix product of two arrays, resulting in an array with the number of rows equal to array 1 and the number of columns equal to array 2.

MOD(number,divisor): This function returns the remainder after dividing a number by a divisor (obtaining the remainder of a division operation).

MROUND(number,multiple): This function returns a number rounded to the nearest multiple of another number.

MULTINOMIAL(number1,number2,…): This function returns the ratio of the sum factorial to the product of factorials of the numbers.

ODD(number): This function rounds a number to the nearest odd integer.

PI(): This function returns the value of Pi (=3.14159265358979).

POWER(number,power): This function calculates the power of a number, you can also use the ^ operator instead of this function.

PRODUCT(number1,number2,…): This function multiplies all the given arguments together and returns their product.

QUOTIENT(numberator,denominator): This function returns the integer part of a division, use this function if you want to remove the remainder of a division.

RAND(): This function returns a random real number greater than or equal to 0 and less than 1. To get a random number greater than or equal to 0 and less than n, you use the syntax RAND()*n.

RANDBETWEEN(bottom,top): This function returns a random integer within a specified range.

ROMAN(number,form): This function converts Arabic numerals to Roman numerals, text form.

ROUND(number,num_digits): This function rounds a number to a specified number of digits.

ROUNDDOWN(number,num_digits): This function rounds down, a number is rounded down to the specified number.

ROUNDUP(number,num_digits): This function rounds up, a number is rounded up to the specified number.

SERIESSUM(x, n, m, coefficients): This function returns the sum of a series of numbers.

SIGN(number): This function returns the sign (algebraic) of a number. Returns 1 if the number is positive, 0 if it is zero, and -1 if it is negative.

SQRT(number): This function returns the square root of a positive number.

SQRTPI(number): This function returns the square root of a number multiplied by Pi (=3.14159265358979).

SUBTOTAL(function_num, ref1, ref2,…): This function calculates for a subset of a list or data table depending on the operation you select in the first argument. (sum, average…)

SUM(number1,number2,…): This function calculates the sum of its arguments.

SUMIF(range, criteria, sum_range): This function calculates the sum of cells in a range that meet the given condition.

SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2): This function calculates the sum of cells in a range that meet multiple criteria.

SUMPRODUCT(array1,array2,…): This function multiplies corresponding elements in arrays and returns the sum of these products.

SUMSQ(number1,number2,…): This function returns the sum of squares of its arguments.

SUMX2MY2(array_x, array_y): This function returns the sum of the difference of squares of corresponding elements in two data arrays.

SUMX2PY2(array_x, array_y): This function returns the sum of the sum of squares of corresponding elements in two data arrays.

SUMXMY2(array_x, array_y): This function returns the sum of the squares of the differences of corresponding elements in two data arrays.

TRUNC(number, num_digits): This function returns the integer part of a number by removing the digits after the decimal point (no rounding).

TRIGONOMETRIC FUNCTIONS

ACOS(number): This function returns the arccosine or inverse cosine of a number. The angle returned is calculated in radians from 0 to Pi.

ACOSH(number): This function returns a radian value that is the inverse hyperbolic cosine of a number greater than or equal to 1.

ASIN(number): This function returns the arcsine or inverse sine of a number. The angle returned is calculated in radians within the range from -Pi/2 to Pi/2.

ASINH(number): This function returns the radian value that is the inverse hyperbolic sine of a number.

ATAN(number): This function returns the arctangent or inverse tangent of a number. The returned value is calculated in radians within the range from -Pi/2 to Pi/2.

ATAN2(x_num, y_num): This function returns the arctangent or inverse tangent of the specified x and y coordinates. The returned value is calculated in radians and lies within the range from -Pi to Pi.

ATANH(number): This function returns the radian value that is the inverse hyperbolic tangent of a number within the range from -1 to 1.

COS(number): This function returns the cosine of a number. The returned value is calculated in radians.

COSH(number): This function returns the hyperbolic cosine of a number. The returned value is calculated in radians.

DEGREES(angle): This function converts an angle measurement from radians to degrees.

RADIANS(angle): This function converts an angle measurement from degrees to radians.

SIN(number): This function returns the sine of a number. The returned value is calculated in radians.

SINH(number): This function returns the hyperbolic sine of a number. The returned value is calculated in radians.

TAN(number): This function returns the tangent of a number. The returned value is calculated in radians.

TANH(number): This function returns the hyperbolic tangent of a number. The returned value is calculated in radians.

The article has compiled functions in the mathematical and trigonometric function group. You can have a more comprehensive overview of the functions in this group. When encountering specific requests, you will easily choose the appropriate function to use. Wishing you success!