EnterpriseSheet formulas

Formulas



Formulas in the EnterpriseSheet are used to perform calculations. EnterpriseSheet Formulas range from basic mathematical operations, such as addition and subtraction, to complex engineering and statistical calculations. You can add a formula to any cell in a spreadsheet by typing an equal sign (=) followed by the name of the function.

Formulas Types

EnterpriseSheet includes the following types of formulas:

Numeric / Mathematical Functions

Formulas Description Examples
ABS Syntax: ABS(number)
Returns the absolute value of the given number.
=ABS(A1)
ACOS Syntax: ACOS(number)
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. Number is the cosine of the angle and must be from -1 to 1.
=ACOS(0.3)
=ACOS(A1)
ACOSH Syntax: ACOSH(number)
Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1.
=ACOSH(3)
=ACOSH(A1)
ACOT Syntax: ACOT(number)
Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1.
=ACOT(0.3)
=ACOT(A1)
ASIN Syntax: ASIN(number)
Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. Number is the sine of the angle and must be from -1 to 1.
=ASIN(5)
=ASIN(A1)
ASINH Syntax: ASINH(number)
Returns the inverse hyperbolic sine of a number.
=ASINH(1)
=ASINH(A1)
ATAN Syntax: ATAN(number)
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. Number is the tangent of the angle and must be from -1 to 1.
=ATAN(1)
=ATAN(A1)
ATAN2 Syntax: ATAN2(x_num, y_num)
Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
=ATAN2(3,5)
ATANH Syntax: ATANH(number)
Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1.
=ATANH(0.5)
=ATANH(A1)
CEILING Syntax: CEILING(number, significance)
Returns number rounded up, away from zero, to the nearest multiple of significance.
=CEILING(A5, 1)
=CEILING(210, 0.05)
COMBIN Syntax: COMBIN(number, CHOOSE)
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.
Number is the number of items.
Number_chosen is the number of items in each combination.
=COMBIN(A5, 1)
=COMBIN(210, 0.05)
COMBINA Syntax: COMBINA(number, CHOOSE)
Returns the number of combinations (with repetitions) for a given number of items.
=COMBINA(A5, 1)
=COMBINA(10, 3)
COS Syntax: COS(number)
Returns a Double specifying the cosine of an angle. Number is a Double or any valid numeric expression that expresses an angle in radians.
=COS(A1)
=COS(5)
=COS(-0.5)
COT Syntax: COT(number)
Returns the hyperbolic cosine of a number.
=COS(A1)
=COS(5)
COSH Syntax: COSH(number)
Returns the hyperbolic cosine of a number.
=COSH(A1)
=COSH(5)
=COSH(-0.5)
CSC Syntax: CSC(number)
Returns the cosecant of an angle specified in radians.
=CSC(A1)
=CSC(15)
CSCH Syntax: CSCH(number)
Return the hyperbolic cosecant of an angle specified in radians.
=CSCH(A1)
=CSCH(15)
DEGREES Syntax: DEGREES(number)
This function converts radians into degrees.
=DEGREES(A1)
=DEGREES(30)
EXP Syntax: EXP(number)
Returns a Double specifying e (the base of natural logarithms) raised to a power.
=EXP(A1)
=EXP(10)
EVEN Syntax: EVEN(number)
Returns number rounded up to the nearest even integer.
=EXP(A1)
=EVEN(5.5)
FACT Syntax: FACT(number)
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.
=FACT(A1)
=FACT(1.9)
FACTDOUBLE Syntax: FACTDOUBLE(number)
Returns the double factorial of a number.
=FACTDOUBLE(A1)
=FACTDOUBLE(6)
FLOOR Syntax: FLOOR(number, significance)
Rounds number down, toward zero, to the nearest multiple of significance.
=FLOOR(A1, 0.01)
=FLOOR(0.234, 0.01)
GCD Syntax: GCD(number1, number2, ...)
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
=GCD(A1,A2)
=GCD(24, 36 )
INT Syntax: INT(number)
Rounds a number down to the nearest integer.
=INT(a1)
=INT(-5.5)
LCM Syntax: LCM(number1, number2, ...)
Calculate the Least Common Multiple, which is the smallest number that can be divided by each of the given numbers.
=LCM(a1,a2,a3....)
LN Syntax: LN(number)
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
=LN(2)
LOG Syntax: LOG(number, [base])
Returns the logarithm of a number to the base you specify.
=LOG(2, 3)
LOG10 Syntax: LOG10(number)
Returns the base-10 logarithm of a number.
=LOG10(10^5)
MOD Syntax: MOD(number,divisor)
Mode returns the remainder after number is divided by divisor. The result has the same sign as divisor.
=MOD(-3, 2)
=MOD(3, 2)
=MOD(A2, 3)
MROUND Syntax: MROUND(number, multiple)
Returns a number rounded to the desired multiple.
=MROUND(10, 3)
=MROUND(5, -2)
ODD Syntax: ODD(number)
Returns number rounded up to the nearest odd integer.
=ODD(2)
=ODD(6.5)
=ODD(A2)
PI Syntax: PI()
Returns the value of Pi, 3.14159265358979.
=PI()
POWER Syntax: POWER(base, power)
Returns the result of a number raised to a power. Base is the number that is to be raised to the given power. Power is the exponent by which the base is to be raised.
=POWER(a1,2)
=POWER(a1,a2)
=POWER(5,2)
PRODUCT Syntax: PRODUCT(number1, number2, ...)
Multiplies its arguments
=PRODUCT(a1,a2,a3)
=PRODUCT(a1:a3)
QUOTIENT Syntax: QUOTIENT(numerator,denominator)
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
=QUOTIENT(A1, A2)
=QUOTIENT(4.5, 3.1)
RADIANS Syntax: RADIANS(angle)
Converts degrees to radians.
=RADIANS(a1)
=RADIANS(170)
RAND Syntax: RAND()
Returns a random number between 0 and 1.
=RAND()
RANDBETWEEN Syntax: RANDBETWEEN(bottom,top)
Returns a random number between the numbers you specify.
=RANDBETWEEN(A1,A2)
=RANDBETWEEN(1,100)
ROUND Syntax: ROUND(number, count)
Rounds the given number to a certain number of decimal places according to valid mathematical criteria. Count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.
=ROUND(a1,2)
=ROUND(-78.96,1)
=ROUND(55.1,-1)
ROUNDDOWN Syntax: ROUNDDOWN(number, count)
Rounds the given number to a certain number of decimal places according to valid mathematical criteria (toward zero). Count is the number of the places to which the value is to be rounded.
=ROUNDDOWN(A1,5)
=ROUNDDOWN(36.8,0)
=ROUNDDOWN(31415.92654, -3)
ROUNDUP Syntax: ROUNDUP(number, count)
Rounds the given number to a certain number of decimal places according to valid mathematical criteria (away zero). Count is the number of the places to which the value is to be rounded.
=ROUNDUP(A1,2)
=ROUNDUP(36.8,0)
=ROUNDUP(31415.92654, -3)
SEC Syntax: SEC(number)
Returns the secant of an angle.
=SEC(A1)
=SEC(15)
SECH Syntax: SECH(number)
Returns the hyperbolic secant of an angle.
=SECH(A1)
=SECH(15)
SIGN Syntax: SIGN(number)
Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.
=SIGN(5.5)
=SIGN(A1)
SIN Syntax: SIN(number)
Returns a Double specifying the sine of an angle. Number is a Double or any valid numeric expression that expresses an angle in radians.
=SIN(5.5)
=SIN(A1)
SINH Syntax: SINH(number)
Returns the hyperbolic sine of a number.
=SINH(5.5)
=SINH(A1)
SQRT Syntax: SQRT(number)
Returns a positive square root
=SQRT(a1)
SQRTPI Syntax: SQRTPI(number)
Returns a positive square root of (number * pi).
=SQRTPI(2)
=SQRTPI(A1)
SUBTOTAL Syntax: SUBTOTAL(function_num, ref1, ref2, ...)
Returns a subtotal in a list or database.

