Math Trigonometry in JQuery Calculate widget
9 Oct 201916 minutes to read
ABS
Returns the absolute Value of a number. The absolute value of a nonnegative number is the number itself. The absolute value of a negative number is 1 times the number.
Syntax:
ABS(number)
where:
 number is the real number for which you want the absolute value.
ACOT
The Acot
function retrieves the principal value of the inverse trigonometric cotangent of a number.
To obtain in degrees, use Degrees
function before Acot
function.
Syntax:
ACOT(number) or DEGREES ACOT(number)
where:
 number that is to be converted into acotangent.
Remarks:

#VALUE!
occurs when the number is a nonnumeric value. 
The returned angle when given in radians in the range of 0 (zero) to pi.
ACOTH
The Acoth
function retrieves the inverse hyperbolic cotangent of a number.
Syntax:
ACOTH(number)
where:
 number that is to be converted into cotangent.
Remarks:

#NUM!
occurs when number is lesser than one. 
#VALUE!
occurs when absolute value of number is lesser than one.
ARABIC
A Roman numeral is converted into an Arabic numeral.
Syntax:
ARABIC( romannumeral )
where:
 romannumeral is the text given by you to convert it into Arabic numeral.
Remarks:

#VALUE!
occurs when text is not a valid value. 
#VALUE!
occurs when text is not a valid Roman numeral. 
Value zero occurs when an empty string is given as an input.
ACOS
Returns the inverse cosine of a number. Inverse cosine is also referred to as arccosine. The arccosine is the angle whose cosine is the given number. The returned angle is given in radians in the range of 0 to pi.
Syntax:
ACOS(number)
where:
 number is the cosine of the angle that you want and must be between 1 and 1.
ACOSH
Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is the given number.
Syntax:
ACOSH(number)
where:
 number is any real number that is greater than or equal to 1.
ASIN
Returns the inverse sine of a number. Inverse sine is also referred to as arcsine. The arcsine is the angle whose sine is the given number. The returned angle is given in radians in the range from pi/2 to +pi/2.
Syntax
ASIN(number)
where:
 number is the sine of the angle that you want and must be between 1 and 1.
ASINH
The ASINH
function returns the inverse hyperbolic sine of a number.
Syntax:
ASINH(number)
where:
 number is any real number which is to be converted.
ATAN
Returns the inverse tangent of a number. Inverse tangent is also known as arctangent. The arctangent is the angle whose tangent is a number. The returned angle is given in radians in the range from pi/2 to +pi/2.
Syntax
ATAN(number)
where:
 number is the tangent of the angle that you want.
ATAN2
Returns the inverse tangent of the specified x and ycoordinates. The arctangent is the angle from the xaxis to a line containing the origin (0, 0) and the point (x_num, y_num). The angle is given in radians between pi and pi, excluding pi.
Syntax:
ATAN2(x_num,y_num)
where:

x_num is the X coordinate of the point.

y_num is the Y coordinate of the point.
Remarks:

A positive result represents counterclockwise angle from the xaxis; and negative result represents clockwise angle.

ATAN2(a,b)
equalsATAN(b/a)
, except that a can equal 0 in ATAN2.
ATANH
The ATANH
function returns the inverse hyperbolic tangent of a number.
Syntax:
ATANH(number)
where:
 number is any real number that must be greater than or equal to 1 and lesser than or equal to 1.
BASE
The BASE
function converts a number into a text representation with the given radix (base).
Syntax:
BASE(number, radix, [min_length])
where:

number is the real number which is to be converted. It must be greater than or equal to 0 and lesser than or equal to 2^53.

radix is the base radix which is to convert a number into base. The value of radix must be greater than or equal to 2 and lesser than or equal to 36.

min_length is the minimum length of the returned string. It is optional and must be greater than or equal to 0.
Remarks:

