User:Tagezi/CalcFunction
From The Document Foundation Wiki
Contents
Preliminary notes
There are 486 calc functions now (in 5.0 version LO). You cannot find GOALSEEK, MULTIPLE.OPERATIONS, MULTIRANGE and NEG in the function wizard, but they are. In 5.3 version LO, I have foudnd 496(?) functions, but now I can not post them here (see this).
Calc Function
| Function Name | Function IDKey | Function Macros | Сategory | Function Discription | Discription IDKey | Discription Macros | Discription in Help |
|---|---|---|---|---|---|---|---|
| ABS | uETgj | SC_OPCODE_ABS | Mathematical | Absolute value of a number. | BKTRA | HID_FUNC_ABS | Returns the absolute value of a number. |
| ACCRINTM | xGuEM | ANALYSIS_FUNCNAME_Accrintm | Financial | Returns the accrued interest for a security that pays interest at maturity | SPUpd | HID_AAI_FUNC_ACCRINTM | Calculates the accrued interest of a security in the case of one-off payment at the settlement date. |
| ACCRINT | z9irP | ANALYSIS_FUNCNAME_Accrint | Financial | Returns the accrued interest for a security that pays periodic interest | z5FMG | HID_AAI_FUNC_ACCRINT | Calculates the accrued interest of a security in the case of periodic payments. |
| ACOSH | TH8Se | SC_OPCODE_ARC_COS_HYP | Mathematical | Returns the inverse hyperbolic cosine of a number. | bbYEb | HID_FUNC_ARCOSHYP | Returns the inverse hyperbolic cosine of a number. |
| ACOS | SYMW7 | SC_OPCODE_ARC_COS | Mathematical | Returns the arccosine of a number. | xJHpC | HID_FUNC_ARCCOS | Returns the inverse trigonometric cosine of a number. |
| ACOTH | mE2Fx | SC_OPCODE_ARC_COT_HYP | Mathematical | Returns the inverse hyperbolic cotangent of a number. | tDEYM | HID_FUNC_ARCOTHYP | Returns the inverse hyperbolic cotangent of the given number. |
| ACOT | zY4DB | SC_OPCODE_ARC_COT | Mathematical | Returns the inverse cotangent of a number. | S7HCA | HID_FUNC_ARCCOT | Returns the inverse cotangent (the arccotangent) of the given number. |
| ADDRESS | Dv9Va | SC_OPCODE_ADDRESS | Spredsheet | Returns the reference to a cell as text. | P3ACF | HID_FUNC_ADRESSE | Returns a cell address (reference) as text, according to the specified row and column numbers. You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used.In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position.In INDIRECT, the parameter is appended as the second parameter. |
| AGGREGATE | 3jcFK | SC_OPCODE_AGGREGATE | Mathematical | Calculates an aggregate in a spreadsheet. | PeZXD | HID_FUNC_AGGREGATE | AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. |
| AMORDEGRC | cqNFM | ANALYSIS_FUNCNAME_Amordegrc | Financial | Returns the prorated linear depreciation of an asset for each accounting period | AD7tA | HID_AAI_FUNC_AMORDEGRC | Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here. |
| AMORLINC | Vyaq3 | ANALYSIS_FUNCNAME_Amorlinc | Financial | Returns the prorated linear depreciation of an asset for each accounting period | Tfg5i | HID_AAI_FUNC_AMORLINC | Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered. |
| AND | 7QEfB | SC_OPCODE_AND | Logical | Returns TRUE if all arguments are TRUE. | dYoGs | HID_FUNC_UND | Returns TRUE if all arguments are TRUE. If one of the elements is FALSE, this function returns the FALSE value.The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values. |
| ARABIC | 7NjFV | SC_OPCODE_ARABIC | Text | Calculates the value of a Roman numeral. | wBFV5 | HID_FUNC_ARABISCH | Calculates the value of a Roman number. The value range must be between 0 and 3999. |
| AREAS | YhR7e | SC_OPCODE_AREAS | Spredsheet | Returns the number of individual ranges that belong to a (multiple) range. | h58Fm | HID_FUNC_BEREICHE | Returns the number of individual ranges that belong to a multiple range. A range can consist of contiguous cells or a single cell.The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges. |
| ASC | Dkdzq | SC_OPCODE_ASC | Text | Converts full-width ASCII and katakana characters to half-width. | SS5st | HID_FUNC_ASC | The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string. See Calc/Features/JIS and ASC functions for a conversion table. |
| ASINH | 8EcST | SC_OPCODE_ARC_SIN_HYP | Mathematical | Returns the inverse hyperbolic sine of a number. | gp9Hy | HID_FUNC_ARSINHYP | Returns the inverse hyperbolic sine of a number. |
| ASIN | Kfoej | SC_OPCODE_ARC_SIN | Mathematical | Returns the arcsine of a number. | AHZyT | HID_FUNC_ARCSIN | Returns the inverse trigonometric sine of a number. |
| ATAN2 | WJmDE | SC_OPCODE_ARC_TAN_2 | Mathematical | Returns the arctangent for the specified coordinates. | iAvZt | HID_FUNC_ARCTAN2 | Returns the inverse trigonometric tangent of the specified x and y coordinates. |
| ATANH | N89xF | SC_OPCODE_ARC_TAN_HYP | Mathematical | Returns the inverse hyperbolic tangent of a number. | VwxcD | HID_FUNC_ARTANHYP | Returns the inverse hyperbolic tangent of a number. |
| ATAN | kwCpZ | SC_OPCODE_ARC_TAN | Mathematical | Returns the arctangent of a number. | ScWjt | HID_FUNC_ARCTAN | Returns the inverse trigonometric tangent of a number. |
| AVEDEV | J8C2k | SC_OPCODE_AVE_DEV | Statistic | Returns the average of the absolute deviations of a sample from the mean. | KET4K | HID_FUNC_MITTELABW | Returns the average of the absolute deviations of data points from their mean. Displays the diffusion in a data set. |
| AVERAGEA | sLQ9c | SC_OPCODE_AVERAGE_A | Statistic | Returns the average value for a sample. Text is evaluated as zero. | TzEY7 | HID_FUNC_MITTELWERTA | Returns the average of the arguments. The value of a text is 0. |
| AVERAGEIFS | JABWu | SC_OPCODE_AVERAGE_IFS | Statistic | Averages the value of the cells that meet multiple criteria in multiple ranges. | 3rhYN | HID_FUNC_AVERAGEIFS | Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values. |
| AVERAGEIF | V4LQj | SC_OPCODE_AVERAGE_IF | Statistic | Averages the arguments that meet the conditions. | ENXTB | HID_FUNC_AVERAGEIF | Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values. |
| AVERAGE | SGaxB | SC_OPCODE_AVERAGE | Statistic | Returns the average of a sample. | ACAWo | HID_FUNC_MITTELWERT | Returns the average of the arguments. |
| BAHTTEXT | bTUSF | SC_OPCODE_BAHTTEXT | Text | Converts a number to text (Baht). | 792Hd | HID_FUNC_BAHTTEXT | Converts a number to Thai text, including the Thai currency names. |
| BASE | wCT5J | SC_OPCODE_BASE | Text | Converts a positive integer to text from a number system to the base defined. | GXMAP | HID_FUNC_BASIS | Converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used. |
| BESSELI | EFSFy | ANALYSIS_FUNCNAME_Besseli | Add-in | Returns the modified Bessel function In(x) | hQFoN | HID_AAI_FUNC_BESSELI | Calculates the modified Bessel function. |
| BESSELJ | oyZnL | ANALYSIS_FUNCNAME_Besselj | Add-in | Returns the Bessel function Jn(x) | aoFgN | HID_AAI_FUNC_BESSELJ | Calculates the Bessel function (cylinder function). |
| BESSELK | Frcpi | ANALYSIS_FUNCNAME_Besselk | Add-in | Returns the Bessel function Kn(x) | KBFDb | HID_AAI_FUNC_BESSELK | Calculates the modified Bessel function. |
| BESSELY | NQCGW | ANALYSIS_FUNCNAME_Bessely | Add-in | Returns the Bessel function Yn(x) | zxDiU | HID_AAI_FUNC_BESSELY | Calculates the modified Bessel function. |
| BETADIST | 4B235 | SC_OPCODE_BETA_DIST | Statistic | Values of the beta distribution. | GNCGW | HID_FUNC_BETAVERT | Returns the beta function. |
| BETA.DIST | GyF23 | SC_OPCODE_BETA_DIST_MS | Statistic | Values of the beta distribution. | 3oQqD | HID_FUNC_BETADIST_MS | Returns the beta function. |
| BETAINV | ghE3x | SC_OPCODE_BETA_INV | Statistic | Values of the inverse beta distribution. | 6jg9G | HID_FUNC_BETAINV | Returns the inverse of the cumulative beta probability density function. |
| BETA.INV | wk5hq | SC_OPCODE_BETA_INV_MS | Statistic | Values of the inverse beta distribution. | E4CCH | HID_FUNC_BETAINV_MS | Returns the inverse of the cumulative beta probability density function. |
| BIN2DEC | 2C4PK | ANALYSIS_FUNCNAME_Bin2Dec | Add-in | Converts a binary number to a decimal number | HMzjE | HID_AAI_FUNC_BIN2DEC | The result is the decimal number for the binary number entered. |
| BIN2HEX | zrP9E | ANALYSIS_FUNCNAME_Bin2Hex | Add-in | Converts a binary number to a hexadecimal number | WLAuB | HID_AAI_FUNC_BIN2HEX | The result is the hexadecimal number for the binary number entered. |
| BIN2OCT | 3tbwu | ANALYSIS_FUNCNAME_Bin2Oct | Add-in | Converts a binary number to an octal number | sYWZ4 | HID_AAI_FUNC_BIN2OCT | The result is the octal number for the binary number entered. |
| BINOMDIST | Pjcki | SC_OPCODE_BINOM_DIST | Statistic | Values of the binomial distribution. | ntGe3 | HID_FUNC_BINOMVERT | Returns the individual term binomial distribution probability. |
| BINOM.DIST | vuyAB | SC_OPCODE_BINOM_DIST_MS | Statistic | Values of the binomial distribution. | fDSB9 | HID_FUNC_BINOM_DIST_MS | Returns the individual term binomial distribution probability. |
| BINOM.INV | WFBQB | SC_OPCODE_BINOM_INV | Statistic | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | JQcFV | HID_FUNC_BINOM_INV_MS | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| BITAND | 8mtGu | SC_OPCODE_BITAND | Mathematical | Bitwise \"AND\" of two integers. | EVMrG | HID_FUNC_BITAND | Returns a bitwise logical "and" of the parameters. |
| BITLSHIFT | FoPSq | SC_OPCODE_BITLSHIFT | Mathematical | Bitwise left shift of an integer value. | tBEEY | HID_FUNC_BITLSHIFT | Shifts a number left by n bits. |
| BITOR | BoKrB | SC_OPCODE_BITOR | Mathematical | Bitwise \"OR\" of two integers. | Difbf | HID_FUNC_BITOR | Returns a bitwise logical "or" of the parameters. |
| BITRSHIFT | KVBwG | SC_OPCODE_BITRSHIFT | Mathematical | Bitwise right shift of an integer value. | hFkEz | HID_FUNC_BITRSHIFT | Shifts a number right by n bits. |
| BITXOR | KTB8x | SC_OPCODE_BITXOR | Mathematical | Bitwise \"exclusive OR\" of two integers. | bRuAE | HID_FUNC_BITXOR | Returns a bitwise logical "exclusive or" of the parameters. |
| B | SACzY | SC_OPCODE_B | Statistic | Returns the probability of a trial result using binomial distribution. | n4Rdd | HID_FUNC_B | Returns the probability of a sample with binomial distribution. |
| CEILING | dVRCa | SC_OPCODE_CEIL | Mathematical | Rounds a number up to the nearest multiple of significance. | 7ydFr | HID_FUNC_OBERGRENZE | Rounds a number up to the nearest multiple of Significance. |
| CEILING.MATH | njCpy | SC_OPCODE_CEIL_MATH | Mathematical | Rounds a number up to the nearest multiple of significance. | oyegx | HID_FUNC_CEIL_MATH | |
| CEILING.PRECISE | EWtPT | SC_OPCODE_CEIL_PRECISE | Mathematical | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. | 8s4JR | HID_FUNC_CEIL_PRECISE | Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance |
| CEILING.XCL | 6sYhp | SC_OPCODE_CEIL_MS | Mathematical | Rounds a number up to the nearest multiple of significance. | ay4wy | HID_FUNC_CEIL_MS | Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance |
| CELL | GCcod | SC_OPCODE_CELL | Infirmation | Determines information about address, formatting or contents of a cell. | 7968z | HID_FUNC_ZELLE | Returns information on address, formatting or contents of a cell. |
| CHAR | pDGCA | SC_OPCODE_CHAR | Text | Converts a code number into a character or letter. | quG7s | HID_FUNC_ZEICHEN | Converts a number into a character according to the current code table. The number can be a two-digit or three-digit integer number. |
| CHIDIST | dYBYM | SC_OPCODE_CHI_DIST | Statistic | Returns the right-tail probability of the chi-square distribution. | t5DR7 | HID_FUNC_CHIVERT | Returns the probability value from the indicated Chi square that a hypothesis is confirmed. CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.The probability determined by CHIDIST can also be determined by CHITEST. |
| CHIINV | SqmN5 | SC_OPCODE_CHI_INV | Statistic | Values of the inverse of CHIDIST(x; DegreesOfFreedom). | jbjX5 | HID_FUNC_CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
| CHISQDIST | cguFP | SC_OPCODE_CHISQ_DIST | Statistic | Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. | NDrR5 | HID_FUNC_CHISQDIST | Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution. |
| CHISQ.DIST.RT | E6EDq | SC_OPCODE_CHI_DIST_MS | Statistic | Returns the right-tail probability of the chi-square distribution. | mQj6j | HID_FUNC_CHIVERT_MS | Returns the probability value from the indicated Chi square that a hypothesis is confirmed. CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.The probability determined by CHISQ.DIST.RT can also be determined by CHITEST. |
| CHISQ.DIST | XTe77 | SC_OPCODE_CHISQ_DIST_MS | Statistic | Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. | rSqif | HID_FUNC_CHISQDIST_MS | Returns the probability density function or the cumulative distribution function for the chi-square distribution. |
| CHISQ.INV | 5n6HW | SC_OPCODE_CHISQ_INV_MS | Statistic | Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE()). | MoYS9 | HID_FUNC_CHISQINV_MS | Returns the inverse of the left-tailed probability of the chi-square distribution. |
| CHISQINV | mCaHt | SC_OPCODE_CHISQ_INV | Statistic | Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE()). | oAFnj | HID_FUNC_CHISQINV | Returns the inverse of CHISQDIST. |
| CHISQ.INV.RT | iqU83 | SC_OPCODE_CHI_INV_MS | Statistic | Values of the inverse of CHIDIST(x; DegreesOfFreedom). | QYcBk | HID_FUNC_CHIINV_MS | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
| CHISQ.TEST | zKBMf | SC_OPCODE_CHI_TEST_MS | Statistic | Returns the chi square independence test. | DJkay | HID_FUNC_CHITEST_MS | Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence. CHISQ.TEST returns the chi-squared distribution of the data.The probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row. |
| CHITEST | XH5Lk | SC_OPCODE_CHI_TEST | Statistic | Returns the chi square independence test. | 52UVi | HID_FUNC_CHITEST | Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence. CHITEST returns the chi-squared distribution of the data.The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row. |
| CHOOSE | Bcjdw | SC_OPCODE_CHOOSE | Spredsheet | Selects a value from a list of up to 30 value arguments. | 6Qg6x | HID_FUNC_WAHL | Uses an index to return a value from a list of up to 30 values. |
| CLEAN | Jct8K | SC_OPCODE_CLEAN | Text | Removes all nonprintable characters from text. | hXFnv | HID_FUNC_SAEUBERN | All non-printing characters are removed from the string. |
| CODE | jhVGi | SC_OPCODE_CODE | Text | Returns a numeric code for the first character in a text string. | yH8rL | HID_FUNC_CODE | Returns a numeric code for the first character in a text string. |
| COLOR | eu8AU | SC_OPCODE_COLOR | Mathematical | Returns an implementation defined value representing a RGBA color | QeEoL | HID_FUNC_COLOR | |
| COLUMN | cnoDG | SC_OPCODE_COLUMN | Spredsheet | Returns the internal column number of a reference. | 6ewCD | HID_FUNC_SPALTE | Returns the column number of a cell reference. If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row array if the formula is entered as an array formula. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined. |
| COLUMNS | gqpUo | SC_OPCODE_COLUMNS | Spredsheet | Returns the number of columns in an array or reference. | BbezW | HID_FUNC_SPALTEN | Returns the number of columns in the given reference. |
| COMBINA | J48iK | SC_OPCODE_COMBIN_A | Mathematical | Calculates the number of combinations of elements including repetition. | mPP3c | HID_FUNC_KOMBINATIONEN2 | Returns the number of combinations of a subset of items including repetitions. |
| COMBIN | TBNEU | SC_OPCODE_COMBIN | Mathematical | Calculates the number of combinations for elements without repetition. | odb62 | HID_FUNC_KOMBINATIONEN | Returns the number of combinations for elements without repetition. |
| COMPLEX | mDhAE | ANALYSIS_FUNCNAME_Complex | Add-in | Converts real and imaginary coefficients into a complex number | UFYAz | HID_AAI_FUNC_COMPLEX | The result is a complex number which is returned from a real coefficient and an imaginary coefficient. |
| CONCATENATE | 5ftuZ | SC_OPCODE_CONCAT | Text | Combines several text items into one. | LgyBU | HID_FUNC_VERKETTEN | Combines several text strings into one string. |
| CONFIDENCE | Bh3Lc | SC_OPCODE_CONFIDENCE | Statistic | Returns a (1 alpha) confidence interval for a normal distribution. | wQDRQ | HID_FUNC_KONFIDENZ | Returns the (1-alpha) confidence interval for a normal distribution. |
| CONFIDENCE.NORM | HQJrV | SC_OPCODE_CONFIDENCE_N | Statistic | Returns a (1 alpha) confidence interval for a normal distribution. | ntaye | HID_FUNC_CONFIDENCE_N | Returns the (1-alpha) confidence interval for a normal distribution. |
| CONFIDENCE.T | C8y9D | SC_OPCODE_CONFIDENCE_T | Statistic | Returns a (1 alpha) confidence interval for a Student's t distribution. | eF2DV | HID_FUNC_CONFIDENCE_T | Returns the (1-alpha) confidence interval for a Student's t distribution. |
| CONVERT | 6DDQB | SC_OPCODE_CONVERT | Mathematical | Converts a value according to a conversion table in the configuration (main.xcd). | rFaBE | HID_FUNC_UMRECHNEN | Converts between old European national currency and to and from Euros. |
| CONVERT | TNWeA | ANALYSIS_FUNCNAME_Convert | Add-in | Converts a number from one measurement system to another | W5E64 | HID_AAI_FUNC_CONVERT | Converts a value from one unit of measure to the corresponding value in another unit of measure. Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l.Property |
| CORREL | FjgDk | SC_OPCODE_CORREL | Statistic | Returns the correlation coefficient. | 6kXqE | HID_FUNC_KORREL | Returns the correlation coefficient between two data sets. |
| COSH | GJRdd | SC_OPCODE_COS_HYP | Mathematical | Returns the hyperbolic cosine of a number. | bw73s | HID_FUNC_COSHYP | Returns the hyperbolic cosine of a number. |
| COS | SkGGz | SC_OPCODE_COS | Mathematical | Returns the cosine of a number. | 9yjFZ | HID_FUNC_COS | Returns the cosine of the given angle (in radians). |
| COTH | kyGMR | SC_OPCODE_COT_HYP | Mathematical | Returns the hyperbolic cotangent of a number. | Tuj5q | HID_FUNC_COTHYP | Returns the hyperbolic cotangent of a given number (angle). |
| COT | LbQTN | SC_OPCODE_COT | Mathematical | Returns the cotangent of a number. | Vg6M3 | HID_FUNC_COT | Returns the cotangent of the given angle (in radians). |
| COUNTA | rCC8N | SC_OPCODE_COUNT_2 | Statistic | Counts how many values are in the list of arguments. | HXCpE | HID_FUNC_ANZAHL2 | Counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.UFI: fix to #i35888# |
| COUNTBLANK | WJeYc | SC_OPCODE_COUNT_EMPTY_CELLS | Statistic | Counts the blank cells in a specified range. | 7FBSg | HID_FUNC_ANZAHLLEEREZELLEN | Returns the number of empty cells. |
| COUNT | gnDKM | SC_OPCODE_COUNT | Statistic | Counts how many numbers are in the list of arguments. | Aqs5H | HID_FUNC_ANZAHL | Counts how many numbers are in the list of arguments. Text entries are ignored. |
| COUNTIFS | eHJDE | SC_OPCODE_COUNT_IFS | Statistic | Counts the cells that meet multiple criteria in multiple ranges. | W7o26 | HID_FUNC_COUNTIFS | Returns the count of rows or columns that meet criteria in multiple ranges. |
| COUNTIF | vhSDg | SC_OPCODE_COUNT_IF | Statistic | Counts the arguments which meet the set conditions. | nR8BU | HID_FUNC_ZAEHLENWENN | Returns the number of cells that meet with certain criteria within a cell range. |
| COUPDAYBS | 9BDGp | ANALYSIS_FUNCNAME_Coupdaybs | Financial | Returns the number of days from the beginning of the coupon period to the settlement date | KBBcx | HID_AAI_FUNC_COUPDAYBS | Returns the number of days from the first day of interest payment on a security until the settlement date. |
| COUPDAYS | gF8PM | ANALYSIS_FUNCNAME_Coupdays | Financial | Returns the number of days in the coupon period containing the settlement date | cYCWX | HID_AAI_FUNC_COUPDAYS | Returns the number of days in the current interest period in which the settlement date falls. |
| COUPDAYSNC | h9Uhw | ANALYSIS_FUNCNAME_Coupdaysnc | Financial | Returns the number of days from the settlement date to the next coupon date | FBGxa | HID_AAI_FUNC_COUPDAYSNC | Returns the number of days from the settlement date until the next interest date. |
| COUPNCD | D8crD | ANALYSIS_FUNCNAME_Coupncd | Financial | Returns the first coupon date after the settlement date | ZkR4n | HID_AAI_FUNC_COUPNCD | Returns the date of the first interest date after the settlement date. Format the result as a date. |
| COUPNUM | PT2LT | ANALYSIS_FUNCNAME_Coupnum | Financial | Returns the number of coupons payable between the settlement and maturity dates | DyfXD | HID_AAI_FUNC_COUPNUM | Returns the number of coupons (interest payments) between the settlement date and the maturity date. |
| COUPPCD | NxQyv | ANALYSIS_FUNCNAME_Couppcd | Financial | Returns the last coupon date preceding the settlement date | 2iCqW | HID_AAI_FUNC_COUPPCD | Returns the date of the interest date prior to the settlement date. Format the result as a date. |
| COVAR | 4xswV | SC_OPCODE_COVAR | Statistic | Calculates the population covariance. | vyY3x | HID_FUNC_KOVAR | Returns the covariance of the product of paired deviations. |
| COVARIANCE.P | jZtYM | SC_OPCODE_COVARIANCE_P | Statistic | Calculates the population covariance. | gKqme | HID_FUNC_COVARIANCE_P | Returns the covariance of the product of paired deviations, for the entire population. |
| COVARIANCE.S | 3MZB2 | SC_OPCODE_COVARIANCE_S | Statistic | Calculates the sample covariance. | zsT5a | HID_FUNC_COVARIANCE_S | Returns the covariance of the product of paired deviations, for a sample of the population. |
| CRITBINOM | XgV8W | SC_OPCODE_CRIT_BINOM | Statistic | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | hfFku | HID_FUNC_KRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| CSC | CE3d6 | SC_OPCODE_COSECANT | Mathematical | Return the cosecant of an angle. CSC(x)=1/SIN(x) | MhXZG | HID_FUNC_COSECANT | Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle |
| CSCH | HYzDE | SC_OPCODE_COSECANT_HYP | Mathematical | Return the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x) | CcKu4 | HID_FUNC_COSECANTHYP | Returns the hyperbolic cosecant of a number. |
| CUMIPMT | giE2c | ANALYSIS_FUNCNAME_Cumipmt | Financial | Returns the cumulative interest to be paid between two periods | g4KQF | HID_AAI_FUNC_CUMIPMT | Calculates the accumulated interest for a period. |
| CUMIPMT | jqESM | SC_OPCODE_CUM_IPMT | Financial | Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate. | Mr8oq | HID_FUNC_KUMZINSZ | Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate. |
| CUMPRINC | 7AYEt | ANALYSIS_FUNCNAME_Cumprinc | Financial | Returns the cumulative principal on a loan to be paid between two periods | HrSEQ | HID_AAI_FUNC_CUMPRINC | Calculates the cumulative redemption of a loan in a period. |
| CUMPRINC | JMDEG | SC_OPCODE_CUM_PRINC | Financial | Cumulative Capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate. | 9YG2f | HID_FUNC_KUMKAPITAL | Returns the cumulative interest paid for an investment period with a constant interest rate. |
| CURRENT | Ksu9B | SC_OPCODE_CURRENT | Infirmation | Calculates the current value of the formula at the present location. | CQG9E | HID_FUNC_AKTUELL | This function returns the result to date of evaluating the formula of which it is a part (in other words the result as far as that evaluation has got). Its main use is together with the STYLE() function to apply selected styles to a cell depending on the cell contents. |
| DATE | DGufs | SC_OPCODE_GET_DATE | Date&Time | Provides an internal number for the date given. | qsXz8 | HID_FUNC_DATUM | This function calculates a date specified by year, month, day and displays it in the cell's formatting. The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format. |
| DATEDIF | U5n64 | SC_OPCODE_GET_DATEDIF | Date&Time | Returns the number of whole days, months or years between 'start date' and 'end date'. | DPFXB | HID_FUNC_DATEDIF | This function returns the number of whole days, months or years between Start date and End date. |
| DATEVALUE | GVhAE | SC_OPCODE_GET_DATE_VALUE | Date&Time | Returns an internal number for a text having a possible date format. | m4sFj | HID_FUNC_DATWERT | Returns the internal date number for text in quotes.The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates.If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion. |
| DAVERAGE | sFv2D | SC_OPCODE_DB_AVERAGE | Database | Returns the average value of all the cells of a data range whose contents match the search criteria. | NbPgQ | HID_FUNC_DBMITTELWERT | DAVERAGE returns the average of the values of all cells (fields) in all rows (database records) that match the specified search criteria. |
| DAY | FRbna | SC_OPCODE_GET_DAY | Date&Time | Returns the sequential date of the month as an integer (1-31) in relation to the date value. | RNiJ8 | HID_FUNC_TAG | Returns the day of given date value. The day is returned as an integer between 1 and 31. You can also enter a negative date/time value. |
| DAYS360 | YwiBE | SC_OPCODE_GET_DIFF_DATE_360 | Date&Time | Calculates the number of days between two dates based on a 360-day year. | kAGux | HID_FUNC_TAGE360 | Returns the difference between two dates based on the 360 day year used in interest calculations. |
| DAYS | hhwRD | SC_OPCODE_GET_DIFF_DATE | Date&Time | Calculates the number of days between two dates. | XukFr | HID_FUNC_TAGE | Calculates the difference between two date values. The result returns the number of days between the two days. |
| DAYSINMONTH | EpbA3 | DATE_FUNCNAME_DaysInMonth | Date&Time | Returns the number of days of the month in which the date entered occurs | KQLCb | HID_DAI_FUNC_DAYSINMONTH | Calculates the number of days of the month in which the date entered occurs. |
| DAYSINYEAR | vE7vk | DATE_FUNCNAME_DaysInYear | Date&Time | Returns the number of days of the year in which the date entered occurs. | KCA2C | HID_DAI_FUNC_DAYSINYEAR | Calculates the number of days of the year in which the date entered occurs. |
| DB | qEGVA | SC_OPCODE_DB | Financial | Returns the real depreciation of an asset for a specified period using the fixed-declining balance method. | 75CYS | HID_FUNC_GDA2 | Returns the depreciation of an asset for a specified period using the fixed-declining balance method.This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost. |
| DCOUNTA | pbuDP | SC_OPCODE_DB_COUNT_2 | Database | Counts all non-blank cells of a data range where the content corresponds to the search criteria. | cDBru | HID_FUNC_DBANZAHL2 | DCOUNTA counts the number of rows (records) in a database that match the specified search conditions, and contain numeric or alphanumeric values. |
| DCOUNT | Ki73f | SC_OPCODE_DB_COUNT | Database | Counts the cells of a data range whose contents match the search criteria. | VsGEd | HID_FUNC_DBANZAHL | DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values. |
| DDB | 2NiJm | SC_OPCODE_DDB | Financial | Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor. | 7fgyK | HID_FUNC_GDA | Returns the depreciation of an asset for a specified period using the arithmetic-declining method.Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type. |
| DDE | u8rph | SC_OPCODE_DDE | Spredsheet | Result of a DDE link. | gqbNa | HID_FUNC_DDE | Returns the result of a DDE-based link. If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose Edit - Links to see the updated links. Cross-platform links, for example from a %PRODUCTNAME installation running on a Windows machine to a document created on a Linux machine, are not allowed. |
| DEC2BIN | AJC9F | ANALYSIS_FUNCNAME_Dec2Bin | Add-in | Converts a decimal number to a binary number | gtNKg | HID_AAI_FUNC_DEC2BIN | The result is the binary number for the decimal number entered between -512 and 511. |
| DEC2HEX | bpBJG | ANALYSIS_FUNCNAME_Dec2Hex | Add-in | Converts a decimal number to a hexadecimal number | LDwCT | HID_AAI_FUNC_DEC2HEX | The result is the hexadecimal number for the decimal number entered. |
| DEC2OCT | dnxfS | ANALYSIS_FUNCNAME_Dec2Oct | Add-in | Converts a decimal number into an octal number | JVcUH | HID_AAI_FUNC_DEC2OCT | The result is the octal number for the decimal number entered. |
| DECIMAL | goMvh | SC_OPCODE_DECIMAL | Text | Converts a text of a specified number system to a positive integer in the base given. | eJbXN | HID_FUNC_DEZIMAL | Converts text with characters from a number system to a positive integer in the base radix given. The radix must be in the range 2 to 36. Spaces and tabs are ignored. The Text field is not case-sensitive.If the radix is 16, a leading x or X or 0x or 0X, and an appended h or H, is disregarded. If the radix is 2, an appended b or B is disregarded. Other characters that do not belong to the number system generate an error. |
| DEGREES | yCbKX | SC_OPCODE_DEG | Mathematical | Converts a radian to degrees | uUqNJ | HID_FUNC_DEG | Converts radians into degrees. |
| DELTA | PHzDg | ANALYSIS_FUNCNAME_Delta | Add-in | Tests whether two values are equal | vXJmG | HID_AAI_FUNC_DELTA | The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0). |
| DEVSQ | Eb2Zz | SC_OPCODE_DEV_SQ | Statistic | Returns the sum of squares of deviations from the sample mean value | mNGPN | HID_FUNC_SUMQUADABW | Returns the sum of squares of deviations based on a sample mean. |
| DGET | MiUzt | SC_OPCODE_DB_GET | Database | Defines the contents of the cell of a data range which matches the search criteria. | 6TEYK | HID_FUNC_DBAUSZUG | DGET returns the contents of the referenced cell in a database which matches the specified search criteria. In case of an error, the function returns either #VALUE! for no row found, or Err502 for more than one cell found. |
| DISC | 6HHZX | ANALYSIS_FUNCNAME_Disc | Financial | Returns the discount rate for a security | SDipc | HID_AAI_FUNC_DISC | Calculates the allowance (discount) of a security as a percentage. |
| DMAX | vwF4A | SC_OPCODE_DB_MAX | Database | Returns the maximum value from all of the cells of a data range which correspond to the search criteria. | RBaed | HID_FUNC_DBMAX | DMAX returns the maximum content of a cell (field) in a database (all records) that matches the specified search conditions. |
| DMIN | D2cmF | SC_OPCODE_DB_MIN | Database | Returns the minimum of all cells of a data range where the contents correspond to the search criteria. | Yre9V | HID_FUNC_DBMIN | DMIN returns the minimum content of a cell (field) in a database that matches the specified search criteria. |
| DOLLARDE | b3c5F | ANALYSIS_FUNCNAME_Dollarde | Financial | Converts a price expressed as a fraction into a price expressed as a decimal | hdkeU | HID_AAI_FUNC_DOLLARDE | Converts a quotation that has been given as a decimal fraction into a decimal number. |
| DOLLAR | ePTF3 | SC_OPCODE_CURRENCY | Text | Converts a number to text in currency format. | DWHUQ | HID_FUNC_DM | Converts a number to an amount in the currency format, rounded to a specified decimal place. In the Value field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the Decimals field. If no value is specified, all numbers in currency format will be displayed with two decimal places. You set the currency format in your system settings. |
| DOLLARFR | tCGEv | ANALYSIS_FUNCNAME_Dollarfr | Financial | Converts a price expressed as a decimal into a price expressed as a fraction | ACBda | HID_AAI_FUNC_DOLLARFR | Converts a quotation that has been given as a decimal number into a mixed decimal fraction. |
| DPRODUCT | wNEKA | SC_OPCODE_DB_PRODUCT | Database | Multiplies all cells of a data range where the contents match the search criteria. | xoQcY | HID_FUNC_DBPRODUKT | DPRODUCT multiplies all cells of a data range where the cell contents match the search criteria. |
| DSTDEV | GkFgg | SC_OPCODE_DB_STD_DEV | Database | Calculates the standard deviation of all cells in a data range whose contents match the search criteria. | GsfN3 | HID_FUNC_DBSTDABW | DSTDEV calculates the standard deviation of a population based on a sample, using the numbers in a database column that match the given conditions. The records are treated as a sample of data. That means that the children in the example represent a cross section of all children. Note that a representative result can not be obtained from a sample of less than one thousand. |
| DSTDEVP | B5Asm | SC_OPCODE_DB_STD_DEV_P | Database | Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria. | Lso9G | HID_FUNC_DBSTDABWN | DSTDEVP calculates the standard deviation of a population based on all cells of a data range which match the search criteria. The records from the example are treated as the whole population. |
| DSUM | JMnY3 | SC_OPCODE_DB_SUM | Database | Adds all the cells of a data range where the contents match the search criteria. | 2tqZB | HID_FUNC_DBSUMME | DSUM returns the total of all cells in a database field in all rows (records) that match the specified search criteria. |
| DURATION | dWbXN | SC_OPCODE_DURATION | Financial | Duration. Calculates the number of periods required by an investment to attain the desired value. | qNyVY | HID_FUNC_LAUFZEIT | Calculates the number of periods required by an investment to attain the desired value. |
| DURATION_ADD | ET83v | ANALYSIS_FUNCNAME_Duration | Financial | Returns the annual Macaulay duration of a security with periodic interest payments | Y9aav | HID_AAI_FUNC_DURATION | Calculates the duration of a fixed interest security in years. |
| DVAR | gDAC9 | SC_OPCODE_DB_VAR | Database | Determines the variance of all the cells in a data range where the contents match the search criteria. | Sb7GE | HID_FUNC_DBVARIANZ | DVAR returns the variance of all cells of a database field in all records that match the specified search criteria. The records from the example are treated as a sample of data. A representative result cannot be obtained from a sample population of less than one thousand. |
| DVARP | DSrRy | SC_OPCODE_DB_VAR_P | Database | Determines variance of a population based on all cells in a data range where contents match the search criteria. | waGkD | HID_FUNC_DBVARIANZEN | DVARP calculates the variance of all cell values in a database field in all records that match the specified search criteria. The records are from the example are treated as an entire population. |
| EASTERSUNDAY | fALre | SC_OPCODE_EASTERSUNDAY | Date&Time | Calculates the date of Easter Sunday in a given year. | oeEyF | HID_FUNC_OSTERSONNTAG | Returns the date of Easter Sunday for the entered year. |
| EDATE | RnTE8 | ANALYSIS_FUNCNAME_Edate | Date&Time | Returns the serial number of the date that is a specified number of months before or after the start date | Au76P | HID_AAI_FUNC_EDATE | The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation. |
| EFFECTIVE | gVp6j | SC_OPCODE_EFFECTIVE | Financial | Calculates the annual net interest rate for a nominal interest rate. | CVX9Y | HID_FUNC_EFFEKTIV | Returns the net annual interest rate for a nominal interest rate.Nominal interest refers to the amount of interest due at the end of a calculation period. Effective interest increases with the number of payments made. In other words, interest is often paid in installments (for example, monthly or quarterly) before the end of the calculation period. |
| EFFECT | zCxoq | ANALYSIS_FUNCNAME_Effect | Financial | Returns the effective annual interest rate | FMyAB | HID_AAI_FUNC_EFFECT | Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum. |
| ENCODEURL | dZjWi | SC_OPCODE_ENCODEURL | Text | Return a URL-encoded string. | avFqs | HID_FUNC_ENCODEURL | |
| EOMONTH | hGiQU | ANALYSIS_FUNCNAME_Eomonth | Date&Time | Returns the serial number of the last day of the month that comes a certain number of months before or after the start date | MEBN5 | HID_AAI_FUNC_EOMONTH | Returns the date of the last day of a month which falls months away from the start date. |
| ERFC | 7CPZS | ANALYSIS_FUNCNAME_Erfc | Add-in | Returns the complementary error function | Wgmmu | HID_AAI_FUNC_ERFC | Returns complementary values of the Gaussian error integral between x and infinity. |
| ERFC.PRECISE | JWput | SC_OPCODE_ERFC_MS | Statistic | Returns the complementary error function. | qwvp7 | HID_FUNC_ERFC_MS | Returns complementary values of the Gaussian error integral between x and infinity. |
| ERF.PRECISE | ag8sa | SC_OPCODE_ERF_MS | Statistic | Returns the error function. | CnNKg | HID_FUNC_ERF_MS | Returns values of the Gaussian error integral. |
| ERF | WFFDC | ANALYSIS_FUNCNAME_Erf | Add-in | Returns the error function | L672d | HID_AAI_FUNC_ERF | Returns values of the Gaussian error integral. |
| ERROR.TYPE | HeuD3 | SC_OPCODE_ERROR_TYPE_ODF | Spredsheet | Returns a number corresponding to one of the error values or #N/A if no error exists | e5jFF | HID_FUNC_ERROR_TYPE_ODF | Returns a number representing a specific Error type, or the error value #N/A, if there is no error. |
| ERRORTYPE | yXFM2 | SC_OPCODE_ERROR_TYPE | Spredsheet | Returns a number corresponding to an error type | HPTun | HID_FUNC_FEHLERTYP | Returns the number corresponding to an error value occurring in a different cell. With the aid of this number, you can generate an error message text.The Status Bar displays the predefined error code from %PRODUCTNAME if you click the cell containing the error. |
| EUROCONVERT | pNTAf | SC_OPCODE_EUROCONVERT | Mathematical | Converts a value from one to another Euro currency. | n9aTe | HID_FUNC_UMRECHNEN | Converts between old European national currency and to and from Euros. |
| EVEN | nUDpu | SC_OPCODE_EVEN | Mathematical | Rounds a positive number up and negative number down to the nearest even integer. | 3xVxu | HID_FUNC_GERADE | Rounds a positive number up to the next even integer and a negative number down to the next even integer. |
| EXACT | B4ABV | SC_OPCODE_EXACT | Text | Specifies whether two texts are identical. | bVKb7 | HID_FUNC_IDENTISCH | Compares two text strings and returns TRUE if they are identical. This function is case-sensitive. |
| EXP | oBARu | SC_OPCODE_EXP | Mathematical | Calculates the exponent for basis e. | kC3EP | HID_FUNC_EXP | Returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904. |
| EXPONDIST | ESWiB | SC_OPCODE_EXP_DIST | Statistic | Values of the exponential distribution. | CF96U | HID_FUNC_EXPONVERT | Returns the exponential distribution. |
| EXPON.DIST | wPEE8 | SC_OPCODE_EXP_DIST_MS | Statistic | Values of the exponential distribution. | scD8c | HID_FUNC_EXP_DIST_MS | Returns the exponential distribution. |
| FACT | 63eDf | SC_OPCODE_FACT | Mathematical | Calculates the factorial of a number. | odv6Q | HID_FUNC_FAKULTAET | Returns the factorial of a number. |
| FACTDOUBLE | CjDvf | ANALYSIS_FUNCNAME_Factdouble | Add-in | Returns the double factorial of Number | 6eGE3 | HID_AAI_FUNC_FACTDOUBLE | Returns the double factorial of a number. |
| FALSE | 5S9cg | SC_OPCODE_FALSE | Logical | Defines the logical value as FALSE. | qTShX | HID_FUNC_FALSCH | Returns the logical value FALSE. The FALSE() function does not require any arguments, and always returns the logical value FALSE. |
| FDIST | dmAuA | SC_OPCODE_F_DIST | Statistic | Values of the F probability distribution. | 2X79n | HID_FUNC_FVERT | Calculates the values of an F distribution. |
| F.DIST | dmRFE | SC_OPCODE_F_DIST_LT | Statistic | Values of the left tail F probability distribution. | E42MZ | HID_FUNC_F_DIST_LT | Calculates the values of the left tail of the F distribution. |
| F.DIST.RT | 6z2D9 | SC_OPCODE_F_DIST_RT | Statistic | Values of the right tail F probability distribution. | 2eDJN | HID_FUNC_F_DIST_RT | Calculates the values of the right tail of the F distribution. |
| FILTERXML | YeUQA | SC_OPCODE_FILTERXML | Text | Apply an XPath expression to an XML document | weAoH | HID_FUNC_FILTERXML | Apply a XPath expression to a XML document. |
| FIND | vXgZT | SC_OPCODE_FIND | Text | Looks for a string of text within another (case sensitive) | E4kAw | HID_FUNC_FINDEN | Looks for a string of text within another string. You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive. |
| F.INV | D5h4W | SC_OPCODE_F_INV_LT | Statistic | Values of the inverse left tail F distribution. | hanKj | HID_FUNC_F_INV_LT | Returns the inverse of the cumulative F distribution. The F distribution is used for F tests in order to set the relation between two differing data sets. |
| FINV | KpTGm | SC_OPCODE_F_INV | Statistic | Values of the inverse F distribution. | CpWtd | HID_FUNC_FINV | Returns the inverse of the F probability distribution. The F distribution is used for F tests in order to set the relation between two differing data sets. |
| F.INV.RT | GDWRs | SC_OPCODE_F_INV_RT | Statistic | Values of the inverse right tail F distribution. | RuPGx | HID_FUNC_F_INV_RT | Returns the inverse right tail of the F distribution. |
| FISHER | CFRXx | SC_OPCODE_FISHER | Statistic | Returns the Fisher transformation. | KyKqX | HID_FUNC_FISHER | Returns the Fisher transformation for x and creates a function close to a normal distribution. |
| FISHERINV | kAD5g | SC_OPCODE_FISHER_INV | Statistic | Returns the inverse of the Fisher transformation. | 9FitE | HID_FUNC_FISHERINV | Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution. |
| FIXED | xk7yW | SC_OPCODE_FIXED | Text | Formats a number with a fixed number of places after the decimal point and thousands separator. | GvxKV | HID_FUNC_FEST | Returns a number as text with a specified number of decimal places and optional thousands separators. |
| FLOOR.MATH | gmD4Q | SC_OPCODE_FLOOR_MATH | Mathematical | Rounds number down to the nearest multiple of significance, regardless of sign of significance. | BAQbD | HID_FUNC_FLOOR_MATH | |
| FLOOR.PRECISE | nhi9Y | SC_OPCODE_FLOOR_PRECISE | Mathematical | Rounds number down (towards -∞) to the nearest multiple of significance. | 6hRjb | HID_FUNC_FLOOR_MS | Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance |
| FLOOR.XCL | ur29F | SC_OPCODE_FLOOR_MS | Mathematical | Rounds number towards zero to the nearest multiple of absolute value of significance. | Wq2vB | HID_FUNC_FLOOR_MS | Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance |
| FLOOR | ycZvf | SC_OPCODE_FLOOR | Mathematical | Rounds number down to the nearest multiple of significance. | Cd6yK | HID_FUNC_UNTERGRENZE | Rounds a number down to the nearest multiple of Significance. |
| FORECAST | 8Zckp | SC_OPCODE_FORECAST | Statistic | Returns a value along a linear regression | A68Mx | HID_FUNC_SCHAETZER | Extrapolates future values based on existing x and y values. |
| FORMULA | EEoqA | SC_OPCODE_FORMULA | Infirmation | Returns the formula of a formula cell. | yoMKF | HID_FUNC_FORMEL | Displays the formula of a formula cell as a text string. |
| FREQUENCY | foFR3 | SC_OPCODE_FREQUENCY | Array | Returns a frequency distribution as a vertical array. | BELFH | HID_FUNC_HAEUFIGKEIT | Indicates the frequency distribution in a one-column-array. The function counts the number of values in the Data array that are within the values given by the Classes array. |
| FTEST | CjLQQ | SC_OPCODE_F_TEST | Statistic | Calculates the F test. | dePC4 | HID_FUNC_FTEST | Returns the result of an F test. |
| F.TEST | QNR53 | SC_OPCODE_F_TEST_MS | Statistic | Calculates the F test. | mzJDV | HID_FUNC_F_TEST_MS | Returns the result of an F test. |
| FV | aUTgn | SC_OPCODE_FV | Financial | Future value. Returns the future value of an investment based on regular payments and a constant interest rate. | VqcWE | HID_FUNC_ZW | Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). |
| FVSCHEDULE | PAGij | ANALYSIS_FUNCNAME_Fvschedule | Financial | Returns the future value of the initial principal after a series of compound interest rates are applied | BkVLD | HID_AAI_FUNC_FVSCHEDULE | Calculates the accumulated value of the starting capital for a series of periodically varying interest rates. |
| GAMMA.DIST | DqBcB | SC_OPCODE_GAMMA_DIST_MS | Statistic | Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. | LGjCq | HID_FUNC_GAMMADIST_MS | Returns the values of a Gamma distribution.The inverse function is GAMMAINV or GAMMA.INV.This function is identical to GAMMADIST and was introduced for interoperability with other office suites. |
| GAMMADIST | dvuum | SC_OPCODE_GAMMA_DIST | Statistic | Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. | UnLUe | HID_FUNC_GAMMAVERT | Returns the values of a Gamma distribution.The inverse function is GAMMAINV. |
| GAMMA | H7fbR | SC_OPCODE_GAMMA | Statistic | Returns the value of the Gamma function. | JMBWT | HID_FUNC_GAMMA | Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST. |
| GAMMAINV | AweKA | SC_OPCODE_GAMMA_INV | Statistic | Values of the inverse gamma distribution. | 3LLhe | HID_FUNC_GAMMAINV | Returns the inverse of the Gamma cumulative distribution GAMMADIST. This function allows you to search for variables with different distribution. |
| GAMMA.INV | mAyMR | SC_OPCODE_GAMMA_INV_MS | Statistic | Values of the inverse gamma distribution. | A4Vt8 | HID_FUNC_GAMMAINV_MS | Returns the inverse of the Gamma cumulative distribution GAMMADIST. This function allows you to search for variables with different distribution.This function is identical to GAMMAINV and was introduced for interoperability with other office suites. |
| GAMMALN | 47Wom | SC_OPCODE_GAMMA_LN | Statistic | Returns the natural logarithm of the gamma function. | VzGA5 | HID_FUNC_GAMMALN | Returns the natural logarithm of the Gamma function: G(x). |
| GAMMALN.PRECISE | BFK3d | SC_OPCODE_GAMMA_LN_MS | Statistic | Returns the natural logarithm of the gamma function. | V4A8G | HID_FUNC_GAMMALN_MS | Returns the natural logarithm of the Gamma function: G(x). |
| GAUSS | MtbiB | SC_OPCODE_GAUSS | Statistic | Returns the integral values of the standard normal cumulative distribution. | 6ucMp | HID_FUNC_GAUSS | Returns the standard normal cumulative distribution.It is GAUSS(x)=NORMSDIST(x)-0.5 |
| GCD | xpVGW | SC_OPCODE_GCD | Mathematical | Greatest Common Divisor | RDCaG | HID_FUNC_GGT | Returns the greatest common divisor of two or more integers.The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers. |
| GCD | yLkFC | ANALYSIS_FUNCNAME_Gcd | Mathematical | Returns the greatest common divisor | 7pTXG | HID_AAI_FUNC_GCD | The result is the greatest common divisor of a list of numbers. |
| GEOMEAN | JBD4c | SC_OPCODE_GEO_MEAN | Statistic | Returns the geometric mean of a sample. | RhMtG | HID_FUNC_GEOMITTEL | Returns the geometric mean of a sample. |
| GESTEP | YAJQK | ANALYSIS_FUNCNAME_Gestep | Add-in | Tests whether a number is greater than a threshold value | DBz3C | HID_AAI_FUNC_GESTEP | The result is 1 if Number is greater than or equal to Step. |
| GETPIVOTDATA | EKASF | SC_OPCODE_GET_PIVOT_DATA | Spredsheet | Extracts value(s) from a pivot table. | qgZQo | HID_FUNC_GETPIVOTDATA | The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes. |
| GROWTH | swew9 | SC_OPCODE_GROWTH | Array | Calculates points on the exponential regression function. | yhD7j | HID_FUNC_VARIATION | Calculates the points of an exponential trend in an array. |
| HARMEAN | GA7EK | SC_OPCODE_HAR_MEAN | Statistic | Returns the harmonic mean of a sample. | LACxG | HID_FUNC_HARMITTEL | Returns the harmonic mean of a data set. |
| HEX2BIN | B2YNX | ANALYSIS_FUNCNAME_Hex2Bin | Add-in | Converts a hexadecimal number to a binary number | sC97t | HID_AAI_FUNC_HEX2BIN | The result is the binary number for the hexadecimal number entered. |
| HEX2DEC | kNsKk | ANALYSIS_FUNCNAME_Hex2Dec | Add-in | Converts a hexadecimal number to a decimal number | GBDrZ | HID_AAI_FUNC_HEX2DEC | The result is the decimal number for the hexadecimal number entered. |
| HEX2OCT | jfDsA | ANALYSIS_FUNCNAME_Hex2Oct | Add-in | Converts a hexadecimal number to an octal number | CGBvb | HID_AAI_FUNC_HEX2OCT | The result is the octal number for the hexadecimal number entered. |
| HLOOKUP | 7vEBg | SC_OPCODE_H_LOOKUP | Spredsheet | Horizontal search and reference to the cells located below. | VSPJT | HID_FUNC_WVERWEIS | Searches for a value and reference to the cells below the selected area. This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the Index, in the same column. |
| HOUR | PebmG | SC_OPCODE_GET_HOUR | Date&Time | Determines the sequential number of the hour of the day (0-23) for the time value. | kDrEv | HID_FUNC_STUNDE | Returns the hour for a given time value. The hour is returned as an integer between 0 and 23. |
| HYPERLINK | BGYYE | SC_OPCODE_HYPERLINK | Spredsheet | Hyperlink. | G4psC | HID_FUNC_HYPERLINK | When you click a cell that contains the HYPERLINK function, the hyperlink opens.If you use the optional CellText parameter, the formula locates the URL, and then displays the text or number.To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose Open Hyperlink. |
| HYPGEOM.DIST | 5YjEL | SC_OPCODE_HYP_GEOM_DIST_MS | Statistic | Values of the hypergeometric distribution. | Ffnd2 | HID_FUNC_HYP_GEOM_DIST_MS | Returns the hypergeometric distribution. |
| HYPGEOMDIST | q9nkE | SC_OPCODE_HYP_GEOM_DIST | Statistic | Values of the hypergeometric distribution. | 74FiH | HID_FUNC_HYPGEOMVERT | Returns the hypergeometric distribution. |
| IFERROR | 8cpho | SC_OPCODE_IF_ERROR | Logical | Returns value if not an error value, else alternative. | kmGEE | HID_FUNC_IFERROR | Returns the value if the cell does not contains an error value, or the alternative value if it does. |
| IFNA | dRpWD | SC_OPCODE_IF_NA | Logical | Returns value if not a #N/A error, else alternative. | Fxkga | HID_FUNC_IFNA | Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does. |
| IF | RHSqm | SC_OPCODE_IF | Logical | Specifies a logical test to be performed. | QAFnh | HID_FUNC_WENN | Specifies a logical test to be performed. |
| IMABS | FBn6B | ANALYSIS_FUNCNAME_Imabs | Add-in | Returns the absolute value (modulus) of a complex number | Kv6Gh | HID_AAI_FUNC_IMABS | The result is the absolute value of a complex number. |
| IMAGINARY | QYDVB | ANALYSIS_FUNCNAME_Imaginary | Add-in | Returns the imaginary coefficient of a complex number | dsEFU | HID_AAI_FUNC_IMAGINARY | The result is the imaginary coefficient of a complex number. |
| IMARGUMENT | J8V8z | ANALYSIS_FUNCNAME_Imargument | Add-in | Returns the argument theta, an angle expressed in radians | sgsXU | HID_AAI_FUNC_IMARGUMENT | The result is the argument (the phi angle) of a complex number. |
| IMCONJUGATE | iqoX7 | ANALYSIS_FUNCNAME_Imconjugate | Add-in | Returns the complex conjugate of a complex number | 6NpYd | HID_AAI_FUNC_IMCONJUGATE | The result is the conjugated complex complement to a complex number. |
| IMCOSH | ErNKG | ANALYSIS_FUNCNAME_Imcosh | Add-in | Returns the hyperbolic cosine of a complex number | cyJtB | HID_AAI_FUNC_IMCOSH | The function returns the hyperbolic cosine of a complex number in the a+bi or a+bj text format. |
| IMCOS | QBnyT | ANALYSIS_FUNCNAME_Imcos | Add-in | Returns the cosine of a complex number | 9BMRu | HID_AAI_FUNC_IMCOS | The function returns the cosine of a complex number in the a+bi or a+bj text format. |
| IMCOT | k2mSC | ANALYSIS_FUNCNAME_Imcot | Add-in | Returns the cotangent of a complex number | EyNFt | HID_AAI_FUNC_IMCOT | The function returns the cotangent of a complex number in the a+bi or a+bj text format. |
| IMCSCH | Gk9GH | ANALYSIS_FUNCNAME_Imcsch | Add-in | Returns the hyperbolic cosecant of a complex number | AaL4p | HID_AAI_FUNC_IMCSCH | The function returns the hyperbolic cosecant of a complex number in the a+bi or a+bj text format. |
| IMCSC | tFG7J | ANALYSIS_FUNCNAME_Imcsc | Add-in | Returns the cosecant of a complex number | PrEHE | HID_AAI_FUNC_IMCSC | The function returns the cosecant of a complex number in the a+bi or a+bj text format. |
| IMDIV | RhiUy | ANALYSIS_FUNCNAME_Imdiv | Add-in | Returns the quotient of two complex numbers | mSsaT | HID_AAI_FUNC_IMDIV | The result is the division of two complex numbers. |
| IMEXP | WAfnR | ANALYSIS_FUNCNAME_Imexp | Add-in | Returns the algebraic form of the exponential of a complex number | bwWr4 | HID_AAI_FUNC_IMEXP | The result is the power of e and the complex number. The constant e has a value of approximately 2.71828182845904. |
| IMLN | Sc6mT | ANALYSIS_FUNCNAME_Imln | Add-in | Returns the natural logarithm of a complex number | nW87F | HID_AAI_FUNC_IMLN | The result is the natural logarithm (to the base e) of a complex number. The constant e has a value of approximately 2.71828182845904. |
| IMLOG10 | MNkNW | ANALYSIS_FUNCNAME_Imlog10 | Add-in | Returns the base-10 logarithm of a complex number | FUpg6 | HID_AAI_FUNC_IMLOG10 | The result is the common logarithm (to the base 10) of a complex number. |
| IMLOG2 | GABGC | ANALYSIS_FUNCNAME_Imlog2 | Add-in | Returns the base-2 logarithm of a complex number | EXBBs | HID_AAI_FUNC_IMLOG2 | The result is the binary logarithm of a complex number. |
| IMPOWER | GGQs6 | ANALYSIS_FUNCNAME_Impower | Add-in | Returns a complex number raised to a real power | 66PGj | HID_AAI_FUNC_IMPOWER | The result is the ComplexNumber raised to the power of Number. |
| IMPRODUCT | KcP8D | ANALYSIS_FUNCNAME_Improduct | Add-in | Returns the product of several complex numbers | 5VA5w | HID_AAI_FUNC_IMPRODUCT | The result is the product of up to 29 complex numbers. |
| IMREAL | XxrtP | ANALYSIS_FUNCNAME_Imreal | Add-in | Returns the real coefficient of a complex number | rQyiX | HID_AAI_FUNC_IMREAL | The result is the real coefficient of a complex number. |
| IMSECH | BZqDR | ANALYSIS_FUNCNAME_Imsech | Add-in | Returns the hyperbolic secant of a complex number | E2PFF | HID_AAI_FUNC_IMSECH | The function returns the hyperbolic secant of a complex number in the a+bi or a+bj text format. |
| IMSEC | p2cPB | ANALYSIS_FUNCNAME_Imsec | Add-in | Returns the secant of a complex number | X6woF | HID_AAI_FUNC_IMSEC | The function returns the secant of a complex number in the a+bi or a+bj text format. |
| IMSIN | ChCKv | ANALYSIS_FUNCNAME_Imsin | Add-in | Returns the sine of a complex number | QPDkx | HID_AAI_FUNC_IMSIN | The function returns the sine of a complex number in the a+bi or a+bj text format. |
| IMSINH | ZwUUB | ANALYSIS_FUNCNAME_Imsinh | Add-in | Returns the hyperbolic sine of a complex number | myVrC | HID_AAI_FUNC_IMSINH | The function returns the hyperbolic sine of a complex number in the a+bi or a+bj text format. |
| IMSQRT | on4GJ | ANALYSIS_FUNCNAME_Imsqrt | Add-in | Returns the square root of a complex number | xkwz7 | HID_AAI_FUNC_IMSQRT | The result is the square root of a complex number. |
| IMSUB | WSpWr | ANALYSIS_FUNCNAME_Imsub | Add-in | Returns the difference of two complex numbers | pCwcH | HID_AAI_FUNC_IMSUB | The result is the subtraction of two complex numbers. |
| IMSUM | 5dggL | ANALYSIS_FUNCNAME_Imsum | Add-in | Returns the sum of complex numbers | uSe75 | HID_AAI_FUNC_IMSUM | The result is the sum of up to 29 complex numbers. |
| IMTAN | kMNhg | ANALYSIS_FUNCNAME_Imtan | Add-in | Returns the tangent of a complex number | YZ9Pk | HID_AAI_FUNC_IMTAN | The function returns the tangent of a complex number in the a+bi or a+bj text format. |
| INDEX | BUBxc | SC_OPCODE_INDEX | Spredsheet | Returns a reference to a cell from a defined range. | 8f5Lt | HID_FUNC_INDEX | INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content.UFI: will change with i4904; see http://so-web.germany.sun.com/iBIS/servlet/edit.ControlPanel?tid=i57108changed by i83070 |
| INDIRECT | FVZhG | SC_OPCODE_INDIRECT | Spredsheet | Returns the contents of a cell that is referenced in text form. | oG2ao | HID_FUNC_INDIREKT | Returns the reference specified by a text string. This function can also be used to return the area of a corresponding string. |
| INFO | uNRvf | SC_OPCODE_INFO | Infirmation | Returns information about the environment. | PwsEc | HID_FUNC_INFO | https://bugs.documentfoundation.org/show_bug.cgi?id=95010 |
| INT | DXYe4 | SC_OPCODE_INT | Mathematical | Rounds a number down to the nearest integer. | bSPVD | HID_FUNC_GANZZAHL | Rounds a number down to the nearest integer. |
| INTERCEPT | 67rvU | SC_OPCODE_INTERCEPT | Statistic | Returns the intercept of the linear regression line and the Y axis. | w3Fyh | HID_FUNC_ACHSENABSCHNITT | Calculates the point at which a line will intersect the y-values by using known x-values and y-values. |
| INTRATE | 8P3JL | ANALYSIS_FUNCNAME_Intrate | Financial | Returns the interest rate for a fully invested security | nBr2f | HID_AAI_FUNC_INTRATE | Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid. |
| IPMT | fCURS | SC_OPCODE_IPMT | Financial | Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period. | SGA4a | HID_FUNC_ZINSZ | Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. |
| IRR | hwCoX | SC_OPCODE_IRR | Financial | Returns the actuarial rate of interest of an investment excluding costs or profits. | 49dji | HID_FUNC_IKV | Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income). |
| ISBLANK | pvqAh | SC_OPCODE_IS_EMPTY | Infirmation | Returns TRUE if value refers to an empty cell. | ktJFT | HID_FUNC_ISTLEER | Returns TRUE if the reference to a cell is blank. This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. |
| ISERR | aqLQv | SC_OPCODE_IS_ERR | Infirmation | Returns TRUE if the value is an error value not equal to #N/A. | wuFYe | HID_FUNC_ISTFEHL | Tests for error conditions, except the #N/A error value, and returns TRUE or FALSE. |
| ISERROR | oBaLE | SC_OPCODE_IS_ERROR | Infirmation | Returns TRUE if the value is an error value. | 7ANAd | HID_FUNC_ISTFEHLER | Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE. |
| ISEVEN | 8zjDt | ANALYSIS_FUNCNAME_Iseven | Infirmation | Returns the value 'true' if the number is even | euGgs | HID_AAI_FUNC_ISEVEN | Tests for even numbers. Returns 1 if the number divided by 2 returns a whole number. |
| ISEVEN | Ar3BU | SC_OPCODE_IS_EVEN | Infirmation | Returns TRUE if value is an even integer. | LUFep | HID_FUNC_ISTGERADE | Returns TRUE if the value is an even integer, or FALSE if the value is odd. |
| ISFORMULA | mkExD | SC_OPCODE_IS_FORMULA | Infirmation | Returns TRUE if the cell is a formula cell. | CSGLS | HID_FUNC_ISTFORMEL | Returns TRUE if a cell is a formula cell. |
| ISLEAPYEAR | Qwaut | DATE_FUNCNAME_IsLeapYear | Date&Time | Returns 1 (TRUE) if the date is a day of a leap year, otherwise 0 (FALSE). | kt3PZ | HID_DAI_FUNC_ISLEAPYEAR | (WIRNING!!!) Determines whether a year is a leap year.</ahelp> If yes, the function will return the value 1 (TRUE); if not, it will return 0 (FALSE). |
| ISLOGICAL | 58WAk | SC_OPCODE_IS_LOGICAL | Infirmation | Returns TRUE if the value carries a logical number format. | CGCT4 | HID_FUNC_ISTLOG | Tests for a logical value (TRUE or FALSE).If an error occurs, the function returns FALSE. |
| ISNA | KE9aD | SC_OPCODE_IS_NV | Infirmation | Returns TRUE if value equals #N/A. | ho9E8 | HID_FUNC_ISTNV | Returns TRUE if a cell contains the #N/A (value not available) error value.If an error occurs, the function returns FALSE. |
| ISNONTEXT | D2qcE | SC_OPCODE_IS_NON_STRING | Infirmation | Returns TRUE if the value is not text. | fVpVN | HID_FUNC_ISTKTEXT | Tests if the cell contents are text or numbers, and returns FALSE if the contents are text.If an error occurs, the function returns TRUE. |
| ISNUMBER | 7UAED | SC_OPCODE_IS_VALUE | Infirmation | Returns TRUE if value is a number. | CxKA5 | HID_FUNC_ISTZAHL | Returns TRUE if the value refers to a number. |
| ISO.CEILING | pNr7X | SC_OPCODE_CEIL_ISO | Mathematical | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. | c62ev | HID_FUNC_CEIL_ISO | Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance |
| ISODD | JeDEv | SC_OPCODE_IS_ODD | Infirmation | Returns TRUE if value is an odd integer. | iZpWD | HID_FUNC_ISTUNGERADE | Returns TRUE if the value is odd, or FALSE if the number is even. |
| ISODD | PjGBW | ANALYSIS_FUNCNAME_Isodd | Infirmation | Returns the value 'true' if the number is odd | Eez7w | HID_AAI_FUNC_ISODD | Returns TRUE (1) if the number does not return a whole number when divided by 2. |
| ISPMT | Wc3DB | SC_OPCODE_ISPMT | Financial | Returns the amount of interest for constant amortization rates. | EJUDM | HID_FUNC_ISPMT | Calculates the level of interest for unchanged amortization installments. |
| ISREF | u2cHy | SC_OPCODE_IS_REF | Infirmation | Returns TRUE if value is a reference. | Tm96B | HID_FUNC_ISTBEZUG | Tests if the argument is a reference. Returns TRUE if the argument is a reference, returns FALSE otherwise. When given a reference this function does not examine the value being referenced.i82565 |
| ISTEXT | hLDhs | SC_OPCODE_IS_STRING | Infirmation | Returns TRUE if value is text. | uPGoY | HID_FUNC_ISTTEXT | Returns TRUE if the cell contents refer to text.If an error occurs, the function returns FALSE. |
| JIS | MTzce | SC_OPCODE_JIS | Text | Converts half-width ASCII and katakana characters to full-width. | dUEns | HID_FUNC_JIS | The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string. |
| KURT | SFCc4 | SC_OPCODE_KURT | Statistic | Returns the kurtosis of a distribution. | bdcjD | HID_FUNC_KURT | Returns the kurtosis of a data set (at least 4 values required). |
| LARGE | 7rfBB | SC_OPCODE_LARGE | Statistic | Returns the k-th largest value of a sample. | hCGu4 | HID_FUNC_KGROESSTE | Returns the Rank_c-th largest value in a data set. |
| LCM | xrRGD | ANALYSIS_FUNCNAME_Lcm | Mathematical | Returns the least common multiple | hZczM | HID_AAI_FUNC_LCM | The result is the lowest common multiple of a list of numbers. |
| LCM | yEFDv | SC_OPCODE_LCM | Mathematical | Lowest common multiple | BvcLj | HID_FUNC_KGV | Returns the least common multiple of one or more integers. |
| LEFTB | 4fGGk | SC_OPCODE_LEFTB | Text | Returns the first character or characters of a text,with DBCS | 2MsGE | HID_FUNC_LEFTB | Returns the first characters of a DBCS text. |
| LEFT | XfC9C | SC_OPCODE_LEFT | Text | Returns the first character or characters of a text. | DGXpY | HID_FUNC_LINKS | Returns the first character or characters of a text. |
| LENB | BBhrF | SC_OPCODE_LENB | Text | Calculates length of a text string, with DBCS | fJDAK | HID_FUNC_LENB | For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string. |
| LEN | VbpJi | SC_OPCODE_LEN | Text | Calculates length of a text string. | WAQVo | HID_FUNC_LAENGE | Returns the length of a string including spaces. |
| LINEST | wPMCy | SC_OPCODE_LINEST | Array | Calculates parameters of the linear regression as an array. | 64DGM | HID_FUNC_RGP | Returns a table of statistics for a straight line that best fits a data set.changed based on http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_LINEST_function (issue 76142) |
| LN | nVBzP | SC_OPCODE_LN | Mathematical | Calculates the natural logarithm of a number. | ZkEAK | HID_FUNC_LN | Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904. |
| LOG10 | Wk9UM | SC_OPCODE_LOG10 | Mathematical | Calculates the base-10 logarithm of a number. | aUufD | HID_FUNC_LOG10 | Returns the base-10 logarithm of a number. |
| LOG | 4W5tE | SC_OPCODE_LOG | Mathematical | Calculates the logarithm to any specified base. | 8nCiV | HID_FUNC_LOG | Returns the logarithm of a number to the specified base. |
| LOGEST | TCCBq | SC_OPCODE_LOGEST | Array | Calculates the parameters of the exponential regression curve as an array. | VZFRY | HID_FUNC_RKP | This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).UFI: see http://support.microsoft.com/default.aspx?kbid=828528&product=xl2003for bug #i31051# |
| LOGINV | cSnD5 | SC_OPCODE_LOG_INV | Statistic | Values of the inverse of the lognormal distribution. | YCEDF | HID_FUNC_LOGINV | Returns the inverse of the lognormal distribution. |
| LOGNORM.DIST | BCSQW | SC_OPCODE_LOG_NORM_DIST_MS | Statistic | Values of the log normal distribution. | reByF | HID_FUNC_LOGNORMDIST_MS | Returns the values of a lognormal distribution. |
| LOGNORMDIST | ZQeXb | SC_OPCODE_LOG_NORM_DIST | Statistic | Values of the log normal distribution. | a8hLf | HID_FUNC_LOGNORMVERT | Returns the values of a lognormal distribution. |
| LOGNORM.INV | WuxET | SC_OPCODE_LOG_INV_MS | Statistic | Values of the inverse of the lognormal distribution. | rd23p | HID_FUNC_LOGINV | Returns the inverse of the lognormal distribution. |
| LOOKUP | 2DZCh | SC_OPCODE_LOOKUP | Spredsheet | Determines a value in a vector by comparison to values in another vector. | jfZwG | HID_FUNC_VERWEIS | Returns the contents of a cell either from a one-row or one-column range. Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to VLOOKUP and HLOOKUP, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion. |
| LOWER | MFEFq | SC_OPCODE_LOWER | Text | Converts text to lowercase. | 2ozNP | HID_FUNC_KLEIN | Converts all uppercase letters in a text string to lowercase. |
| MATCH | Uhabt | SC_OPCODE_MATCH | Spredsheet | Defines a position in a array after comparing values. | MtPzx | HID_FUNC_VERGLEICH | Returns the relative position of an item in an array that matches a specified value. The function returns the position of the value found in the lookup_array as a number. |
| MAX | 4KMoz | SC_OPCODE_MAX | Statistic | Returns the maximum value in a list of arguments. | 4LCmn | HID_FUNC_MAX | Returns the maximum value in a list of arguments.Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. |
| MAXA | 7FDpy | SC_OPCODE_MAX_A | Statistic | Returns the maximum value in a list of arguments. Text is evaluated as Zero. | tdkda | HID_FUNC_MAXA | Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. |
| MDETERM | QULda | SC_OPCODE_MAT_DET | Array | Returns the array determinant. | xyDL6 | HID_FUNC_MDET | Returns the array determinant of an array. This function returns a value in the current cell; it is not necessary to define a range for the results. |
| MDURATION | nENuF | ANALYSIS_FUNCNAME_Mduration | Financial | Returns the Macaulay modified duration for a security with an assumed par value of 100 currency units | XB3Cf | HID_AAI_FUNC_MDURATION | Calculates the modified Macauley duration of a fixed interest security in years. |
| MEDIAN | oigFA | SC_OPCODE_MEDIAN | Statistic | Returns the median of a given sample. | DDkUn | HID_FUNC_MEDIAN | Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set. |
| MIDB | famca | SC_OPCODE_MIDB | Text | Returns a partial text string of a text, with DBCS | B5Zd5 | HID_FUNC_MIDB | Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters. |
| MID | ZSgHu | SC_OPCODE_MID | Text | Returns a partial text string of a text. | R9d5z | HID_FUNC_TEIL | Returns a text string of a text. The parameters specify the starting position and the number of characters. |
| MIN | A8sBe | SC_OPCODE_MIN | Statistic | Returns the minimum value in a list of arguments. | qc9kx | HID_FUNC_MIN | Returns the minimum value in a list of arguments.Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. |
| MINA | r4Mtc | SC_OPCODE_MIN_A | Statistic | Returns the smallest value in a list of arguments. Text is evaluated as zero. | PjkQk | HID_FUNC_MINA | Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. |
| MINUTE | LugxT | SC_OPCODE_GET_MIN | Date&Time | Determines the sequential number for the minute of the hour (0-59) for the time value. | 6p5KS | HID_FUNC_MINUTE | Calculates the minute for an internal time value. The minute is returned as a number between 0 and 59. |
| MINVERSE | V3oqd | SC_OPCODE_MAT_INV | Array | Returns the inverse of an array. | Bcdkv | HID_FUNC_MINV | Returns the inverse array. |
| MIRR | AEjoW | SC_OPCODE_MIRR | Financial | Returns the modified internal rate of return for a series of investments. | mkDkF | HID_FUNC_QIKV | Calculates the modified internal rate of return of a series of investments. |
| MMULT | 3BpDd | SC_OPCODE_MAT_MULT | Array | Array multiplication. Returns the product of two arrays. | sJ2Rz | HID_FUNC_MMULT | Calculates the array product of two arrays. The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns. |
| MODE.MULT | kNZzD | SC_OPCODE_MODAL_VALUE_MULTI | Statistic | Returns the most common value in a sample. | KRKQS | HID_FUNC_MODAL_VALUE_MULTI | Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers. |
| MODE.SNGL | LNKre | SC_OPCODE_MODAL_VALUE_MS | Statistic | Returns the most common value in a sample. | sfjKV | HID_FUNC_MODAL_VALUE_MS | Returns the most frequently occurring, or repetitive, value in an array or range of data. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice. |
| MODE | uSC47 | SC_OPCODE_MODAL_VALUE | Statistic | Returns the most common value in a sample. | FTSXU | HID_FUNC_MODALWERT | Returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice. |
| MOD | UqrDX | SC_OPCODE_MOD | Mathematical | Calculates the remainder of a division. | Q3w6r | HID_FUNC_REST | Returns the remainder when one integer is divided by another. |
| MONTH | nFtDb | SC_OPCODE_GET_MONTH | Date&Time | Determines the sequential number of a month of the year (1-12) for the date value. | ZFtrg | HID_FUNC_MONAT | Returns the month for the given date value. The month is returned as an integer between 1 and 12. |
| MONTHS | F5CeW | DATE_FUNCNAME_DiffMonths | Date&Time | Determines the number of months in a specific period. | FqH9T | HID_DAI_FUNC_DIFFMONTHS | Calculates the difference in months between two dates. |
| MROUND | kkrhF | ANALYSIS_FUNCNAME_Mround | Mathematical | Returns a number rounded to a specified multiple | FXVBd | HID_AAI_FUNC_MROUND | Returns a number rounded to the nearest multiple of another number. |
| MULTINOMIAL | Gw9iH | ANALYSIS_FUNCNAME_Multinomial | Mathematical | Returns the multinomial coefficient of a set of numbers | B3DFV | HID_AAI_FUNC_MULTINOMIAL | Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. |
| MUNIT | CmuPA | SC_OPCODE_MATRIX_UNIT | Array | Returns the unitary square array of a certain size. | yBH2y | HID_FUNC_EINHEITSMATRIX | Returns the unitary square array of a certain size. The unitary array is a square array where the main diagonal elements equal 1 and all other array elements are equal to 0. |
| N | 5oZ7J | SC_OPCODE_N | Infirmation | Converts a value to a number. | CAdYx | HID_FUNC_N | Returns the numeric value of the given parameter. Returns 0 if parameter is text or FALSE.If an error occurs the function returns the error value. |
| NA | JNAxh | SC_OPCODE_NO_VALUE | Infirmation | Not available. Returns the error value #N/A. | sLFGW | HID_FUNC_NV | Returns the error value #N/A. |
| NEGBINOMDIST | 7PSNU | SC_OPCODE_NEG_BINOM_VERT | Statistic | Values of the negative binomial distribution. | WK94S | HID_FUNC_NEGBINOMVERT | Returns the negative binomial distribution. |
| NEGBINOM.DIST | kksVD | SC_OPCODE_NEG_BINOM_DIST_MS | Statistic | Values of the negative binomial distribution. | NuXvC | HID_FUNC_NEGBINOMDIST_MS | Returns the negative binomial density or distribution function. |
| NETWORKDAYS | 2s2Ci | ANALYSIS_FUNCNAME_Networkdays | Date&Time | Returns the number of workdays between two dates | FFvBM | HID_AAI_FUNC_NETWORKDAYS | Returns the number of workdays between a start date and an end date. Holidays can be deducted. |
| NETWORKDAYS_ADD | BaoGy | SC_OPCODE_NETWORKDAYS | Date&Time | Returns the number of workdays between two dates using arguments to indicate weekenddays and holidays. | rkTvZ | HID_FUNC_NETWORKDAYS | |
| NETWORKDAYS.INTL | dgGoA | SC_OPCODE_NETWORKDAYS_MS | Date&Time | Returns the number of workdays between two dates using arguments to indicate weekend days and holidays. | FsRxt | HID_FUNC_NETWORKDAYS_MS | |
| NOMINAL | dTciF | ANALYSIS_FUNCNAME_Nominal | Financial | Returns the annual nominal interest rate | Qfqzn | HID_AAI_FUNC_NOMINAL | Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum. |
| NOMINAL | GjP3E | SC_OPCODE_NOMINAL | Financial | Calculates the yearly nominal interest rate as an effective interest rate. | XXBjt | HID_FUNC_NOMINAL | Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year. |
| NORMDIST | 7FGSp | SC_OPCODE_NORM_DIST | Statistic | Values of the normal distribution. | WN45x | HID_FUNC_NORMVERT | Returns the density function or the normal cumulative distribution. |
| NORM.DIST | ASgWk | SC_OPCODE_NORM_DIST_MS | Statistic | Values of the normal distribution. | zAgNx | HID_FUNC_NORMDIST_MS | Returns the density function or the normal cumulative distribution. |
| NORM.INV | 8JgrV | SC_OPCODE_NORM_INV_MS | Statistic | Values of the inverse normal distribution. | 8sndF | HID_FUNC_NORMINV_MS | Returns the inverse of the normal cumulative distribution. |
| NORMINV | FvSZv | SC_OPCODE_NORM_INV | Statistic | Values of the inverse normal distribution. | wbkhD | HID_FUNC_NORMINV | Returns the inverse of the normal cumulative distribution. |
| NORMSDIST | 7UCkN | SC_OPCODE_STD_NORM_DIST | Statistic | The values of the standard normal cumulative distribution. | Evrir | HID_FUNC_STANDNORMVERT | Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.It is GAUSS(x)=NORMSDIST(x)-0.5 |
| NORM.S.DIST | WBCAe | SC_OPCODE_STD_NORM_DIST_MS | Statistic | The values of the standard normal distribution. | wKBLh | HID_FUNC_STD_NORMDIST_MS | Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one. |
| NORMSINV | 7UzHs | SC_OPCODE_S_NORM_INV | Statistic | Values of the inverse standard normal distribution. | 4GrmW | HID_FUNC_STANDNORMINV | Returns the inverse of the standard normal cumulative distribution. |
| NORM.S.INV | iRZfe | SC_OPCODE_S_NORM_INV_MS | Statistic | Values of the inverse standard normal distribution. | atGEy | HID_FUNC_STD_NORMINV_MS | Returns the inverse of the standard normal cumulative distribution. |
| NOT | 8V8Nc | SC_OPCODE_NOT | Logical | Reverses the value of the argument. | rPDCN | HID_FUNC_NICHT | Complements (inverts) a logical value. |
| NOW | Trn4m | SC_OPCODE_GET_ACT_TIME | Date&Time | Determines the current time of the computer. | jPR2m | HID_FUNC_JETZT | Returns the computer system date and time. The value is updated when you recalculate the document or each time a cell value is modified. |
| NPER | nFCKq | SC_OPCODE_NPER | Financial | Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate. | 5kpNF | HID_FUNC_ZZR | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
| NPV | 6wRqA | SC_OPCODE_NPV | Financial | Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate. | 2aUFC | HID_FUNC_NBW | Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value. |
| NUMBERVALUE | UW2wN | SC_OPCODE_NUMBERVALUE | Text | Converts text to a number, in a locale-independent way. | 5AiQi | HID_FUNC_NUMBERVALUE | Convert text to number, in a locale-independent way.Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator |
| OCT2BIN | kjrZm | ANALYSIS_FUNCNAME_Oct2Bin | Add-in | Converts an octal number to a binary number | GRuNw | HID_AAI_FUNC_OCT2BIN | The result is the binary number for the octal number entered. |
| OCT2DEC | BeZUW | HID_AAI_FUNC_OCT2DEZ | Add-in | Converts an octal number to a decimal number | z6LSc | HID_AAI_FUNC_OCT2DEC | The result is the decimal number for the octal number entered. |
| OCT2HEX | CRsqb | ANALYSIS_FUNCNAME_Oct2Hex | Add-in | Converts an octal number to a hexadecimal number | Jrzq3 | HID_AAI_FUNC_OCT2HEX | The result is the hexadecimal number for the octal number entered. |
| ODDFPRICE | Bv7hm | ANALYSIS_FUNCNAME_Oddfprice | Financial | Returns the price per $100 face value of a security with an odd first period | gSR5y | HID_AAI_FUNC_ODDFPRICE | Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly. |
| ODDFYIELD | 5sKBo | ANALYSIS_FUNCNAME_Oddfyield | Financial | Returns the yield of a security with an odd first period | yHLCB | HID_AAI_FUNC_ODDFYIELD | Calculates the yield of a security if the first interest date falls irregularly. |
| ODDLPRICE | ZBn5D | ANALYSIS_FUNCNAME_Oddlprice | Financial | Returns the price per $100 face value of a security with an odd last period | 6buPR | HID_AAI_FUNC_ODDLPRICE | Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly. |
| ODDLYIELD | bEdTF | ANALYSIS_FUNCNAME_Oddlyield | Financial | Returns the yield of a security with an odd last period | Pe9J2 | HID_AAI_FUNC_ODDLYIELD | Calculates the yield of a security if the last interest date falls irregularly. |
| ODD | v7KpB | SC_OPCODE_ODD | Mathematical | Rounds a positive number up and negative number down to the nearest odd integer. | 5PBxi | HID_FUNC_UNGERADE | Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. |
| OFFSET | 8oFWP | SC_OPCODE_OFFSET | Spredsheet | Returns a reference which has been moved in relation to the starting point. | V2MpB | HID_FUNC_VERSCHIEBUNG | Returns the value of a cell offset by a certain number of rows and columns from a given reference point. |
| OPT_BARRIER | aXoaK | PRICING_FUNCNAME_OptBarrier | Financial | Pricing of a barrier option | DCfi6 | PRICING_FUNCDESC_OptBarrier | |
| OPT_PROB_HIT | RTkVk | PRICING_FUNCNAME_OptProbHit | Financial | Probability that an asset hits a barrier assuming it follows dS/S = mu dt + vol dW | HusZF | PRICING_FUNCDESC_OptProbHit | |
| OPT_PROB_INMONEY | 46dEf | PRICING_FUNCNAME_OptProbInMoney | Financial | Probability that an asset will at maturity end up between two barrier levels, assuming it follows dS/S = mu dt + vol dW (if the last two optional parameters (strike, put/call) are specified, the probability of S_T in [strike, upper barrier] for a call and S_T in [lower barrier, strike] for a put will be returned) | 8GTWB | PRICING_FUNCDESC_OptProbInMoney | |
| OPT_TOUCH | Y3VTD | PRICING_FUNCNAME_OptTouch | Financial | Pricing of a touch/no-touch option | qGohA | PRICING_FUNCDESC_OptTouch | |
| OR | QE2MV | SC_OPCODE_OR | Logical | Returns TRUE if an argument is TRUE. | ovDuk | HID_FUNC_ODER | Returns TRUE if at least one argument is TRUE. This function returns the value FALSE, if all the arguments have the logical value FALSE.The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values. |
| PEARSON | SMRWW | SC_OPCODE_PEARSON | Statistic | Returns the Pearson product moment correlation coefficient. | gsTND | HID_FUNC_PEARSON | Returns the Pearson product moment correlation coefficient r. |
| PERCENTILE | epFrM | SC_OPCODE_PERCENTILE | Statistic | Returns the alpha quantile of a sample. | DsEhx | HID_FUNC_QUANTIL | Returns the alpha-percentile of data values in an array. A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN. |
| PERCENTILE.EXC | XLPgV | SC_OPCODE_PERCENTILE_EXC | Statistic | Returns the alpha percentile of a sample. | XPsFE | HID_FUNC_PERCENTILE_EXC | Returns the Alpha'th percentile of a supplied range of values for a given value of Alpha, within the range 0 to 1 (exclusive). A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (Alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN.If Alpha is not a multiple of 1/(n+1), (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if Alpha is less than 1/(n+1) or Alpha is greater than n/(n+1), the function is unable to interpolate, and so returns an error.The difference between PERCENTILE.INC and PERCENTILE.EXC is that, in the PERCENTILE.INC function the value of alpha is is within the range 0 to 1 inclusive, and in the PERCENTILE.EXC function, the value of alpha is within the range 0 to 1 exclusive. |
| PERCENTILE.INC | U2YGf | SC_OPCODE_PERCENTILE_INC | Statistic | Returns the alpha percentile of a sample. | GkVKE | HID_FUNC_PERCENTILE_INC | Returns the alpha-percentile of data values in an array. A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN.The difference between PERCENTILE.INC and PERCENTILE.EXC is that, in the PERCENTILE.INC function the value of alpha is is within the range 0 to 1 inclusive, and in the PERCENTILE.EXC function, the value of alpha is within the range 0 to 1 exclusive. |
| PERCENTRANK.EXC | Sb9AK | SC_OPCODE_PERCENT_RANK_EXC | Statistic | Returns the percentage rank (0..1, exclusive) of a value in a sample. | 8CxCm | HID_FUNC_PERCENTRANK_EXC | Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive. |
| PERCENTRANK.INC | 5zsNM | SC_OPCODE_PERCENT_RANK_INC | Statistic | Returns the percentage rank (0..1, inclusive) of a value in a sample. | NoS7f | HID_FUNC_PERCENTRANK_INC | Returns the relative position, between 0 and 1 (inclusive), of a specified value within a supplied array.The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive. |
| PERCENTRANK | nCwTV | SC_OPCODE_PERCENT_RANK | Statistic | Returns the percentage rank of a value in a sample. | PWnjw | HID_FUNC_QUANTILSRANG | Returns the percentage rank of a value in a sample. |
| PERMUT | 2YtiP | SC_OPCODE_PERMUT | Statistic | Returns the number of permutations for a given number of elements without repetition. | BZCuj | HID_FUNC_VARIATIONEN | Returns the number of permutations for a given number of objects. |
| PERMUTATIONA | MGS6C | SC_OPCODE_PERMUTATION_A | Statistic | Returns the number of permutations for a given number of objects (repetition allowed). | qmDVC | HID_FUNC_VARIATIONEN2 | Returns the number of permutations for a given number of objects (repetition allowed). |
| PHI | tGkmF | SC_OPCODE_PHI | Statistic | Values of the distribution function for a standard normal distribution. | onN3z | HID_FUNC_PHI | Returns the values of the distribution function for a standard normal distribution. |
| PI | 6CPJv | SC_OPCODE_PI | Mathematical | Returns the value of the number Pi. | kRL3K | HID_FUNC_PI | Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. |
| PMT | vDBFD | SC_OPCODE_PMT | Financial | Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate. | Dq92z | HID_FUNC_RMZ | Returns the periodic payment for an annuity with constant interest rates. |
| POISSON.DIST | MSB43 | SC_OPCODE_POISSON_DIST_MS | Statistic | Returns the Poisson distribution. | Wghve | HID_FUNC_POISSON_DIST_MS | Returns the Poisson distribution. |
| POISSON | sRGfk | SC_OPCODE_POISSON_DIST | Statistic | Returns the Poisson distribution. | pcFqE | HID_FUNC_POISSON | Returns the Poisson distribution. |
| POWER | gjfAD | SC_OPCODE_POWER | Mathematical | Returns a^b, base a raised to the power of exponent b. | Er28a | HID_FUNC_POTENZ | Returns a number raised to another number. |
| PPMT | nxR36 | SC_OPCODE_PPMT | Financial | Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant. | h9ucW | HID_FUNC_KAPZ | Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. |
| PRICEDISC | PSxKu | ANALYSIS_FUNCNAME_Pricedisc | Financial | Returns the price per 100 currency units face value of a discounted security | 4cQCF | HID_AAI_FUNC_PRICEDISC | Calculates the price per 100 currency units of par value of a non-interest- bearing security. |
| PRICEMAT | AkksF | ANALYSIS_FUNCNAME_Pricemat | Financial | Returns the price per 100 currency units face value of a security that pays interest at maturity | Nyx6J | HID_AAI_FUNC_PRICEMAT | Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date. |
| PRICE | TrN8j | ANALYSIS_FUNCNAME_Price | Financial | Returns the price per 100 currency units face value of a security that pays periodic interest | ZNXE3 | HID_AAI_FUNC_PRICE | Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield. |
| PROB | F6wkB | SC_OPCODE_PROB | Statistic | Returns the discrete probability of an interval. | nKPux | HID_FUNC_WAHRSCHBEREICH | Returns the probability that values in a range are between two limits. If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start. |
| PRODUCT | hbjVH | SC_OPCODE_PRODUCT | Mathematical | Multiplies the arguments. | CgRzr | HID_FUNC_PRODUKT | Multiplies all the numbers given as arguments and returns the product. |
| PROPER | oE8Fv | SC_OPCODE_PROPER | Text | Capitalizes the first letter in all words. | GbgGk | HID_FUNC_GROSS2 | Capitalizes the first letter in all words of a text string. |
| PV | iDXWU | SC_OPCODE_PV | Financial | Present value. Calculates the present value of an investment. | RyAQv | HID_FUNC_BW | Returns the present value of an investment resulting from a series of regular payments.Use this function to calculate the amount of money needed to be invested at a fixed rate today, to receive a specific amount, an annuity, over a specified number of periods. You can also determine how much money is to remain after the elapse of the period. Specify as well if the amount is to be paid out at the beginning or at the end of each period.Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under Rate and %PRODUCTNAME Calc with automatically calculate the correct factor. |
| QUARTILE | Apn3N | SC_OPCODE_QUARTILE | Statistic | Returns the quartile of a sample. | PVcfy | HID_FUNC_QUARTILE | Returns the quartile of a data set. |
| QUARTILE.EXC | oWBz5 | SC_OPCODE_QUARTILE_EXC | Statistic | Returns the quartile of a sample. | Dr7qs | HID_FUNC_QUARTILE_EXC | Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive. |
| QUARTILE.INC | uLGu3 | SC_OPCODE_QUARTILE_INC | Statistic | Returns the quartile of a sample. | CWHCa | HID_FUNC_QUARTILE_INC | Returns the quartile of a data set.The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive. |
| QUOTIENT | MKPGe | ANALYSIS_FUNCNAME_Quotient | Mathematical | Returns the integer portion of a division | ksJ6q | HID_AAI_FUNC_QUOTIENT | Returns the integer part of a division operation. |
| RADIANS | YhMXw | SC_OPCODE_RAD | Mathematical | Converts degrees to radians | cLhVs | HID_FUNC_RAD | Converts degrees to radians. |
| RANDBETWEEN | MM79F | ANALYSIS_FUNCNAME_Randbetween | Mathematical | Returns a random integer between the numbers you specify | mFwk5 | HID_AAI_FUNC_RANDBETWEEN | Returns an integer random number in a specified range. |
| RAND | wxSV9 | SC_OPCODE_RANDOM | Mathematical | Returns a random number between 0 and 1. | ujsfF | HID_FUNC_ZUFALLSZAHL | Returns a random number between 0 and 1.The value of 0 can be returned, the value of 1 not.this is really true after issue 53642 will be fixed |
| RANK.AVG | nDoCs | SC_OPCODE_RANK_AVG | Statistic | Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned. | i4MnC | HID_FUNC_RANK_AVG | Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, the average rank is returned.The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. |
| RANK.EQ | 6UPAR | SC_OPCODE_RANK_EQ | Statistic | Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned. | X5B3x | HID_FUNC_RANK_EQ | Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, these are given the same rank.The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. |
| RANK | T6Gdp | SC_OPCODE_RANK | Statistic | Returns the ranking of a value in a sample. | UNFCa | HID_FUNC_RANG | Returns the rank of a number in a sample. |
| RATE | YSzrF | SC_OPCODE_RATE | Financial | Calculates the constant interest rate of an investment with regular payments. | 2FvSc | HID_FUNC_ZINS | Returns the constant interest rate per period of an annuity. |
| RECEIVED | 83LwA | ANALYSIS_FUNCNAME_Received | Financial | Returns the amount paid out at maturity for a fully invested security | QHBha | HID_AAI_FUNC_RECEIVED | Calculates the amount received that is paid for a fixed-interest security at a given point in time. |
| REPLACE | ZkQVD | SC_OPCODE_REPLACE | Text | Replaces characters within a text string with a different text string. | Qf6pQ | HID_FUNC_ERSETZEN | Replaces part of a text string with a different text string. This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function.Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text. |
| REPT | gRSvi | SC_OPCODE_REPT | Text | Repeats text a given number of times. | 9wkCa | HID_FUNC_WIEDERHOLEN | Repeats a character string by the given number of copies. |
| RIGHTB | PAerG | SC_OPCODE_RIGHTB | Text | Returns the last character or characters of a text,with DBCS | muihV | HID_FUNC_RIGHTB | Returns the last character or characters of a text with double bytes characters sets (DBCS). |
| RIGHT | KULx8 | SC_OPCODE_RIGHT | Text | Returns the last character or characters of a text. | k4VGj | HID_FUNC_RECHTS | Returns the last character or characters of a text. |
| ROMAN | v74nk | SC_OPCODE_ROMAN | Text | Converts a number to a Roman numeral. | BRepp | HID_FUNC_ROEMISCH | Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. |
| ROT13 | QCbCd | DATE_FUNCNAME_Rot13 | Text | Encrypts or decrypts a text using the ROT13 algorithm | 4wRUM | HID_DAI_FUNC_ROT13 | Encrypts a character string by moving the characters 13 positions in the alphabet. After the letter Z, the alphabet begins again (Rotation). By applying the encryption function again to the resulting code, you can decrypt the text. |
| ROUND | CY3TR | SC_OPCODE_ROUND | Mathematical | Rounds a number to a predefined accuracy. | wNcCu | HID_FUNC_RUNDEN | Rounds a number to a certain number of decimal places. |
| ROUNDDOWN | xJL6s | SC_OPCODE_ROUND_DOWN | Mathematical | Rounds a number down to a predefined accuracy. | LGhzJ | HID_FUNC_ABRUNDEN | Rounds a number down, toward zero, to a certain precision. |
| ROUNDUP | WLbXP | SC_OPCODE_ROUND_UP | Mathematical | Rounds a number up to the predefined accuracy. | q7MQx | HID_FUNC_AUFRUNDEN | Rounds a number up, away from zero, to a certain precision. |
| ROW | qS7J5 | SC_OPCODE_ROW | Spredsheet | Defines the internal row number of a reference. | XWAfz | HID_FUNC_ZEILE | Returns the row number of a cell reference. If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column Array if the formula is entered as an array formula. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned. |
| ROWS | GE2Gd | SC_OPCODE_ROWS | Spredsheet | Returns the number of rows in a reference or array. | PudH2 | HID_FUNC_ZEILEN | Returns the number of rows in a reference or array. |
| RRI | R8STw | SC_OPCODE_RRI | Financial | Interest. Calculates the interest rate which represents the rate of return from an investment. | 79LDX | HID_FUNC_ZGZ | Calculates the interest rate resulting from the profit (return) of an investment. |
| RSQ | Erd2U | SC_OPCODE_RSQ | Statistic | Returns the square of the Pearson product moment correlation coefficient. | pVg6V | HID_FUNC_BESTIMMTHEITSMASS | Returns the square of the Pearson correlation coefficient based on the given values. RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis. |
| SEARCH | eG5FV | SC_OPCODE_SEARCH | Text | Looks for one text value within another (not case-sensitive). | waAuu | HID_FUNC_SUCHEN | Returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. |
| SECH | Rw5oL | SC_OPCODE_SECANT_HYP | Mathematical | Return the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x) | QTvfd | HID_FUNC_SECANTHYP | Returns the hyperbolic secant of a number. |
| SEC | ngmPB | SC_OPCODE_SECANT | Mathematical | Return the secant of an angle. SEC(x)=1/COS(x) | 9FN7X | HID_FUNC_SECANT | Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle |
| SECOND | GbCuP | SC_OPCODE_GET_SEC | Date&Time | Determines the sequential number of the second of a minute (0-59) for the time value. | 4i3C8 | HID_FUNC_SEKUNDE | Returns the second for the given time value. The second is given as an integer between 0 and 59. |
| SERIESSUM | e9f3r | ANALYSIS_FUNCNAME_Seriessum | Mathematical | Returns the sum of a power series | LYRJS | HID_AAI_FUNC_SERIESSUM | Sums the first terms of a power series. |
| SHEETS | iu2PC | SC_OPCODE_SHEETS | Spredsheet | Returns the number of sheets of a given reference. If no parameter has been entered, the total number of sheets in the document is returned. | ENSNf | HID_FUNC_TABELLEN | Determines the number of sheets in a reference. If you do not enter any parameters, it returns the number of sheets in the current document. |
| SHEET | XCBq6 | SC_OPCODE_SHEET | Spredsheet | Returns the internal sheet number of a reference or a string. | AaBTL | HID_FUNC_TABELLE | Returns the sheet number of a reference or a string representing a sheet name. If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula. |
| SIGN | CFEFE | SC_OPCODE_PLUS_MINUS | Mathematical | Returns the algebraic sign of a number. | zunhV | HID_FUNC_VORZEICHEN | Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero. |
| SIN | a63gy | SC_OPCODE_SIN | Mathematical | Returns the sine of a number. | zzPF6 | HID_FUNC_SIN | Returns the sine of the given angle (in radians). |
| SINH | WmLQN | SC_OPCODE_SIN_HYP | Mathematical | Returns the hyperbolic sine of a number. | M3F5C | HID_FUNC_SINHYP | Returns the hyperbolic sine of a number. |
| SKEW | 5DFqY | SC_OPCODE_SKEW | Statistic | Returns the skewness of a distribution. | QErrB | HID_FUNC_SCHIEFE | Returns the skewness of a distribution. |
| SKEWP | pfGng | SC_OPCODE_SKEWP | Statistic | Returns the skewness of a distribution using the population of a random variable. | PUQfJ | HID_FUNC_SKEWP | |
| SLN | hX8Ym | SC_OPCODE_SLN | Financial | Calculates the linear depreciation per period. | PxFFB | HID_FUNC_LIA | Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period. |
| SLOPE | SEZvN | SC_OPCODE_SLOPE | Statistic | Returns the slope of the linear regression line. | hCEAG | HID_FUNC_STEIGUNG | Returns the slope of the linear regression line. The slope is adapted to the data points set in the y and x values. |
| SMALL | gXHVi | SC_OPCODE_SMALL | Statistic | Returns the k-th smallest value of a sample. | G9oGc | HID_FUNC_KKLEINSTE | Returns the Rank_c-th smallest value in a data set. |
| SQRTPI | pzJ2T | ANALYSIS_FUNCNAME_Sqrtpi | Mathematical | Returns the square root of a number which has been multiplied by pi | ECLDw | HID_AAI_FUNC_SQRTPI | Returns the square root of (PI times a number). |
| SQRT | z9uq5 | SC_OPCODE_SQRT | Mathematical | Returns the square root of a number. | TKSrD | HID_FUNC_WURZEL | Returns the positive square root of a number. |
| STANDARDIZE | MCmNF | SC_OPCODE_STANDARD | Statistic | Converts a random variable to a normalized value. | crR6F | HID_FUNC_STANDARDISIERUNG | Converts a random variable to a normalized value. |
| STDEVA | bABCw | SC_OPCODE_ST_DEV_A | Statistic | Returns the standard deviation based on a sample. Text is evaluated as zero. | gE9PG | HID_FUNC_STABWA | Calculates the standard deviation of an estimation based on a sample. |
| STDEV | iAycZ | SC_OPCODE_ST_DEV | Statistic | Calculates the standard deviation based on a sample. | VXv5W | HID_FUNC_STABW | Estimates the standard deviation based on a sample. |
| STDEVP | 5FW4x | SC_OPCODE_ST_DEV_P | Statistic | Calculates the standard deviation based on the entire population. | CFM3p | HID_FUNC_STABWN | Calculates the standard deviation based on the entire population. |
| STDEVPA | GHsGr | SC_OPCODE_ST_DEV_P_A | Statistic | Returns the standard deviation based on the entire population. Text is evaluated as zero. | 9yQAY | HID_FUNC_STABWNA | Calculates the standard deviation based on the entire population. |
| STDEV.P | PVFaN | SC_OPCODE_ST_DEV_P_MS | Statistic | Calculates the standard deviation based on the entire population. | vyErB | HID_FUNC_ST_DEV_P_MS | Calculates the standard deviation based on the entire population. |
| STDEV.S | BU3qj | SC_OPCODE_ST_DEV_S | Statistic | Calculates the standard deviation based on a sample. | HHWB2 | HID_FUNC_ST_DEV_S | Calculates the standard deviation based on sample of the population. |
| STEYX | RQVvt | SC_OPCODE_STEYX | Statistic | Returns the standard error of the linear regression. | ZnAXV | HID_FUNC_STFEHLERYX | Returns the standard error of the predicted y value for each x in the regression. |
| STYLE | NhuAe | SC_OPCODE_STYLE | Spredsheet | Applies a Style to the formula cell. | Vf7ka | HID_FUNC_VORLAGE | Applies a style to the cell containing the formula. After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell regardless of the value. For example: =...+STYLE(IF(CURRENT()>3;"red";"green")) applies the style "red" to the cell if the value is greater than 3, otherwise the style "green" is applied. Both cell formats have to be defined beforehand. |
| SUBSTITUTE | yADs4 | SC_OPCODE_SUBSTITUTE | Text | Substitutes new text for old text in a string. | GCte9 | HID_FUNC_WECHSELN | Substitutes new text for old text in a string. |
| SUBTOTAL | 3BoZA | SC_OPCODE_SUB_TOTAL | Mathematical | Calculates subtotals in a spreadsheet. | j8BaA | HID_FUNC_TEILERGEBNIS | Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account. |
| SUMIFS | CQceM | SC_OPCODE_SUM_IFS | Mathematical | Totals the values of cells in a range that meet multiple criteria in multiple ranges. | Aw8Vc | HID_FUNC_SUMIFS | Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges. |
| SUMIF | uETrv | SC_OPCODE_SUM_IF | Mathematical | Totals the arguments that meet the conditions. | bvEru | HID_FUNC_SUMMEWENN | Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value. |
| SUMPRODUCT | 8vgZ6 | SC_OPCODE_SUM_PRODUCT | Array | (Inner products) Returns the sum of the products of array arguments. | 3D7PY | HID_FUNC_SUMMENPRODUKT | Multiplies corresponding elements in the given arrays, and returns the sum of those products. |
| SUMSQ | 9VBjs | SC_OPCODE_SUM_SQ | Mathematical | Returns the sum of the squares of the arguments. | KiAsa | HID_FUNC_QUADRATESUMME | If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields. |
| SUMX2MY2 | 9EAHv | SC_OPCODE_SUM_X2MY2 | Array | Returns the sum of the difference of squares of two arrays. | wwmB3 | HID_FUNC_SUMMEX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 | GZ3Xb | SC_OPCODE_SUM_X2DY2 | Array | Returns the total of the square sum of two arrays. | F2zCT | HID_FUNC_SUMMEX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 | rTo2W | SC_OPCODE_SUM_XMY2 | Array | Returns the sum of squares of differences of two arrays. | qp53A | HID_FUNC_SUMMEXMY2 | Adds the squares of the variance between corresponding values in two arrays. |
| SUM | z3v8h | SC_OPCODE_SUM | Mathematical | Returns the sum of all arguments. | YEi5V | HID_FUNC_SUMME | Adds all the numbers in a range of cells. |
| SYD | XJJxD | SC_OPCODE_SYD | Financial | Calculates the arithmetically declining value of an asset (depreciation) for a specified period. | yo8u2 | HID_FUNC_DIA | Returns the arithmetic-declining depreciation rate.Use this function to calculate the depreciation amount for one period of the total depreciation span of an object. Arithmetic declining depreciation reduces the depreciation amount from period to period by a fixed sum. |
| TAN | hnuwv | SC_OPCODE_TAN | Mathematical | Returns the tangent of a number. | i3kZt | HID_FUNC_TAN | Returns the tangent of the given angle (in radians). |
| TANH | TMUhN | SC_OPCODE_TAN_HYP | Mathematical | Returns the hyperbolic tangent of a number. | E2SFh | HID_FUNC_TANHYP | Returns the hyperbolic tangent of a number. |
| TBILLEQ | fRGcn | ANALYSIS_FUNCNAME_Tbilleq | Financial | Returns the bond-equivalent yield for a treasury bill | CmKjR | HID_AAI_FUNC_TBILLEQ | Calculates the annual return on a treasury bill. A treasury bill is purchased on the settlement date and sold at the full par value on the maturity date, that must fall within the same year. A discount is deducted from the purchase price. |
| TBILLPRICE | sNGGb | ANALYSIS_FUNCNAME_Tbillprice | Financial | Returns the price of 100 currency units face value for a treasury bill | e8DVw | HID_AAI_FUNC_TBILLPRICE | Calculates the price of a treasury bill per 100 currency units. |
| TBILLYIELD | CEeGV | ANALYSIS_FUNCNAME_Tbillyield | Financial | Returns the yield for a treasury bill | P4WjL | HID_AAI_FUNC_TBILLYIELD | Calculates the yield of a treasury bill. |
| T.DIST.2T | boheL | SC_OPCODE_T_DIST_2T | Statistic | Returns the two-tailed t-distribution. | VBAfz | HID_FUNC_TDIST_2T | Calculates the two-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. |
| T.DIST | 5GtXF | SC_OPCODE_T_DIST_MS | Statistic | Returns the t-distribution. | 5pXUh | HID_FUNC_TDIST_MS | Returns the t-distribution. |
| TDIST | DYe9i | SC_OPCODE_T_DIST | Statistic | Returns the t-distribution. | DkT3z | HID_FUNC_TVERT | Returns the t-distribution. |
| T.DIST.RT | zZece | SC_OPCODE_T_DIST_RT | Statistic | Returns the right-tailed t-distribution. | 3ST2h | HID_FUNC_TDIST_RT | Calculates the right-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. |
| TEXT | Cwg44 | SC_OPCODE_TEXT | Text | Converts a number to text according to a given format. | hkF8R | HID_FUNC_TEXT | Converts a number into text according to a given format. |
| TIME | SdChB | SC_OPCODE_GET_TIME | Date&Time | Determines a time value from the details for hour, minute and second. | 6GiJx | HID_FUNC_ZEIT | TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value. |
| TIMEVALUE | JBEzi | SC_OPCODE_GET_TIME_VALUE | Date&Time | Returns a sequential number for a text shown in a possible time entry format. | Y7zoc | HID_FUNC_ZEITWERT | TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries.If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion. |
| T.INV.2T | 23BxN | SC_OPCODE_T_INV_2T | Statistic | Values of the two-tailed inverse t-distribution. | 5qFNi | HID_FUNC_TINV_2T | Calculates the inverse of the two-tailed Student's T Distribution , which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. |
| TINV | DjcC6 | SC_OPCODE_T_INV | Statistic | Values of the inverse t-distribution. | B7LDX | HID_FUNC_TINV | Returns the inverse of the t-distribution. |
| T.INV | SSVFA | SC_OPCODE_T_INV_MS | Statistic | Values of the left-tailed inverse t-distribution. | DYoug | HID_FUNC_TINV_MS | Returns the one tailed inverse of the t-distribution. |
| TODAY | BMTTR | SC_OPCODE_GET_ACT_DATE | Date&Time | Determines the current date of the computer. | ETD4G | HID_FUNC_HEUTE | Returns the current computer system date. The value is updated when you reopen the document or modify the values of the document. |
| TRANSPOSE | WEXyE | SC_OPCODE_MAT_TRANS | Array | Array transposition. Exchanges the rows and columns of an array. | FEdzL | HID_FUNC_MTRANS | Transposes the rows and columns of an array. |
| TREND | kVWH4 | SC_OPCODE_TREND | Array | Calculates points along a regression line. | FpDCi | HID_FUNC_TREND | Returns values along a linear trend. |
| TRIM | 99CbY | SC_OPCODE_TRIM | Text | Removes extra spaces from text. | PYeYD | HID_FUNC_GLAETTEN | Removes spaces from a string, leaving only a single space character between words. |
| TRIMMEAN | qHxRa | SC_OPCODE_TRIM_MEAN | Statistic | Returns the mean of a sample without including the marginal values. | 82M23 | HID_FUNC_GESTUTZTMITTEL | Returns the mean of a data set without the Alpha percent of data at the margins. |
| TRUE | ysdGP | SC_OPCODE_TRUE | Logical | Returns the logical value TRUE. | hzpBX | HID_FUNC_WAHR | The logical value is set to TRUE. The TRUE() function does not require any arguments, and always returns the logical value TRUE. |
| TRUNC | Uhcfm | SC_OPCODE_TRUNC | Mathematical | Truncates the decimal places of a number. | LnDPt | HID_FUNC_KUERZEN | Truncates a number by removing decimal places. |
| TTEST | cWYfZ | SC_OPCODE_T_TEST | Statistic | Calculates the T test. | pfmGJ | HID_FUNC_TTEST | Returns the probability associated with a Student's t-Test. |
| T.TEST | RNnCV | SC_OPCODE_T_TEST_MS | Statistic | Calculates the T test. | vDzaY | HID_FUNC_TTEST_MS | Returns the probability associated with a Student's t-Test. |
| T | w8Lza | SC_OPCODE_T | Text | Returns a value if it is text, otherwise an empty string. | EAnZ8 | HID_FUNC_T | This function returns the target text, or a blank text string if the target is not text. |
| TYPE | 9oYWD | SC_OPCODE_TYPE | Infirmation | Defines the data type of a value. | 5mXzG | HID_FUNC_TYP | Returns the type of value, where 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array. |
| UNICHAR | K4Hp6 | SC_OPCODE_UNICHAR | Text | Converts a code number into a Unicode character or letter. | ASKRi | HID_FUNC_UNICHAR | Converts a code number into a Unicode character or letter. |
| UNICODE | exveD | SC_OPCODE_UNICODE | Text | Returns the numeric code for the first Unicode character in a text string. | E6uXf | HID_FUNC_UNICODE | Returns the numeric code for the first Unicode character in a text string. |
| UPPER | p6ktK | SC_OPCODE_UPPER | Text | Converts text to uppercase. | YqWcu | HID_FUNC_GROSS | Converts the string specified in the text field to uppercase. |
| VALUE | 4X6Ex | SC_OPCODE_VALUE | Text | Converts text to a number. | UvTCu | HID_FUNC_WERT | Converts a text string into a number. |
| VARA | 6ios3 | SC_OPCODE_VAR_A | Statistic | Returns the variance based on a sample. Text is evaluated as zero. | B54Yr | HID_FUNC_VARIANZA | Estimates a variance based on a sample. The value of text is 0. |
| VAR | HCvpt | SC_OPCODE_VAR | Statistic | Calculates the variance based on a sample. | jmVEj | HID_FUNC_VARIANZ | Estimates the variance based on a sample. |
| VARPA | HrE2s | SC_OPCODE_VAR_P_A | Statistic | Returns the variance based on the entire population. Text is evaluated as zero. | RDhTQ | HID_FUNC_VARIANZENA | Calculates the variance based on the entire population. The value of text is 0. |
| VAR.P | e4dLQ | SC_OPCODE_VAR_P_MS | Statistic | Calculates variance based on the entire population. | VAdCJ | HID_FUNC_VAR_P_MS | Calculates a variance based on the entire population. |
| VARP | NRpd8 | SC_OPCODE_VAR_P | Statistic | Calculates variance based on the entire population. | 6QDSX | HID_FUNC_VARIANZEN | Calculates a variance based on the entire population. |
| VAR.S | 4p9A5 | SC_OPCODE_VAR_S | Statistic | Calculates the variance based on a sample. | 3qmyn | HID_FUNC_VAR_S | Estimates the variance based on a sample. |
| VDB | J6MCA | SC_OPCODE_VBD | Financial | Variable declining balance. Returns the declining balance depreciation for a particular period. | TFzZ7 | HID_FUNC_VDB | Returns the depreciation of an asset for a specified or partial period using a variable declining balance method. |
| VLOOKUP | AMu42 | SC_OPCODE_V_LOOKUP | Spredsheet | Vertical search and reference to indicated cells. | f449R | HID_FUNC_SVERWEIS | Vertical search with reference to adjacent cells to the right. This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by Index. If the SortOrder parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact SearchCriterion is not found, the last value that is smaller than the criterion will be returned. If SortOrder is set to FALSE or zero, an exact match must be found, otherwise the error Error: Value Not Available will be the result. Thus with a value of zero the data does not need to be sorted in ascending order. |
| WEBSERVICE | XACHe | SC_OPCODE_WEBSERVICE | Text | Get some webcontent from an URI. | C8J4v | HID_FUNC_WEBSERVICE | Get some web content from a URI. |
| WEEKDAY | BwaWE | SC_OPCODE_GET_DAY_OF_WEEK | Date&Time | Returns the day of the week for the date value as an integer. | YnpJB | HID_FUNC_WOCHENTAG | Returns the day of the week for the given date value. The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. If type=2, numbering begins at Monday=1; and if type=3 numbering begins at Monday=0. |
| WEEKNUM | fL5qd | ANALYSIS_FUNCNAME_Weeknum | Date&Time | Returns the number of the calendar week in which the specified date occurs. | KRJDB | HID_AAI_FUNC_WEEKNUM | The result indicates the number of the calendar week for a date.The WEEKNUM_ADD function is designed to calculate week numbers exactly as Microsoft Excel does. Use the WEEKNUM function, or format your date cells using the WW formatting code, when you need ISO 8601 week numbers. |
| WEEKNUM | sA2od | SC_OPCODE_WEEK | Date&Time | Calculates the calendar week corresponding to the given date. | mw3Yx | HID_FUNC_KALENDERWOCHE | WEEKNUM calculates the week number of the year for the internal date value.The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th. |
| WEEKSINYEAR | 5Te2e | DATE_FUNCNAME_WeeksInYear | Date&Time | Returns the number of weeks of the year in which the date entered occurs | 3XCdG | HID_DAI_FUNC_WEEKSINYEAR | Calculates the number of weeks of the year in which the date entered occurs. The number of weeks is defined as follows: a week that spans two years is added to the year in which most days of that week occur. |
| WEEKS | pkA8s | DATE_FUNCNAME_DiffWeeks | Date&Time | Calculates the number of weeks in a specific period | c9Yb3 | HID_DAI_FUNC_DIFFWEEKS | Calculates the difference in weeks between two dates. |
| WEIBULL.DIST | eUGHh | SC_OPCODE_WEIBULL_MS | Statistic | Returns the values of the Weibull distribution. | MfC7c | HID_FUNC_WEIBULL_DIST_MS | Returns the values of the Weibull distribution.The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale). If C is 0, WEIBULL.DIST calculates the probability density function.If C is 1, WEIBULL.DIST calculates the cumulative distribution function. |
| WEIBULL | RkvE3 | SC_OPCODE_WEIBULL | Statistic | Returns the values of the Weibull distribution. | 8kjCL | HID_FUNC_WEIBULL | Returns the values of the Weibull distribution.The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale). If C is 0, WEIBULL calculates the probability density function.If C is 1, WEIBULL calculates the cumulative distribution function. <paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U" |
| WORKDAY.INTL | GU3GC | SC_OPCODE_WORKDAY_MS | Date&Time | Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays. | SuDt2 | HID_FUNC_WORKDAY_MS | |
| WORKDAY | rMBDp | ANALYSIS_FUNCNAME_Workday | Date&Time | Returns the serial number of the date before or after a specified number of workdays | vmpEf | HID_AAI_FUNC_WORKDAY | The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of workdays away from the start date. |
| XIRR | EKqrE | ANALYSIS_FUNCNAME_Xirr | Financial | Returns the internal rate of return for a non-periodic schedule of payments | 85tPn | HID_AAI_FUNC_XIRR | Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.If the payments take place at regular intervals, use the IRR function. |
| XNPV | hn3KX | ANALYSIS_FUNCNAME_Xnpv | Financial | Returns the net present value for a non-periodic schedule of payments | vGqGR | HID_AAI_FUNC_XNPV | Calculates the capital value (net present value)for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.If the payments take place at regular intervals, use the NPV function. |
| XOR | dbDzF | SC_OPCODE_XOR | Logical | Returns TRUE if an odd number of arguments evaluates to TRUE. | 9QUTZ | HID_FUNC_XOR | Returns true if an odd number of arguments evaluates to TRUE.The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values. |
| YEARFRAC | kGmgF | ANALYSIS_FUNCNAME_Yearfrac | Date&Time | Returns the number of years (including fractional part) between two dates | 8bZCK | HID_AAI_FUNC_YEARFRAC | The result is the number of the years (including fractional part) between StartDate and EndDate. |
| YEAR | MmbCB | SC_OPCODE_GET_YEAR | Date&Time | Returns the year of a date value as an integer. | fBL9C | HID_FUNC_JAHR | Returns the year as a number according to the internal calculation rules. |
| YEARS | BLYYA | DATE_FUNCNAME_DiffYears | Date&Time | Calculates the number of years in a specific period. | ni77P | HID_DAI_FUNC_DIFFYEARS | Calculates the difference in years between two dates. |
| YIELDDISC | etCXF | ANALYSIS_FUNCNAME_Yielddisc | Financial | Returns the annual yield for a discounted security | iuQnm | HID_AAI_FUNC_YIELDDISC | Calculates the annual yield of a non-interest-bearing security. |
| YIELD | dMKqD | ANALYSIS_FUNCNAME_Yield | Financial | Returns the yield on a security that pays periodic interest | GT2fw | HID_AAI_FUNC_YIELD | Calculates the yield of a security. |
| YIELDMAT | W5ij7 | ANALYSIS_FUNCNAME_Yieldmat | Financial | Returns the annual yield of a security that pays interest at maturity | BfjuC | HID_AAI_FUNC_YIELDMAT | Calculates the annual yield of a security, the interest of which is paid on the date of maturity. |
| Z.TEST | RC3LB | SC_OPCODE_Z_TEST_MS | Statistic | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. | 3nUqG | HID_FUNC_Z_TEST_MS | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |
| ZTEST | wRUas | SC_OPCODE_Z_TEST | Statistic | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. | w9ZEF | HID_FUNC_GTEST | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |
Script
I began to develop the script for this purpose.