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.
EnterpriseSheet includes the following types of formulas:
| 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) |
| 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() |
| 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) |
| HYPERLINK | Syntax: HYPERLINK(link_location,friendly_name) Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. |
=hyperlink("http://www.cubedrive.com") =hyperlink("Sheet2!A1", "Link to sheet2") |
| 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) |
| 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]) |
| 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) |
| RIGHT | Syntax: RIGHT(text, number) Defines the last character or characters in a text string. Text is the text of which the right part is to be determined. Number (optional) is the number of characters from the right part of the text. |
=RIGHT(A2, 1) =RIGHT(A2, 1) =RIGHT("Test String", 5) |
| 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") |
| 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) |
| DATEDIF | Syntax: DATEDIF(start_date,end_date,unit) Calculates the number of days, months, or years between two dates. |
=DATEDIF("6/1/2001","8/15/2002","D") |
| 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) |
| 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) |
| 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) |
| 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) |