Function_num is the number 1 to 11 (includes hidden values) that specifies which function to use in calculating subtotals within a list.
=SUBTOTAL(1,A1:A2)
=SUBTOTAL(2, a1:a5)
SUM Syntax: SUM(number1, number2, ...)
Returns the sum of corresponding array numbers
=SUM(a1,a2)
=SUM(a1:a5)
=SUM(1,3,4,-1,-2,-5,6,7...)
SUMIF Syntax: SUMIF(range, criteria, [sum_range])
Adds all numbers in a range of cells, based on a given criteria. Range is the range of cells that you want to apply the criteria against. Criteria is used to determine which cells to add. Sum_range are the cells to sum.
=SUMIF(A1:A8,">1000",B1:B8)
SUMIFS Syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Adds the cells in a range that meet multiple criteria.
=SUMIFS(A1:A20, B1:B20, ">0", C1:C20, ">10")
SUMPRODUCT Syntax: SUMPRODUCT(array1, array2, ...)
Returns the sum of the products of corresponding array components.
=SUMPRODUCT(a1:b2, D1:E2)
=SUMPRODUCT(a1,a1,a3)
SUMSQ Syntax: SUMSQ(number1, number2, ...)
Calculates the sum of the squares of numbers.
=SUMSQ(A1:A5)
=SUMSQ(A1, A2,A3...)
=SUMSQ(1,2,3,4...)
SUMXMY2 Syntax: SUMXMY2(array1, array2)
This function calculates the sum of the squares of the differences between values in two arrays and returns the sum of the results.
array1 and array2 are two ranges or arrays.
=SUMXMY2(A1:A8,B1:B8)
SUMX2PY2 Syntax: SUMX2PY2(array1, array2)
This function calculates the sum of the squares of corresponding values in two arrays and returns the sum of the results.
array1 and array2 are two ranges or arrays.
=SUMX2PY2(A1:A8,B1:B8)
SUMX2MY2 Syntax: SUMX2MY2(array1, array2)
This function calculates the difference of squares of corresponding values in two arrays and returns the sum of the results.
array1 and array2 are two ranges or arrays.
=SUMX2MY2(A1:A8,B1:B8)
TAN Syntax: TAN(number)
Returns a Double specifying the tangent of an angle. The required number is a Double or any valid numeric expression that expresses an angle in radians.
=TAN(0.823)
=TAN(A1)
TANH Syntax: TANH(number)
Returns the hyperbolic tangent of a number.
=TANH(0.823)
=TANH(A1)
TRUNC Syntax: TRUNC(number)
Truncates a number to an integer.
=TRUNC(314.1592, 2)
=TRUNC(A1)

Logic Functions

Formulas Description Examples
AND Syntax: AND(logical1, logical2, ...)
Returns TRUE if all of its arguments are TRUE.
=AND(A1,A2,A5)
=AND(A1:A3)
=AND(a1>10,b1="test")
FALSE Syntax: FALSE()
Returns the logical value FALSE
=FALSE()
IF Syntax: IF(test, then_value, otherwise_value)
Returns one value if a condition evaluates to TRUE and another value if it evaluates to FALSE.
Test is any value or expression that can be TRUE or FALSE.
Then_value is the value that is returned if the logical test is TRUE.
Otherwise_value is the value that is returned if the logical test is FALSE.
=IF(and(a1,a2), a5, a6)
=IF(a1>a2, a5, a6)
=IF(a1>=a2, "test", "test2")
IFERROR Syntax: IFERROR(test, value)
If the first argument is an error, then the second argument will be returned. If the first argument is not an error, then it will be returned.
=IFERROR(a1/a2, "error")
IFNA Syntax: IFNA(test, value)
If the first argument is an not available, then the second argument will be returned. Otherwise it will be returned.
=IFNA(a1/a2, "error")
NOT Syntax: NOT(logical)
Reverses the logic of its argument
=NOT(a1)
=NOT(a1>a2)
=NOT(a1="test")
OR Syntax: OR(logical1, logical2, ...)
Returns TRUE if any argument is TRUE
=OR(a1)
=OR(a1>10, a2>5)
=OR(a1>10,b1="test")
TRUE Syntax: TRUE()
Returns the logical value TRUE
=TRUE()