If number, radix, or min_length are outside the minimum or maximum constraints, BASE returns the
#NUM!
error value. 
If number is a nonnumeric value, BASE returns the
#VALUE!
error value. 
If any noninteger number entered as an argument, it is truncated to an integer.

The maximum value of min_length is 255.
COMBIN
Returns the number of combinations for a given number of items. Use COMBIN
to determine the total possible number of groups for a given number of items.
Syntax:
COMBIN(number, number_chosen)
where:

number is the number of items.

number_chosen is the number of items in each combination.
Remarks:

Numeric arguments are truncated to integers.

A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations where the internal order is significant.

The number of combinations is as follows, where number = n and number_chosen = k:
COT
The Cot
function returns the cotangent of an angle specified in radians.
Syntax:
COT(number)
where:
 numberangle radians to get the cotangent value.
Remarks:

#NUM!
occurs when the number is out of the range. 
#VALUE!
occurs when the number is a nonnumeric value.
COTH
The COTH
function returns the hyperbolic cotangent of a hyperbolic angle.
Syntax:
COTH(number)
Where:
 number  angle radians to get the hyperbolic cotangent value.
Remarks:

#NUM!
 occurs if the number is outside of its constraints. 
#VALUE!
 occurs if the number is a nonnumeric value.
CSC
The CSC
function returns the cosecant of an angle specified in radians.
Syntax:
CSC(number)
where:
 numberangle radians to get the cosecant value.
Remarks:

#NUM!
occurs when the number is outside its constraints. 
#VALUE!
occurs when the number is a nonnumeric value.
CSCH
The CSCH
function returns the hyperbolic cosecant of an angle specified in radians.
Syntax:
CSCH(number)
where:
 numberangle radians to get the hyperbolic cosecant value.
Remarks:

#NUM!
occurs when the number is outside its constraints. 
#VALUE!
occurs when the number is a nonnumeric value.
COS
Returns the cosine of the given angle.
Syntax:
COS(number)
where:
 number is the angle in radians for which you want the cosine.
COSH
Returns the hyperbolic cosine of a number.
Syntax:
COSH(number)
where:
 number is any real number for which you want to find the hyperbolic cosine.
COMBINA
For a given number of items, the Combina
function returns the number of combinations.
Syntax:
COMBINA(number1, number2)
where:

number1 is total number of items.

number2 is total number of items to be chosen.
Remarks:

#NUM!
occurs when either value is out of range. 
#VALUE!
occurs when either value is nonnumeric.
CEILING
The Ceiling
function returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.82, use the formula =CEILING(4.82,0.05) to round prices up to the nearest nickel.
Syntax:
CEILING(number, significance)
where:

number is the value you want to round off.

significance is the multiple to which you want to round.
Remarks:

Both values must be numeric.

Regardless of the sign of a number, a value is rounded up when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.
CEILING.Math
The Ceiling.Math
function returns the number rounded up to a multiple of another number.
Syntax:
CEILING(number, [significance], [mode])
where:

numbernumber that is rounded up to a multiple of significance.

significancemultiple to which the number is rounded.

mode is for negative numbers; it controls whether the number is rounded toward or away from zero.
DECIMAL
A text representation of a number in a given base to be converted into a decimal number.
Syntax:
DECIMAL(text, radix)
where:

text is a string.

radix is an integer.
Remarks:

#NUM!
or#VALUE!
occurs when text or radix is outside the constraints.
DEGREES
Converts radians into degrees.
Syntax:
DEGREES(angle)
where:
 angle is the angle in radians that you want to convert.
EVEN
Returns the number rounded up to the nearest even integer.
Syntax:
EVEN(number)
where:
 number is the value that is to be rounded.
Remarks:
 Regardless of the sign of the number a value is rounded up when adjusted away from zero. If the number is an even integer no rounding occurs.
EXP
Returns e raised to the power of the given number.
Syntax:
EXP(number)
where:
 number is the exponent applied to the base e.
