User:Tagezi/CalcFunction

From The Document Foundation Wiki
Jump to: navigation, search

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).

Gnome-dialog-warning.svg

Warning:
It was made in an automatic mode using a script and is no fully tested. If you want to use it, use it with caution.


Calc Function

Names, descriptions and KeyIDs of functions
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.

Gnome-dialog-warning.svg

Warning:
Now (for the 5.3 version) the script does not work. You can get only rubbish.