Lookup / Reference Functions

Formulas Description Examples
AREAS Syntax: AREAS(ref)
This function returns the number of ranges in a reference. Reference is a range of cells.
=AREAS(A1:C3)
CHOOSE Syntax: Choose(position, value1, value2, ...)
Choose a value from a list of values. Position is position number in the list of values to return. It must be a number between 1 and 29.
=CHOOSE(2, "first", "second", "third")
=CHOOSE(6, a1,a2, a3)
COLUMN Syntax: COLUMN(reference)
Column function returns the column number of a cell reference.
=COLUMN()
=COLUMN(B4:B6)
COLUMNS Syntax: COLUMNS(reference)
Columns function returns the number of columns in a cell reference.
=COLUMNS(A4:B6)
HLOOKUP Syntax: HLOOKUP(lookup_value, tabe_array, row_index, [not_exact_match])
Search for value in the top row of tabe_array and returns the value in the same column based on the row_index.
=HLOOKUP("age", A1:D5, 3, TRUE)
INDEX Syntax: INDEX(reference, row, column)
This function returns either the value or the reference to a value from a table or range.
array is a range of cells or table.
row is the row number in the array to use to return the value.
column is optional. It is the column number in the array to use to return the value.
=INDEX(A1:D5, 4, 1)
LOOKUP Syntax: LOOKUP(lookup_value, lookup_vector, [result_vector])
The LOOKUP function returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: the vector form and the array form.
=LOOKUP(10251, A1:A6, B1:B6)
MATCH Syntax: MATCH(lookup_value, lookup_array, [match_type])
Search for a specified item in a range of cells, and then returns the relative position of that item in the range. The match_type can be 1 (default), 0, -1.
=MATCH(29, A1:D5, 1)
=MATCH("*ge", G498:G501, 0)
OFFSET Syntax: OFFSET(reference, rows, cols, [height], [width])
This function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
=OFFSET(D3,3,-2,1,1)
=SUM(OFFSET(D3:F5,3,-2, 3, 3))
ROW Syntax: ROW(reference)
Row function returns the row number of a cell reference.
= ROW ()
= ROW (A1:A2)
ROWS Syntax: ROWS(reference)
Rows function returns the number of rows in a cell reference.
=ROWS(A4:B6)
VLOOKUP Syntax: VLOOKUP(lookup_value, tabe_array, col_index, [not_exact_match])
Search for value in the left-most column of tabe_array and returns the value in the same row based on the col_index.
=VLOOKUP(1,A2:A8,2)
=VLOOKUP(0.1,A1:F10,3,TRUE)

Statistical Functions