FACT
Returns the factorial of a number. The factorial of a number is the product of all positive integers <= the given number.
Syntax:
FACT(number)
where:
 number is the nonnegative number for which you want the factorial of. If the number is not an integer, it is truncated.
FACTDOUBLE
FactDouble
function returns the double factorial of a given value. The given value is an integer value.
Syntax:
FACTDOUBLE (number)
where:
 numberThis value is required.
Remarks:

#NUM!
when the number is lesser than zero (0). 
#VALUE!
Occurs when any of the given argument is nonnumeric
INT
Rounds a number down to the nearest integer.
Syntax:
INT(number)
where:
 number is the real number that you want to round down to an integer.
LN
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.718281828459…).
Syntax:
LN(number)
where:
 number is the positive real number for which, you want the natural logarithm.
Remarks:
 LN is the inverse of the EXP function.
LOG
Returns the logarithm of a number to the base that you specify.
Syntax:
LOG(number, base)
where:

number is the positive real number for which, you want the logarithm.

base is the base of the logarithm. If base is omitted, it is assumed to be 10.
LOG10
Returns the base10 logarithm of a number.
Syntax:
LOG10(number)
where:
 number is the positive real number for which, you want the base10 logarithm.
MMULT
Returns the matrix product of two arrays.
Syntax:
MMULT(array1, array2)
where:
 array1, array 2 are required arrays that needs to be multiplied.
Remarks:

The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers.

array1 and array2 can be given as cell ranges, array constants, or references.

MMULT returns the #VALUE! error when:

Any cells are empty or contain text.

The number of columns in array1 is different from the number of rows in array2.

MOD
The MOD
function returns the reminder from the division. The result always has the same sign as the divisor.
Syntax:
MOD(number, divisor)
where:

number is an integer to be divided.

divisor is an integer by which to divide.
Remarks:

Returns
#DIV!
error when the divisor is zero. 
The
MOD
function will returns the whole number.
ODD
The ODD
function returns the number rounded up to the nearest odd integer.
Syntax:
ODD(number)
where:
 number is a value to be rounded.
Remarks:

If the number is nonnumeric, it returns the
#VALUE!
error. 
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.
POWER
The POWER
function returns the result of a number raised to power.
Syntax:
POWER(number, power)
where:

number is the base number. It can be any real number.

power is the exponent to which the base number is raised.
RADIANS
The RADIANS
function converts the degrees into radians.
Syntax:
RADIANS(angle)
where:
 angle is an angle in degree which is to be converted into radian.
RAND
The RAND
function returns an evenly distributed random real number that should be greater than or equal to 0 and lesser than or equal to 1.
Syntax:
RAND()
Remarks:
 To generate a random real number between a and b, use the following syntax
RAND()*(ba)+a
RANDBETWEEN
The RANDBETWEEN
function returns a new random number between the given numbers every time the worksheet is calculated.
Syntax:
RANDBETWEEN(bottom_value , top_value)
where

bottom_value is the smallest possible number that this function will return.

top_value is the largest possible number that this function will return.
Remarks

Returns
#NUM!
when bottom_value is greater than top_value. 
Returns
#VALUE!
If anyone of the arguments is not a numeric value.
SECH
The SECH
function returns the hyperbolic secant of an angle.
Syntax:
SECH(number)
where:
 number is the angle in radians to calculate the hyperbolic secant.
Remarks:

The absolute value of number must be less than 2^27.

If number is outside of its constraints, SECH returns the #NUM! error value.

If number is a nonnumeric value, SECH returns the #VALUE! error values.
SIN
Returns the sine of the given angle.
Syntax:
SIN(number)
where:
 number is the angle in radians for which you want the sine.
SINH
Returns the hyperbolic sine of a number.
Syntax:
SINH(number)
where:
 number is any real number.
SEC
The Sec
function returns the secant of an angle.
Syntax:
SEC(number)
where:
 numberangle radians to get the secant value.
Remarks:

