Math Trigonometry in WinForms Calculation Engine (Calculate)
13 Jul 202124 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 the cotangent of the angle. This must be a real number.
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
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.
SIGN
THe SINGN
function returns the sign of the supplied numerical argument. Returns 1 if the number is positive, zero (0) if the number is 0, and 1 if the number is negative.
Syntax:
SIGN(number)
where:
 number is any real number to get the sign.
TANH
THe TANH
function calculate the hyperbolic tangent of a supplied number.
Syntax:
TANH(number)
where:
 number is any real number that you want to calculate the hyperbolic tangent.
Sumsq
THe Sumsq
function returns the sum of the squares of a series of values.
Syntax:
SUMSQ(number1, [number2], …)
where:
 Number1, number2, … : Number1 is required, subsequent numbers are optional. A series of numeric values that are to be squared and then summed together.
Remarks:

Arguments can either be numbers or names, arrays, or references that contain numbers.

Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted.

The argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values are ignored.

Arguments that are error values or text that cannot be translated into numbers cause errors.
SUMX2MY2
THe SUMX2MY2
function calculate the sum of the difference of squares between two arrays.
Syntax:
SUMX2MY2(array_x, array_y)
where:

Array_x :The first array or range of values used in the calculation.

Array_y :The second array or range of values used in the calculation.
Remarks:

The arguments should be numbers or names, arrays, or references that contain numbers.

The argument contains text, logical values, or empty cells, those values are ignored. The cells with the value zero are included.

The arguments (array_x and array_y) have a different lengths(different numbers of values). it returns the
#N/A
error message.
Sumx2py2
THe Sumx2py2
function returns the sum of squares of corresponding values in two arrays and returns the sum of the results.
Syntax:
SUMX2PY2(array_x, array_y)
where:

Array_x :The first array or range of values used in the calculation.

Array_y :The second array or range of values used in the calculation.
Remarks:

The arguments should be numbers or names, arrays, or references that contain numbers.

If argument contains text, logical values, or empty cells, those values are ignored.The cells with the value zero are included.

The argument(array_x and array_y) have a different lengths(number of values), it returns the
#N/A
error message.
SUMXMY2
THe SUMXMY2
function returns the sum of squares of differences of corresponding values in two arrays and returns the sum of the results.
Syntax:
SUMXMY2(array_x, array_y)
where:

Array_x :The first array or range of values used in the calculation.

Array_y :The second array or range of values used in the calculation.
Remarks:

The arguments should be numbers or names, arrays, or references that contain numbers.

The argument contains text, logical values, or empty cells, those values are ignored.The cells with the value zero are included.

The arguments(array_x and array_y) have a different lengths(number of values), it returns the
#N/A
error message.
MULTINOMIAL
THe MULTINOMIAL
function calculates the ratio of the factorial of a sum of values to the product of factorials of those values.
Syntax:
MULTINOMIAL(number1, [number2], …)
where:
 Number1, number2, … : Number1 is required, subsequent numbers are optional. This is one or more arguments which you want to calculate the
multinomial.
Remarks:

The argument is nonnumeric, it returns the
#VALUE!
error message 
The argument is less than zero, it returns the
#NUM!
error message.
MROUND
THe MROUND
function rounds a number up or down, depending on the nearest multiple of given number.
Syntax:
MROUND(number, multiple)
where:

Number : The value hat should be rounded.

Multiple : The multiple to to use when round a number.
Remarks:

it rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

The arguments (Number and Multiple) must have the same sign. If not, it returns a
#NUM!
error message.
RANDBETWEEN
THe RANDBETWEEN
function returns a random integer number between given numbers. A new random integer number is returned each time when worksheet is recalculated.
Syntax:
RANDBETWEEN(bottom, top)
where:

Bottom : The smallest integer value that the function will return.

Top : The largest integer value that the function will return.
SQRTPI
THe SQRTPI
function returns the square root of a given number multiplied by the mathematical constant, π.
Syntax:
SQRTPI(number)
where:
 Number : The number is the positive numeric value that you want to multiplied by pi.
Remarks:
 The argument(number) is greater than 0, it returns the
#NUM!
error message.
QUOTIENT
THe QUOTIENT
function calculates the integer portion of a division. This function is used to discard the remainder of a division.
Syntax:
QUOTIENT(numerator, denominator)
where:

Numerator : This is a number.The dividend value.

Denominator :This is a number.The divisor value.
Remarks:
 The argument is nonnumeric, it returns the
#VALUE!
error message.
GCD
THe GCD
function returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that that goes into all given numbers without a remainder.
Syntax:
GCD(number1, [number2], …)
where:
 Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 values.
Remarks:

The argument is nonnumeric, it returns the
#VALUE!
error message. 
The argument is less than zero, it returns the
#NUM!
error message. 
One divides any value evenly.

A prime number has only itself and one as even divisors.
LCM
THe LCM
function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all given numbers.
Syntax:
LCM(number1, [number2], …)
where:
 Number1, number2, … Number1 is required, subsequent numbers are optional. The argument(numbers) are upto 255 numeric values for which you want to calculate the least common multiple. If any value is not an integer, it is truncated.
Remarks:

The argument is nonnumeric, it returns the
#VALUE!
error message. 
The argument is less than zero, it returns the
#NUM!
error message.
ROMAN
THe ROMAN
function converts an Arabic numeral to roman numeral as text.
Syntax:
ROMAN(number, [form])
where:

Number : The Arabic numeral you want to convert to Roman numeral.

Form (Optional) :A number specifying the type of roman numeral you want.
Remarks:

The argument (number) is negative, it returns the
#VALUE!
error message. 
The argument (number) is greater than 3999, it returns the
#VALUE!
error error message.
SUMIFS
THe SUMIFS
function sum all numbers in a range of cells, based on a single or multiple criteria.
Syntax:
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
where:

Sum_range : The range of cells to sum.

Criteria_range1 :The first range(Criteria_range1) to evaluate.

Criteria1 : It used to find which cells to add. Criteria1 is applied against Criteria_range1 .
Criteria_range2, criteria2, …(optional)::The first range(Criteria_range2) to evaluate.Additional ranges and their associated criteria.
MDETERM
THe MDETERM
function returns the matrix determinant of a given array.
Syntax:
MDETERM(array)
where:
 Array : The array argument is an array of numeric values A numeric array with an equal number of rows and columns.
MINVERSE
THe MINVERSE
function calculate the inverse of a square matrix of a given array.
Syntax:
MINVERSE(array)
where:
 Array : the array argument is an array of values representing a square matrix A numeric array with an equal number of rows and columns.
Remarks:

The argument(Array) can be given as a cell range, such as A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name for either of these.

The cells in array are empty or contain text, it returns a
#VALUE!
error message 
It returns a
#VALUE!
error message if array does not have an equal number of rows and columns.
MUNIT
THe MUNIT
function calculates the unit matrix for the specified dimension.
Syntax:
MUNIT(dimension)
where:
 Dimension is an integer value that specifies the dimension of the unit matrix. It returns an array. The dimension has to be greater than zero.
Remarks:
 The argument (dimension) is a value that’s equal to or smaller than zero (0), it returns the
#VALUE!
error value.
SERIESSUM
THe SERIESSUM
function returns the sum of a power series.
Syntax:
SERIESSUM(x, n, m, coefficients)
where:

X :The input value to the power series.

N :The first power to which you want to raise x.

M:The step by which to increase n for each term in the series.

Coefficients : An array of coefficients that multiplied by each successive power of x. The number of values in coefficients determines the number of terms in the power series.
Remarks:
 The argument is nonnumeric, it returns the
#VALUE!
error message.