Formulas Description Examples
AVEDEV Syntax: AVEDEV(number1, [number2], ...)
Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
=AVEDEV(A1,A2,A3)
=AVEDEV(A1:A3)
AVERAGE Syntax: AVERAGE(number1, number2, ...)
Returns the average of the arguments. Number1, number2, ... are numerical values or ranges. Text is ignored.
=AVERAGE(A1,A2,A3)
=AVERAGE(A1:A3)
AVERAGEIF Syntax: AVERAGEIF(range, criteria, average_range)
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
=AVERAGEIF(B2:B5,"<23000")
=AVERAGEIF(A2:A6,"=*West",B2:B6)
AVERAGEIFS Syntax: AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ....])
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
=AVERAGEIFS(B2:B5,B2:B5,">70",B2:B5,"<90")
=AVERAGEIFS(D2:D5,D2:D5, "<>Incomplete", D2:D5, ">80")
BINOM.DIST Syntax: BINOM.DIST(number_s,trials,probability_s,cumulative)
Returns the individual term binomial distribution probability.
=BINOM.DIST(6, 10, 0.5, FALSE)
CORREL Syntax: CORREL(array1, array2)
Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.
=CORREL(a1:a10, b1:b10)
COUNT Syntax: COUNT(value1, value2, ...)
Counts how many numbers are in the list of arguments. Text entries are ignored. Value1, value2, ... value30 are values or ranges which are to be counted.
=COUNT(a1:a10)
=COUNT(a1,a2,a3)
COUNTA Syntax: COUNTA(value1, [value2], ...)
Counts the number of cells that are not empty in a range.
=COUNTA(a1,a2,a3,a4)
COUNTIF Syntax: COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given criteria.
range is the range of cells that you want to count based on the criteria.
criteria is used to determine which cells to count.
=COUNTIF(A2:A25,"temp")
COUNTIFS Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
COUNTBLANK Syntax: COUNTBLANK(range)
Counts empty cells in a specified range of cells.
=COUNTBLANK(A1:B25)
DEVSQ Syntax: DEVSQ(number1, [number2], ...)
Returns the sum of squares of deviations of data points from their sample mean.
=DEVSQ(A1,A2,A3)
=DEVSQ(A1:A3)
EXPON.DIST Syntax:EXPON.DIST(x,lambda,cumulative)
Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank teller takes to deliver cash.
=EXPON.DIST(x,lambda,cumulative)
FISHER Syntax:FISHER(x)
Returns the Fisher transformation at x.
=FISHER(x)
FISHERINV Syntax:FISHERINV(x)
Returns the inverse of the Fisher transformation.
=FISHERINV(x)
GAMMA Syntax: GAMMA(number)
Return the gamma function value.
=GAMMA(2.5)
GAMMALN Syntax: GAMMALN(number)
Returns the natural logarithm of the gamma function.
=GAMMALN(2.5)
GEOMEAN Syntax: GEOMEAN(number1, [number2], ...)
Returns the geometric mean of an array or range of positive data.
=GEOMEAN(A1:B25)
HARMEAN Syntax: HARMEAN(number1, [number2], ...)
Returns the harmonic mean of an array or range of positive data.
=HARMEAN(A1:B25)
LARGE Syntax: LARGE(array, nth_position)
Returns the nth largest value from a set of values.
=LARGE(A1:A5, 1)
MAX Syntax: MAX(number1, number2, ...)
Returns the maximum value in a list of arguments. Ignores logic values and text.
=MAX(a1:a5)
=MAX(a1,a2,a3,10)
MEDIAN Syntax: MEDIAN(number1, number2, ...)
Median function returns the median of the numbers provided.
=MEDIAN(a1, a2, a3)
=MEDIAN(a1:a3)
MIN Syntax: MIN(number1, number2, ...)
Returns the minimum value in a list of arguments. Ignores logic values and text.
=MIN(a1:a5)
=MIN(a1,a2,a3,10)
MODE Syntax: MODE(number1, number2, ...)
Mode return the most frequently occurring value in a list of numbers.
=MODE(A1, A2)
MODE.SNGL Syntax: MODE.SNGL(number1, number2, ...)
Mode return the most frequently occurring value in a list of numbers.
=MODE.SNGL(A1, A2)
PEARSON Syntax: PEARSON(array1, array2)
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
=PEARSON(A2:A6,B2:B6)
PERCENTILE.EXC Syntax: PERCENTILE.EXC(array,k)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
=PERCENTILE.EXC(A1:A5,0.5)
PERCENTILE.INC Syntax: PERCENTILE.INC(array,k)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
=PERCENTILE.INC(A1:A5,0.5)
QUARTILE.EXC Syntax: QUARTILE.EXC(array,quart)
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
=QUARTILE.EXC(A1:A5,1)
QUARTILE.INC Syntax: QUARTILE.INC(array,quart)
Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
=QUARTILE.INC(A1:A5,1)
RANK.AVG Syntax: RANK.AVG(number,ref,[order])
Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.
=RANK.AVG(1, B1:B5)
RANK.EQ Syntax: RANK.EQ(number,ref,[order])
Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned.
=RANK.EQ(1, B1:B5)
RSQ Syntax: RSQ(known_y's, known_x's)
Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
=RSQ(A1:A5, B1:B5)
SLOPE Syntax: SLOPE(known_y's, known_x's)
Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.
=SLOPE(A1:A5, B1:B5)
SMALL Syntax: SMALL(array, nth_position)
Returns the nth smallest value from a set of values.
=SMALL(A1:A5, 2)
=SMALL(A1,A2,A3,A4...)
STDEV.S Syntax: STDEV.S(number1,[number2],...])
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
=STDEV.S(A1:A5])
STDEV.P Syntax: STDEV.P(number1,[number2],...])
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
=STDEV.P(A1:A5])
VAR.S Syntax: VAR.S(number1,[number2],...])
Estimates variance based on a sample (ignores logical values and text in the sample).
=VAR.S(A1:A5])
VAR.P Syntax: VAR.P(number1,[number2],...])
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
=VAR.P(A1:A5])

Text Functions

Formulas Description Examples
ASC Syntax: ASC(string)
Returns the ASCII value of a character or the first character in a string.
string is the specified character to retrieve the AscII value for. If there is more than one character, the function will return the AscII value for the first character and ignore all of the characters after the first.
=ASC("BOOK")
=ASC(A1)
CHAR Syntax: CHAR(ascii_value)
CHAR function returns the character based on the ASCII value.
ascii_value is the ASCII value used to retrieve the character.
=CHAR(33)
CODE Syntax: CODE(text)
Returns a numeric code for the first character in a text string.
=CODE("ABC")
CONCATENATE Syntax: CONCATENATE(text1, text2, ...)
Combines several text strings into one string. Text_1, text_2, ... are text passages that are to be combined into one string.
=CONCATENATE(A1, A2)
DOLLAR Syntax: DOLLAR(number, [Decimals])
Convert a number to text using currency format with the decimals round to the specified place.
=DOLLAR(A1, 2)
=DOLLAR(1234.5671, -2)
EXACT Syntax: EXACT(text1, text2)
This function compares two strings and returns TRUE if both values are the same. And it is case-sensitive.
=EXACT(A1, 2)
FIND Syntax: FIND(find_text, within_text, [start_num])
This function returns the location of a substring in a string. The search is case-sensitive.
Find_text is the text you want to find.
Within_text is the text containing the text you want to find.
Start_num(Optional) Specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1.
=FIND("ec","ROUND Specuf")
=FIND("M","Qiriam Mc Govern",2)
FIXED Syntax: FIXED(number, [decimal_places], [no_commas])
This function returns a text representation of a number rounded to a specified number of decimal places..
=FIXED(A1, 1, TRUE)
LEFT Syntax: LEFT(text, number)
Returns the first character or characters in a text string. Text is the text where the initial partial words are to be determined. Number (optional) is the number of characters for the start text. If this parameter is not defined, one character is returned.
=LEFT(A1, 8)
LEN Syntax: LEN(text)
Len function returns the length of the specified string.
=LEN(A1)
=LEN("text string")
LOWER Syntax: LOWER(text)
This function converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.
=LOWER(A1)
=LOWER("text string")
MID Syntax: MID(text, start_position, number_of_characters)
This function extracts a substring from a string (starting at any position).
=MID("text string",7,10)
PROPER Syntax: PROPER(text)
This function sets the first character in each word to uppercase and the rest to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.
=MID("text string",7,10)
REPLACE Syntax: REPLACE(text, start, number_of_chars, new_text)
This function replaces a sequence of characters in a string with another set of characters.
=REPLACE(A1, 3, 3, "ok")
REPT Syntax: REPT(text, number)
Repeats a character string by the given number of copies.
=REPT(A1, 3)
SUBSTITUTE Syntax: SUBSTITUTE(text, old_text, new_text, [nth_appearance])
This function replaces a set of characters with another. Use SUBSTITUTE when you want to replace specific text in a text string.
=SUBSTITUTE(A2, "Sales", "Cost")
TEXT Syntax: TEXT(value, format)
Text function returns a value converted to text with a specified format.
=TEXT(A1, "$0.00")
TRIM Syntax: TRIM(text)
Returns a text value with the leading and trailing spaces removed.
= TRIM(A1)
= TRIM(" apple ")
VALUE Syntax: VALUE(text)
Converts a text string into a number. Text is the text to be converted to a number.
=VALUE("100")
= VALUE("-12345")
UPPER Syntax: UPPER(text)
This function allows you to convert text to all uppercase. If there are characters in the string that are not letters, they are unaffected by this function.
=UPPER(A1)
=UPPER("test string")