#NUM!
occurs when the number is outside its constraints. 
#VALUE!
occurs when number is a nonnumeric value.
SUBTOTAL
Subtotal
function returns a subtotal in a list. Once the subtotal list is created, you can modify it by editing the Subtotal
function.
Syntax:
SUBTOTAL (function_Number, ref1, (ref2)…)
where:
 A function_Number is required. This specifies which function to use for calculating subtotals within a list. Here is the list of functions supported by Syncfusion:
Function numbers
Function Numbers  Function Names 

1  AVERAGE 
2  COUNT 
3  COUNTA 
4  MAX 
5  MIN 
6  PRODUCT 
7  STDEV 
8  STDEVP 
9  SUM 
10  VAR 

ref1The first named range that is used for the subtotal. This value is required.

ref2This value is optional.
PI
The PI
function returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
Syntax:
PI( )
PRODUCT
Multiplies all the numbers given as arguments and returns the product.
Syntax:
PRODUCT(number1, number2, …)
where:
 number1, number2, … are numbers that you want to multiply.
ROUND
Rounds a number to a specified number of digits.
Syntax:
ROUND(number, num_digits)
where:

number is the numeric value that you want to round.

num_digits is the number of digits to which you want to round the number argument.
Remarks:

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.

If num_digits is 0, the number is rounded to the nearest integer.

If num_digits is less than 0, the number is rounded to the left of the decimal point.
ROUNDUP
Rounds a number up, away from zero.
Syntax:
ROUNDUP(number, num_digits)
where:

number is any real number that you want rounded up.

num_digits is the number of digits to which you want to round number.
Remarks:

ROUNDUP behaves like ROUND, except that it always rounds a number up.

If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.

If num_digits is 0, then number is rounded up to the nearest integer.

If num_digits is less than 0, then number is rounded up to the left of the decimal point.
ROUNDDOWN
Rounds a number down, toward zero.
Syntax:
ROUNDDOWN(number, num_digits)
where:

number is any real number that you want rounded down.

num_digits is the number of digits to which you want to round number.
Remarks:

ROUNDDOWN behaves like ROUND, except that it always rounds a number down.

If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.

If num_digits is 0, then number is rounded down to the nearest integer.

If num_digits is less than 0, then number is rounded down to the left of the decimal point.
SQRT
The SQRT
function returns a positive square root.
Syntax:
SQRT(number)
where:
 number is the number for which you want the square root.
Remarks:
 Number must be >= 0.
SUMIF
Adds the cells specified by a given criteria.
Syntax:
SUMIF(range, criteria, sum_range)
where:

range is the range of cells you want evaluated.

criteria is the criteria in the form of a number, expression, or text that defines the cells to be added. For example, criteria can be expressed as “>32” or some other logical expression.

Sum_range is the actual cells to sum.
Remarks:

The cells in sum_range are summed only if their corresponding cells in range match the criteria.

If sum_range is omitted, the cells in range are summed.
SUMPRODUCT
Returns the sum of the products of corresponding array components in given arrays.
Syntax:
SUMPRODUCT(array1, [array2], [array3], …)
where:

array1 is an argument whose components you want to multiply and then add.

array2, array3… are array arguments 2 to 255 whose components you want to multiply and then add.
Remarks:

#VALUE!
Occurs when the array arguments are not in the same dimensions. 
SUMPRODUCT treats array entries that are not numeric as if they were zeros.
TAN
Returns the tangent of a number.
Syntax:
TAN(number)
where:
 number is the tangent of the angle that you want.
TRUNC
The Trunc
function truncates a supplied number to a specified number of decimal places.
Syntax:
TRUNC( number, [num_digits] )
where:

number is the initial number that is truncated.

[num_digits] is an optional argument that specifies the number of decimal places to truncate the supplied number to. The default value is 0.
ISTEXT
The IsText
function returns a Boolean value after determining that the provided value is a string.
Syntax:
ISTEXT(text)
where:
 text is the value you want to test if it is a string or not.