Math & Trigonometry

9 Oct 201916 minutes to read

ABS

Returns the absolute Value of a number. The absolute value of a non-negative 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 non-numeric 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 y-coordinates. The arctangent is the angle from the x-axis 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 x-axis; and negative result represents clockwise angle.

  • ATAN2(a,b) equals ATAN(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 non-numeric value, BASE returns the #VALUE! error value.

  • If any non-integer 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:

  • number-angle radians to get the cotangent value.

Remarks:

  • #NUM! occurs when the number is out of the range.

  • #VALUE! occurs when the number is a non-numeric 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 non-numeric value.

CSC

The CSC function returns the cosecant of an angle specified in radians.

Syntax:

CSC(number)

where:

  • number-angle radians to get the cosecant value.

Remarks:

  • #NUM! occurs when the number is outside its constraints.

  • #VALUE! occurs when the number is a non-numeric value.

CSCH

The CSCH function returns the hyperbolic cosecant of an angle specified in radians.

Syntax:

CSCH(number)

where:

  • number-angle radians to get the hyperbolic cosecant value.

Remarks:

  • #NUM! occurs when the number is outside its constraints.

  • #VALUE! occurs when the number is a non-numeric 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 non-numeric.

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:

  • number-number that is rounded up to a multiple of significance.

  • significance-multiple 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 non-negative 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:

  • number-This value is required.

Remarks:

  • #NUM! when the number is lesser than zero (0).

  • #VALUE! Occurs when any of the given argument is non-numeric

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 base-10 logarithm of a number.

Syntax:

LOG10(number)

where:

  • number is the positive real number for which, you want the base-10 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 non-numeric, 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()*(b-a)+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 non-numeric 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:

  • number-angle radians to get the secant value.

Remarks:

  • #NUM! occurs when the number is outside its constraints.

  • #VALUE! occurs when number is a non-numeric 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
  • ref1-The first named range that is used for the subtotal. This value is required.

  • ref2-This 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.