Date Functions

Formulas Description Examples
DATE Syntax: DATE(year, month, day)
Converts a date written as year, month, day to an internal serial number and displays it in the cell's formatting. Year is an integer between 1583 and 9956 or 0 and 99. Month is an integer between 1 and 12. Day is an integer between 1 and 31.
=DATE(2012, 06, 26)
DATEVALUE Syntax: DATEVALUE(date_text)
Converts a date that is stored as text to a serial number that it recognizes as a date.
=DATEVALUE("2012-06-26")
DAY Syntax: DAY(date_value)
This function returns the day of the month (a number from 1 to 31) given a date value.
=DAY(today())
DAYS Syntax: DAYS(end_date, start_date)
This function returns the number of days between two dates.
=DAYS(A1,A2)
=DAYS(2013-02-01,2013-12-22)
DAYS360 Syntax: DAYS360(start_date, end_date, [method])
This function returns the number of days between two dates based on a 360-day year.
start_date and end_date are the two dates to calculate the difference between.
method is optional. It is a boolean value - either TRUE or FALSE. If TRUE is entered, the DAYS360 function will use the US method. If FALSE is entered, the DAYS360 function will use the European method.
=DAYS360(A1,A2)
=DAYS360(2013-02-01,2013-12-22)
EDATE Syntax: EDATE(Start_date, months)
Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date).
=EDATE(today(), 2)
EOMONTH Syntax: EOMONTH(Start_date, months)
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date.
=EOMONTH(today(), 2)
HOUR Syntax: Hour(serial_number)
This function returns the hour of a time value (from 0 to 23).
=DAY(A1)
=DAY(12:52:35)
MINUTE Syntax: MINUTE(serial_number)
This function returns the minute of a time value (from 0 to 59).
=MINUTE("8:28:10")
MONTH Syntax: MONTH(date_value)
This function returns the month (a number from 1 to 12) given a date value.
=MONTH(2013-12-22)
NETWORKDAYS Syntax: NETWORKDAYS(start_date,end_date, [holidays])
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.
=NETWORKDAYS(A1, A2, B1:B5)
NETWORKDAYS.INTL Syntax: NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays])
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.
=NETWORKDAYS.INTL(A1, A2, 1, B1:B5)
NOW Syntax: NOW()
Returns the current computer system date time. NOW is a function without arguments.
=NOW()
SECOND Syntax: SECOND(serial_number)
This function returns the second of a time value (from 0 to 59).
=SECOND("8:28:18")
=SECOND("3:08:18 PM")
=SECOND("8:28:18")
TIME Syntax: TIME(hour, minute, second)
This function returns the decimal number for a particular time.
=TIME(0,650,0)
=TIME(A1,A2,A3)
TIMEVALUE Syntax: TIMEVALUE(date_text)
Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
=TIMEVALUE("2012-06-26 20:30")
TODAY Syntax: TODAY()
Returns the current computer system date. TODAY is a function without arguments.
=TODAY()
WEEKDAY Syntax: WEEKDAY(serial_number, [type])
Returns the day of the week for the given serial_number (date value). The day is returned as an integer based on the type.
Type is option. It can be any of the following values:
type = 1 (default), the weekdays are counted starting from Sunday (Monday = 2).
type = 2, the weekdays are counted starting from Monday (Monday = 1).
type = 3, the weekdays are counted starting from Monday (Monday = 0).
=WEEKDAY(A1)
=WEEKDAY("2010/10/13")
WEEKNUM Syntax: WEEKNUM(serial_number, [type])
Returns a number that indicates where the week falls numerically within a year. The WEEKNUM function considers the week containing January 1 to be the first week of the year.
Type is option. It can be any of the following values:
type = 1 (default), Week begins on Sunday.
type = 2, Week begins on Monday.
=WEEKNUM(A1)
=WEEKNUM(Date(2010,10,13), 2)
WORKDAY Syntax: WORKDAY(start_date, days, [holidays])
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
=WORKDAY(A1, 10, B1:B5)
WORKDAY.INTL Syntax: WORKDAY.INTL(start_date, days, [weekend], [holidays])
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
=WORKDAY.INTL(A1, 10, 1, B1:B5)
YEAR Syntax: YEAR(date_value)
This function returns a four-digit year (a number from 1900 to 9999) given a date value.
=YEAR(A1)
=YEAR("2013/10/13")
YEARFRAC Syntax: YEARFRAC(start_date, end_date, basis)
Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.
=YEARFRAC(A2,A3,A4)

Financial Functions

Formulas Description Examples
COUPDAYS Syntax: COUPDAYS(settlement, maturity, frequency, [basis])
Returns the number of days in the coupon period that contains the settlement date.
=COUPDAYS(A2,A3,A4,2,1)
COUPNCD Syntax: COUPNCD(settlement, maturity, frequency, [basis])
Returns a number that represents the next coupon date before the settlement date.
=COUPNCD(A2,A3,A4,2,1)
COUPNUM Syntax: COUPNUM(settlement, maturity, frequency, [basis])
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
= COUPNUM(A2,A3,A4,2,1)
COUPPCD Syntax: COUPPCD(settlement, maturity, frequency, [basis])
Returns a number that represents the previous coupon date before the settlement date.
=COUPPCD(A2,A3,A4,2,1)
DB Syntax: DB(cost, salvage, life, period, [number_months])
Returns the depreciation of an asset for a given time period based on the fixed-declining balance method.
cost is the original cost of the asset.
salvage is the salvage value after the asset has been fully depreciated.
life is the useful life of the asset or the number of periods that you will be depreciating the asset.
period is the period that you wish to calculate the depreciation for. Use the same units as for the life.
number_months is optional. It is the number of months in the first year of depreciation. If this parameter is omitted, the DB function will assume that there are 12 months in the first year.
=DB(A2,A3,A4,5, 7 )
=DB(10000,10000,6,5, 7 )
DDB Syntax: DDB(cost, salvage, life, period, [factor])
Returns the depreciation of an asset for a given time period based on the fixed-declining balance method.
cost is the original cost of the asset.
salvage is the salvage value after the asset has been fully depreciated.
life is the useful life of the asset or the number of periods that you will be depreciating the asset.
period is the period that you wish to calculate the depreciation for. Use the same units as for the life.
factor is optional. It is the rate at which the balance declines. If this parameter is omitted, the DDB function will assume the factor to be 2.
=DDB(3000,300,10,1,2)
DOLLARDE Syntax: DOLLARDE(fractional_dollar, fraction)

Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number.
=DOLLARDE(1.125, 8)
DOLLARFR Syntax: DOLLARFR(decimal_dollar, fraction)

Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
=DOLLARFR(1.125, 8)
EFFECT Syntax: EFFECT(nominal_rate, npery)
This function returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
=EFFECT(A2,A3)
FV Syntax: FV(interest_rate, number_payments, payment, [PV], [Type])
This function returns the future value of an investment based on an interest rate and a constant payment schedule.
interest_rate is the interest rate for the investment.
number_payments is the number of payments for the annuity.
payment is the amount of the payment for each period. This should be entered as a negative value.
PV is optional. It is the present value of the payments.
Type is optional. It indicates when the payments are due. Type can be one of the following values: 0 - Payments are due at the end of the period. (default), 1 - Payments are due at the beginning of the period.
=FV(6%/12, 10, -800, -2000)
IPMT Syntax: IPMT(interest_rate, period, number_payments, PV, [FV], [type])
Returns the interest payment for an investment based on an interest rate and a constant payment schedule.
period is the period to calculate the interest rate. It must be a value between 1 and number_payments.
interest_rate is the interest rate for the loan.
number_payments is the number of payments for the loan.
PV is the present value or principal of the loan.
FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.
Type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
=IPMT(10%, 3, 5000, 20)
IRR Syntax: IRR(range, [estimated_irr])
This function returns the internal rate of return for a series of cash flows represented by the numbers in values. The cash flows must occur at regular intervals, but do not have to be the same amounts for each interval.
range is a range of cells that represent the series of cash flows.
estimated_irr is optional. It is the your guess at the internal rate of return.
=IRR(A1:A6)
MIRR Syntax: MIRR(range, finance_rate, reinvestment_rate)
This function returns the modified internal rate of return for a series of cash flows. The internal rate of return is calculated by using both the cost of the investment and the interest received by reinvesting the cash.
range is a range of cells that represent the series of cash flows.
finance_rate is the interest rate that you pay on the cash flow amounts.
reinvestment_rate is the interest rate that you receive on the cash flow amounts as they are reinvested.
=MIRR(A1:A9,A10,12%)
NPER Syntax: NPER(interest_rate, payment, PV, [FV], [Type])
This function returns the number of periods for an investment based on an interest rate and a constant payment schedule.
interest_rate is the interest rate for the investment.
payment is the amount of the payment for each period. This should be entered as a negative value.
PV is the present value of the payments.
FV is optional. It is the future value that you\'d like the investment to be after all payments have been made. If this parameter is omitted, the NPER function will assume a FV of 0.
Type is optional. It indicates when the payments are due. Type can be one of the following values: 0 - Payments are due at the end of the period. (default), 1 - Payments are due at the beginning of the period.
=NPER(12%/12, -100, 500, 10000)
=NPER(A1/12, A2, A3, A4)
NPV Syntax: NPV(discount_rate, value1, value2, ... value_n)
This function returns the net present value of an investment.
discount_rate is the discount rate for the period.
value1, value2, ... value_n are the future payments and income for the investment (ie: cash flows).
=NPV(A1, A2:A8)
PMT Syntax: PMT(interest_rate, number_payments, PV, [FV], [type])
Returns the payment amount for a loan based on an interest rate and a constant payment schedule.
interest_rate is the interest rate for the loan.
number_payments is the number of payments for the loan.
PV is the present value or principal of the loan.
FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.
Type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
=PMT(6%, -100, 500)
=PMT(a1, a2,a3)
PPMT Syntax: PPMT(interest_rate, period, number_payments, PV, [FV], [type])
Returns the payment on the principal for a particular payment based on an interest rate and a constant payment schedule.
interest_rate is the interest rate for the loan.
period is the period used to determine how much principal has been repaid. Period must be a value between 1 and number_payments.
number_payments is the number of payments for the loan.
PV is the present value or principal of the loan.
FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PPMT function assumes a FV value of 0.
Type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
=PPMT(A1, A2, 10, A3)
=PPMT(5%, 20, 8, 8000)
PV Syntax: PV(interest_rate, number_payments, payment, [FV], [Type])
This function returns the present value of an investment based on an interest rate and a constant payment schedule.
interest_rate is the interest rate for the investment.
number_payments is the number of payments for the annuity.
payment is the amount of the payment made each period.
FV (optional) is the desired value (future value) to be reached at the end of the periodic payments.
Type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
=PV(0.5, 50, 600, 1, 0)
RATE Syntax: RATE(NPER, PMT, PV, [FV], [type], [guess])
Returns the constant interest rate per period of an annuity.
NPER is the total number of periods, during which payments are made (payment period).
PMT is the constant payment (annuity) paid during each period.
PV is the cash value in the sequence of payments.
FV (optional) is the future value, which is reached at the end of the periodic payments.
Type (optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
Guess (optional) determines the estimated value of the interest with iterative calculation.
=RATE(A2*12, A3, A4)
SLN Syntax: SLN(cost, salvage, life)
This function returns the depreciation of an asset for a period based on the straight-line depreciation method.
cost is the original cost of the asset.
salvage is the salvage value after the asset has been fully depreciated.
life is the useful life of the asset or the number of periods that you will be depreciating the asset.
=SLN(A1, A2, A3)
=SLN(8000, 1000, 10)
SYD Syntax: SYD(cost, salvage, life, period)
This function returns the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.
cost is the original cost of the asset.
salvage is the salvage value after the asset has been fully depreciated.
life is the useful life of the asset or the number of periods that you will be depreciating the asset.
period is the period that you wish to calculate the depreciation for. Use the same units as for the life.
=SYD(A1,A2,A3,1)
=SYD(8000, 1000, 10,10)
VDB Syntax: VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.

Cost: The initial cost of the asset.

Salvage: The value at the end of the depreciation. This value can be 0.

Life: the number of periods over which the asset is depreciated.

Start_period: The starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

End_period: The ending period for which you want to calculate the depreciation. End_period must use the same units as life.

Factor: The rate at which the balance declines. If factor is omitted, it is assumed to be 2.

No_switch: A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
=VDB(A2, A3, A4, 0, 0.875, 1.5)

Information Functions

Formulas Description Examples
ISBLANK Syntax: ISBLANK(value)
This function is used to check for blank or null values.
=ISBLANK(A1)
ISERROR Syntax: ISERROR(value)
Returns TRUE if value is an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL).
=ISERROR(A1)
ISERR Syntax: ISERR(value)
Returns TRUE if value is an error value (except #N/A).
=ISERR(A1)
ISEVEN Syntax: ISEVEN(number)
Returns TRUE if number is even, or FALSE if number is odd.
=ISEVEN(A1)
=ISEVEN(5)
ISLOGICAL Syntax: ISLOGICAL(value)
This function is used to check for a logical value (ie: TRUE or FALSE).
=ISLOGICAL(TRUE)
=ISLOGICAL("FALSE")
ISNA Syntax: ISNA(value)
Returns TRUE if value is not available.
=ISNA(A1)
ISNUMBER Syntax: ISNUMBER(value)
Returns TRUE if value is number, or FALSE if value is not number.
=ISNUMBER(A1)
=ISNUMBER(1234)
ISODD Syntax: ISODD(number)
Returns TRUE if number is odd, or FALSE if number is even.
=ISODD(2.5)
=ISODD(5)
=ISODD(A1)
ISTEXT Syntax: ISTEXT(value)
Returns TRUE if value is a text value, or FALSE if value is not a text value.
=ISTEXT(A1)
=ISTEXT("string")
N Syntax: N(value)
This function converts a value to a number.
If value is a date, the N function returns the date as a serial number.
If value is boolean - true/false, the N function returns 1/0.
=N(A1)
=N("8")
NA Syntax: NA()
This function returns the error value #N/A.
=NA()
TYPE Syntax: TYPE(value)
Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell.
=TYPE(value)

Engineering Functions

Formulas Description Examples
BESSELI Syntax: BESSELI(X, N)
Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated for purely imaginary arguments.
=BESSELI(1.5, 1)
BESSELJ Syntax: BESSELJ(X, N)
Returns the Bessel function Jn(x).
=BESSELJ(1.9, 2)
BESSELK Syntax: BESSELK(X, N)
Returns the modified Bessel function Kn(x)
=BESSELK(1.5, 1)
BESSELY Syntax: BESSELY(X, N)
Returns the Bessel function Yn(x).
=BESSELY(2.5, 1)
BIN2DEC Syntax: BIN2DEC(number)
Converts a binary number to decimal.
=BIN2DEC(101010)
BIN2HEX Syntax: BIN2HEX(number, [places])
Converts a binary number to hexadecimal.
=BIN2HEX(101010, 5)
BIN2OCT Syntax: BIN2OCT(number, [places])
Converts a binary number to octal.
=BIN2OCT(101010)
BITAND Syntax: BITAND(number1, number2)
Returns a bitwise 'AND' of two numbers.
=BITAND(1, 2)
BITOR Syntax: BITOR(number1, number2)
Returns a bitwise 'OR' of two numbers.
=BITOR(1, 2)
BITXOR Syntax: BITXOR(number1, number2)
Returns a bitwise 'XOR' of two numbers.
=BITXOR(1, 2)
BITLSHIFT Syntax: BITLSHIFT(number, shift_number)
Returns a number shifted left by the specified number of bits.
=BITLSHIFT(1, 2)
BITRSHIFT Syntax: BITRSHIFT(number, shift_number)
Returns a number shifted right by the specified number of bits.
=BITRSHIFT(1, 2)
CONVERT Syntax: CONVERT(number, from_unit, to_unit)
This function is used to convert a number from one measurement system to another.
=CONVERT(10, "sg", "g")
DEC2BIN Syntax: DEC2BIN(number, [places])
Converts a decimal number to binary.
=DEC2BIN(9, 4)
DEC2HEX Syntax: DEC2HEX(number, [places])
Converts a decimal number to hexadecimal.
=DEC2HEX(100, 4)
DEC2OCT Syntax: DEC2OCT(number, [places])
Converts a decimal number to octal.
=DEC2OCT(58, 3)
DELTA Syntax: DELTA(number1, [number2])
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. If omitted, number2 is assumed to be zero.
=DELTA(2, 1)
ERF Syntax: ERF(lower_limit,[upper_limit])
Returns the error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between zero and lower_limit.
=ERF(1, 2)
ERFC Syntax: ERFC(lower_limit,[upper_limit])
Returns the complementary error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between lower_limit and infinity.
=ERFC(1, 2)
GESTEP Syntax: GESTEP(number,[step])
Returns 1 if number >= step; returns 0 (zero) otherwise. Use this function to filter a set of values.
=GESTEP(1, 2)
HEX2BIN Syntax: HEX2BIN(number, [places])
Converts a hexadecimal number to binary.
=HEX2BIN("F", 8)
HEX2DEC Syntax: HEX2DEC(number)
Converts a hexadecimal number to decimal.
=HEX2DEC("A5")
HEX2OCT Syntax: HEX2OCT(number, [places])
Converts a hexadecimal number to oct.
=HEX2OCT("F", 3)
IMABS Syntax: IMABS(inumber)
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the absolute value.
=IMABS("3+4i")
IMAGINARY Syntax: IMAGINARY(inumber)
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the imaginary coefficient.
=IMAGINARY("3+4i")
IMARGUMENT Syntax: IMARGUMENT(inumber)
Returns the argument Theta (theta), an angle expressed in radians.
Inumber is a complex number for which you want the argument Theta.
=IMARGUMENT("3+4i")
IMCOS Syntax: IMCOS(inumber)
Returns the cosine of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the cosine.
=IMCOS("3+4i")
IMCOSH Syntax: IMCOSH(inumber)
Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic cosine.
=IMCOSH("3+4i")
IMCOT Syntax: IMCOT(inumber)
Returns the cotangent of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the cotangent.
=IMCOT("3+4i")
IMCSC Syntax: IMCSC(inumber)
Returns the cosecant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the cosecant.
=IMCSC("3+4i")
IMCSCH Syntax: IMCSCH(inumber)
Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic cosecant.
=IMCSCH("3+4i")
IMCONJUGATE Syntax: IMCONJUGATE(inumber)
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the conjugate.
=IMCONJUGATE("3+4i")
IMDIV Syntax: IMDIV(inumber1, inumber2)
Returns the quotient of two complex numbers in x + yi or x + yj text format.
Inumber1 is the complex numerator or dividend. Inumber2 is the complex denominator or divisor.
=IMDIV("3+4i", "2+2i")
IMEXP Syntax: IMEXP(inumber)
Returns the exponential of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the exponential.
=IMEXP("3+4i")
IMLN Syntax: IMLN(inumber)
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the natural logarithm.
=IMLN("3+4i")
IMLOG2 Syntax: IMLOG2(inumber)
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the base-2 logarithm.
=IMLOG2("3+4i")
IMLOG10 Syntax: IMLOG10(inumber)
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the common logarithm.
=IMLOG10("3+4i")
IMPOWER Syntax: IMPOWER(inumber, number)
Returns a complex number in x + yi or x + yj text format raised to a power.
Inumber is a complex number for which you want to raise to a power. Number is the power to which you want to raise the complex number.
=IMPOWER("3+4i", "2+2i")
IMPRODUCT Syntax: IMPRODUCT(inumber1,inumber2...)
Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format.
Inumber1,inumber2,... are 1 to 29 complex numbers to multiply.
=IMPRODUCT("3+4i", "2+2i")
IMREAL Syntax: IMREAL(inumber)
Returns the real coefficient of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the real coefficient.
=IMREAL("3+4i")
IMSEC Syntax: IMSEC(inumber)
Returns the secant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the secant.
=IMSEC("3+4i")
IMSECH Syntax: IMSECH(inumber)
Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you hyperbolic secant.
=IMSECH("3+4i")
IMSIN Syntax: IMSIN(inumber)
Returns the sine of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the sine.
=IMSIN("3+4i")
IMSINH Syntax: IMSINH(inumber)
Returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
Inumber is a complex number for which you want the hyperbolic sine.
=IMSINH("3+4i")
IMSQRT Syntax: IMSQRT(inumber1)
Returns the square root of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the square root.
=IMSQRT("3+4i")
IMSUM Syntax: IMSUM(inumber1,inumber2...)
Returns the sum of two or more complex numbers in x + yi or x + yj text format.
Inumber1,inumber2,... are 1 to 29 complex numbers to add.
=IMSUM("3+4i", "2+2i")
IMSUB Syntax: IMSUB(inumber1,inumber2)
Returns the difference of two complex numbers in x + yi or x + yj text format.
Inumber1,inumber2, the complex number from which to subtract.
=IMSUB("3+4i", "2+2i")
IMTAN Syntax: IMTAN(inumber)
Returns the tangent of a complex number in x + yi or x + yj text format.
Inumber is a complex number for which you want the tangent.
=IMTAN("3+4i")
OCT2BIN Syntax: OCT2BIN(number, [places])
Converts an Octal (Base 8) number into a Binary (Base 2) number.
=OCT2BIN("2", 10)
OCT2DEC Syntax: OCT2DEC(number)
Converts an octal number to decimal.
=OCT2DEC(54)
OCT2HEX Syntax: OCT2HEX(number, [places])
Converts an octal number to hexadecimal.
=OCT2HEX(100, 4)

 

 


Copyright © FeyaSoft Inc. All rights reserved.