ReferenceABSACCRINTACCRINTMACOSACOSHADDRESSAMORDEGRCAMORLINCANDASINASINHATANATAN2ATANHAVEDEVAVERAGEAVERAGEABESSELIBESSELJBESSELKBESSELYBETADISTBETAINVBIN2DECBIN2HEXBIN2OCTBINOMDISTCEILCEILINGCELLCHARCHIDISTCHIINVCHITESTCHOOSECLEANCODECOLUMNCOLUMNSCOMBINCOMPLEXCONCATENATECONFIDENCECONVERTCORRELCOSCOSHCOUNTCOUNTACOUNTBLANKCOUNTIFCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCOVARCRITBINOMCUMIPMTCUMPRINCDATEDATEDIFDATEVALUEDAVERAGEDAYDAYS360 DBDCOUNTDCOUNTADDBDEC2BINDEC2HEXDEC2OCTDEGREESDELTADEVSQDGETDISCDMAXDMINDOLLARDOLLARDEDOLLARFRDPRODUCTDSTDEVDSTDEVPDSUMDURATIONDVARDVARPEDATEEFFECTEOMONTHERFERFCERRORERROR.TYPEEUROEVENEXACTEXPEXPONDISTEXPRESSIONFACTFACTDOUBLEFALSEFDISTFINDFINVFISHERFISHERINVFIXEDFLOORFORECASTFREQUENCYFTESTFVFVSCHEDULEGAMMADISTGAMMAINVGAMMALNGCDGEOMEANGESTEPGETPIVOTDATAGNUMERIC_VERSIONGROWTHG_PRODUCTHARMEANHEX2BINHEX2DECHEX2OCTHLOOKUPHOURHYPERLINKHYPGEOMDISTIFIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMIMTANINDEXINDIRECTINFOINTINTERCEPTINTRATEIPMTIRRISBLANKISERRISERRORISEVENISLOGICALISNAISNONTEXTISNUMBERISODDISPMTISREFISTEXTKURTKURTPLARGELCMLEFTLENLINESTLNLOGLOG10LOG2LOGESTLOGINVLOGNORMDISTLOOKUPLOWERMATCHMAXMAXAMDETERMMDURATIONMEDIANMIDMINMINAMINUTEMINVERSEMIRRMMULTMODMODEMONTHMROUNDMULTINOMIALNNANEGBINOMDISTNETWORKDAYSNOMINALNORMDISTNORMINVNORMSDISTNORMSINVNOTNOWNPERNPVOCT2BINOCT2DECOCT2HEXODDODDFPRICEODDFYIELDODDLPRICEODDLYIELDOFFSETORPEARSONPERCENTILEPERCENTRANKPERMUTPIPMTPOISSONPOWERPPMTPRICEPRICEDISCPRICEMATPROBPRODUCTPROPERPVQUARTILEQUOTIENTRADIANSRANDRANDBETWEENRANDNEGBINOMRANKRATERECEIVEDREPLACEREPTRIGHTROMANROUNDROUNDDOWNROUNDUPROWROWSRSQRandBernoulliRandBinomRandExpRandPoissonSEARCHSECONDSELECTIONSERIESSUMSIGNSINSINHSKEWSKEWPSLNSLOPESMALLSQRTSQRTPISTANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXSUBSTITUTESUBTOTALSUMSUMASUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2SYDTTANTANHTBILLEQTBILLPRICETBILLYIELDTDISTTEXTTIMETIMEVALUETINVTODAYTRANSPOSETRENDTRIMTRIMMEANTRUETRUNCTTESTTYPEUPPERVALUEVARVARAVARPVARPAVDBVLOOKUPWEEKDAYWEIBULLWORKDAYXIRRXNPVYEARYIELDYIELDDISCYIELDMATZTESTLCMLCMLCM(number1,number2,...)DescriptionLCM returns the least common multiple of integers. The least common multiple is the smallest positive number that is a multiple of all integer arguments given.If any of the arguments is less than one, LCM returns #NUM! error. This function is Excel compatible.ExamplesLCM(2,13) equlas to 26.LCM(4,7,5) equals to 140.See also GCD.
PRICEDISCPRICEDISCPRICEDISC(settlement,maturity,discount,redemption[,basis])DescriptionPRICEDISC calculates and returns the price per $100 face value of a security bond. The security does not pay interest at maturity. @discount is the rate for which the security is discounted. @redemption is the amount to be received on @maturity date. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, PRICEDISC returns #NUM! error. If @basis < 0 or @basis > 4, PRICEDISC returns #NUM! error. If @settlement date is after @maturity date or they are the same, PRICEDISC returns #NUM! error.ExamplesSee also PRICEMAT.
IMARGUMENTIMARGUMENTIMARGUMENT(inumber)DescriptionIMARGUMENT returns the argument theta of a complex number. This function is Excel compatible.ExamplesIMARGUMENT("2-j") equals -0.463647609.See alsoRANDBETWEENRANDBETWEENRANDBETWEEN(bottom,top)DescriptionRANDBETWEEN function returns a random integer number between @bottom and @top.If @bottom or @top is non-integer, they are truncated. If @bottom > @top, RANDBETWEEN returns #NUM! error.This function is Excel compatible.ExamplesRANDBETWEEN(3,7).See also RAND.
COSHCOSHCOSH(x)DescriptionCOSH function returns the hyperbolic cosine of @x, which is defined mathematically as (exp(@x) + exp(-@x)) / 2. @x is in radians. This function is Excel compatible.ExamplesCOSH(0.5) equals 1.127626.COSH(1) equals 1.543081.See also COS,
SIN,
SINH,
TAN,
TANH,
RADIANS,
DEGREES,
EXP.
YIELDDISCYIELDDISCYIELDDISC(settlement,maturity,pr,redemption,basis)DescriptionExamplesSee alsoREPTREPTREPT(string,num)DescriptionREPT returns @num repetitions of @string.ExamplesREPT(".",3) equals "...".See also CONCATENATE.
DEGREESDEGREESDEGREES(x)DescriptionDEGREES computes the number of degrees equivalent to @x radians. This function is Excel compatible.ExamplesDEGREES(2.5) equals 143.2394.See also RADIANS,
PI.
NOMINALNOMINALNOMINAL(r,nper)DescriptionNOMINAL calculates the nominal interest rate from a given effective rate.Nominal interest rate is given by a formula:@nper * (( 1 + @r ) ^ (1 / @nper) - 1 )where:@r = effective interest rate@nper = number of periods used for compoundingExamplesSee also EFFECT.
ISODDISODDISODD(value)DescriptionISODD returns TRUE if the number is odd. This function is Excel compatible.ExamplesSee also ISEVEN.
RSQRSQRSQ(array1,array2)DescriptionRSQ returns the square of the Pearson correlation coefficient of two data sets.Strings and empty cells are simply ignored. This function is Excel compatible.ExamplesSee also CORREL,
COVAR,
INTERCEPT,
LINEST,
LOGEST,
PEARSON,
SLOPE,
STEYX,
TREND.
ODDLYIELDODDLYIELDODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency,basis)DescriptionExamplesSee alsoCOLUMNCOLUMNCOLUMN([reference])DescriptionThe COLUMN function returns an array of the column numbers taking a default argument of the containing cell position.If @reference is neither an array nor a reference nor a range returns #VALUE!.ExamplesSee also COLUMNS,
ROW,
ROWS.
RATERATERATE(nper,pmt,pv[,fv,type,guess])DescriptionRATE calculates rate of an investment.ExamplesSee also PV,
FV.
DPRODUCTDPRODUCTDPRODUCT(database,field,criteria)DescriptionDPRODUCT function returns the product of numbers in a column that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DPRODUCT(A1:C7, "Age", A9:B11) equals 1247.See also DSUM.
FDISTFDISTFDIST(x,dof1,dof2)DescriptionFDIST function returns the F probability distribution. @dof1 is the numerator degrees of freedom and @dof2 is the denominator degrees of freedom.If @x < 0 FDIST returns #NUM! error. If @dof1 < 1 or @dof2 < 1, FDIST returns #NUM! error. This function is Excel compatible.ExamplesFDIST(2,5,5) equals 0.232511319.See also FINV.
ISEVENISEVENISEVEN(value)DescriptionISEVEN returns TRUE if the number is even. This function is Excel compatible.ExamplesSee also ISODD.
ZTESTZTESTZTEST(ref,x)DescriptionZTEST returns the two-tailed probability of a z-test.@ref is the data set and @x is the value to be tested.If @ref contains less than two data items ZTEST returns #DIV/0! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenZTEST(A1:A5,20) equals 0.254717826.See also CONFIDENCE,
NORMDIST,
NORMINV,
NORMSDIST,
NORMSINV,
STANDARDIZE.
DMINDMINDMIN(database,field,criteria)DescriptionDMIN function returns the smallest number in a column that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DMIN(A1:C7, "Salary", A9:B11) equals 34323.DMIN(A1:C7, "Age", A9:B11) equals 29.See also DMAX.
TEXTTEXTTEXT(value,format_text)DescriptionTEXT returns @value as a string with the specified format.ExamplesTEXT(3.223,"$0.00") equals "$3.22".TEXT(date(1999,4,15),"mmmm, dd, yy") equals "April, 15, 99".See also DOLLAR.
RandBinomRandBinomRandBinom(p,trials)DescriptionRandBinom returns a binomialy distributed random number.If @p < 0 or @p > 1 RandBinom returns #NUM! error. If @trials < 0 RandBinom returns #NUM! error.ExamplesRandBinom(0.5,2).See also RAND,
RANDBETWEEN.
RandBernoulliRandBernoulliRandBernoulli(p)DescriptionRandBernoulli returns a Bernoulli distributed random number.If @p < 0 or @p > 1 RandBernoulli returns #NUM! error.ExamplesRandBernoulli(0.5).See also RAND,
RANDBETWEEN.
WEEKDAYWEEKDAYWEEKDAY (serial_number)DescriptionConverts a serial number to a weekday.This function returns an integer in the range 0-6, where Saturday is 0, Sunday is 1, etc.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesWEEKDAY("10/24/1968") equals 5 (Thursday).See also DAY,
MONTH,
TIME,
NOW,
YEAR.
PRODUCTPRODUCTPRODUCT(value1, value2, ...)DescriptionPRODUCT returns the product of all the values and cells referenced in the argument list. This function is Excel compatible. In particular, this means that if all cells are empty, the result will be 0.ExamplesPRODUCT(2,5,9) equals 90.See also SUM,
COUNT,
G_PRODUCT.
RandPoissonRandPoissonRandPoisson(lambda)DescriptionRandPoisson returns a poisson distributed random number.ExamplesRandPoisson(3).See also RAND,
RANDBETWEEN.
MULTINOMIALMULTINOMIALMULTINOMIAL(value1, value2, ...)DescriptionMULTINOMIAL returns the ratio of the factorial of a sum of values to the product of factorials. This function is Excel compatible.ExamplesMULTINOMIAL(2,3,4) equals 1260.See also SUM.
IMSINIMSINIMSIN(inumber)DescriptionIMSIN returns the sine of a complex number. This function is Excel compatible.ExamplesIMSIN("1+j") equals 1.29846+0.63496j.See also IMCOS,
IMTAN.
COSCOSCOS(x)DescriptionCOS function returns the cosine of @x, where @x is given in radians. This function is Excel compatible.ExamplesCOS(0.5) equals 0.877583.COS(1) equals 0.540302.See also COSH,
SIN,
SINH,
TAN,
TANH,
RADIANS,
DEGREES.
EXPEXPEXP(x)DescriptionEXP computes the value of e (the base of natural logarithmns) raised to the power of @x. This function is Excel compatible.ExamplesEXP(2) equals 7.389056.See also LOG,
LOG2,
LOG10.
ASINASINASIN(x)DescriptionASIN function calculates the arc sine of @x; that is the value whose sine is @x. If @x falls outside the range -1 to 1, ASIN fails and returns the NUM! error. This function is Excel compatible.ExamplesASIN(0.5) equals 0.523599.ASIN(1) equals 1.570797.See also SIN,
COS,
ASINH,
DEGREES,
RADIANS.
PERCENTILEPERCENTILEPERCENTILE(array,k)DescriptionPERCENTILE function returns the 100*@k-th percentile of the given data points (that is, a number x such that a fraction @k of the data points are less than x).If @array is empty, PERCENTILE returns #NUM! error. If @k < 0 or @k > 1, PERCENTILE returns #NUM! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenPERCENTILE(A1:A5,0.42) equals 20.02.See also QUARTILE.
TRIMMEANTRIMMEANTRIMMEAN(ref,fraction)DescriptionTRIMMEAN returns the mean of the interior of a data set. @ref is the list of numbers whose mean you want to calculate and @fraction is the fraction of the data set excluded from the mean. For example, if @fraction=0.2 and the data set contains 40 numbers, 8 numbers are trimmed from the data set (40 x 0.2), 4 from the top and 4 from the bottom of the set. This function is Excel compatible.ExamplesSee also AVERAGE,
GEOMEAN,
HARMEAN,
MEDIAN,
MODE.
TRUETRUETRUE()DescriptionTRUE returns boolean value true. This function is Excel compatible.ExamplesTRUE() equals TRUE.See also FALSE.
FLOORFLOORFLOOR(x,significance)DescriptionFLOOR function rounds @x down to the next nearest multiple of @significance. @significance defaults to 1. This function is Excel compatible.ExamplesFLOOR(0.5) equals 0.FLOOR(5,2) equals 4.FLOOR(-5,-2) equals -4.FLOOR(-5,2) equals #NUM!.See also CEIL,
ABS,
INT.
GCDGCDGCD(number1,number2,...)DescriptionGCD returns the greatest common divisor of given numbers.If any of the arguments is less than zero, GCD returns #NUM! error. If any of the arguments is non-integer, it is truncated. This function is Excel compatible.ExamplesGCD(470,770) equals to 10.GCD(470,770,1495) equals to 5.See also LCM.
ODDLPRICEODDLPRICEODDLPRICE(settlement,maturity,last_interest,rate,yld,redemption,frequency,basis)DescriptionExamplesSee alsoCHOOSECHOOSECHOOSE(index[,value1][,value2]...)DescriptionCHOOSE returns the value of index @index. @index is rounded to an integer if it is not.If @index < 1 or @index > number of values: returns #VAL!.ExamplesSee also IF.
POISSONPOISSONPOISSON(x,mean,cumulative)DescriptionPOISSON function returns the Poisson distribution. @x is the number of events, @mean is the expected numeric value @cumulative describes whether to return the sum of the poisson function from 0 to @x.If @x is a non-integer it is truncated. If @x <= 0 POISSON returns #NUM! error. If @mean <= 0 POISSON returns the #NUM! error. This function is Excel compatible.ExamplesPOISSON(3,6,0) equals 0.089235078.See also NORMDIST,
WEIBULL.
SYDSYDSYD(cost,salvage_value,life,period)DescriptionThe SYD function calculates the sum-of-years digits depriciation for an asset based on its cost, salvage value, anticipated life and a particular period. This method accelerates the rate of the depreciation, so that more depreciation expense occurs in earlier periods than in later ones. The depreciable cost is the actual cost minus the salvage value. The useful life is the number of periods (typically years) over with the asset is depreciated.The Formula used for sum-of-years digits depriciation is:Depriciation expense = ( @cost - @salvage_value ) * (@life - @period + 1) * 2 / @life * (@life + 1). @cost = cost of an asset when acquired (market value). @salvage_value = amount you get when asset sold at the end of its useful life. @life = anticipated life of an asset. @period = period for which we need the expense.ExamplesFor example say a company purchases a new computer for $5000 which has a salvage value of $200, and a useful life of three years. We would use the following to calculate the second year's depreciation using the SYD method:=SYD(5000, 200, 5, 2) which returns 1,280.00.See also SLN.
MIDMIDMID(string, position, length)DescriptionMID returns a substring from @string starting at @position for @length characters.ExamplesMID("testing",2,3) equals "est".See also LEFT,
RIGHT.
ASINHASINHASINH(x)DescriptionASINH function calculates the inverse hyperbolic sine of @x; that is the value whose hyperbolic sine is @x. This function is Excel compatible.ExamplesASINH(0.5) equals 0.481212.ASINH(1.0) equals 0.881374.See also ASIN,
ACOSH,
SIN,
COS,
DEGREES,
RADIANS.
EXPONDISTEXPONDISTEXPONDIST(x,y,cumulative)DescriptionEXPONDIST function returns the exponential distribution. If the @cumulative boolean is false it will return: @y * exp (-@y*@x), otherwise it will return 1 - exp (-@y*@x).If @x < 0 or @y <= 0 this will return an error. This function is Excel compatible.ExamplesEXPONDIST(2,4,0) equals 0.001341851.See also POISSON.
COUPDAYBSCOUPDAYBSCOUPDAYBS(settlement,maturity,frequency[,basis])DescriptionReturns the number of days from the beginning of the coupon period to the settlement date.ExamplesSee alsoUPPERUPPERUPPER(text)DescriptionUPPER returns a upper-case version of the string in @text.ExamplesUPPER("canceled") equals "CANCELED".See also LOWER.
HARMEANHARMEANHARMEAN(b1, b2, ...)DescriptionHARMEAN returns the harmonic mean of the N data points (that is, N divided by the sum of the inverses of the data points). This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenHARMEAN(A1:A5) equals 19.529814427.See also AVERAGE,
GEOMEAN,
MEDIAN,
MODE,
TRIMMEAN.
TBILLYIELDTBILLYIELDTBILLYIELD(settlement,maturity,pr)DescriptionTBILLYIELD function returns the yield for a treasury bill. @settlement is the settlement date and @maturity is the maturity date of the bill. @discount is the treasury bill's discount rate.If @settlement is after @maturity or the @maturity is set to over one year later than the @settlement, TBILLYIELD returns #NUM! error. If @pr is negative, TBILLYIELD returns #NUM! error.ExamplesSee also TBILLEQ,
TBILLPRICE.
ODDFYIELDODDFYIELDODDFYIELD(settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis)DescriptionExamplesSee alsoCONVERTCONVERTCONVERT(number,from_unit,to_unit)DescriptionCONVERT returns a conversion from one measurement system to another. For example, you can convert a weight in pounds to a weight in grams. @number is the value you want to convert, @from_unit specifies the unit of the @number, and @to_unit is the unit for the result.@from_unit and @to_unit can be any of the following:Weight and mass:'g' Gram'sg' Slug'lbm' Pound'u' U (atomic mass)'ozm' OunceDistance:'m' Meter'mi' Statute mile'Nmi' Nautical mile'in' Inch'ft' Foot'yd' Yard'ang' Angstrom'Pica' PicaTime:'yr' Year'day' Day'hr' Hour'mn' Minute'sec' SecondPressure:'Pa' Pascal'atm' Atmosphere'mmHg' mm of MercuryForce:'N' Newton'dyn' Dyne'lbf' Pound forceEnergy:'J' Joule'e' Erg'c' Thermodynamic calorie'cal' IT calorie'eV' Electron volt'HPh' Horsepower-hour'Wh' Watt-hour'flb' Foot-pound'BTU' BTUPower:'HP' Horsepower'W' WattMagnetism:'T' Tesla'ga' GaussTemperature:'C' Degree Celsius'F' Degree Fahrenheit'K' Degree KelvinLiquid measure:'tsp' Teaspoon'tbs' Tablespoon'oz' Fluid ounce'cup' Cup'pt' Pint'qt' Quart'gal' Gallon'l' LiterFor metric units any of the following prefixes can be used:'E' exa 1E+18'P' peta 1E+15'T' tera 1E+12'G' giga 1E+09'M' mega 1E+06'k' kilo 1E+03'h' hecto 1E+02'e' dekao 1E+01'd' deci 1E-01'c' centi 1E-02'm' milli 1E-03'u' micro 1E-06'n' nano 1E-09'p' pico 1E-12'f' femto 1E-15'a' atto 1E-18If @from_unit and @to_unit are different types, CONVERT returns #NUM! error. This function is Excel compatible.ExamplesCONVERT(3,"lbm","g") equals 1360.7769.CONVERT(5.8,"m","in") equals 228.3465.CONVERT(7.9,"cal","J") equals 33.07567.See alsoLOGLOGLOG(x[,base])DescriptionLOG computes the logarithm of @x in the given base @base. If no @base is given LOG returns the logarithm in base 10. This function is Excel compatible.ExamplesLOG(2) equals 0.30103.LOG(8192,2) equals 13.See also LN,
LOG2,
LOG10.
HYPGEOMDISTHYPGEOMDISTHYPGEOMDIST(x,n,M,N)DescriptionHYPGEOMDIST function returns the hypergeometric distribution. @x is the number of successes in the sample, @n is the number of trials, @M is the number of successes overall, and @N is thepopulation size.If @x,@n,@M or @N is a non-integer it is truncated. If @x,@n,@M or @N < 0 HYPGEOMDIST returns #NUM! error. If @x > @M or @n > @N HYPGEOMDIST returns #NUM! error. This function is Excel compatible.ExamplesHYPGEOMDIST(1,2,3,10) equals 0.4666667.See also BINOMDIST,
POISSON.
IMABSIMABSIMABS(inumber)DescriptionIMABS returns the absolute value of a complex number. This function is Excel compatible.ExamplesIMABS("2-j") equals 2.23606798.See also IMAGINARY,
IMREAL.
SINHSINHSINH(x)DescriptionSINH function returns the hyperbolic sine of @x, which is defined mathematically as (exp(@x) - exp(-@x)) / 2. This function is Excel compatible.ExamplesSINH(0.5) equals 0.521095.See also SIN,
COS,
COSH,
TAN,
TANH,
DEGREES,
RADIANS,
EXP.
AVEDEVAVEDEVAVEDEV(n1, n2, ...)DescriptionAVEDEV returns the average of the absolute deviations of a data set from their mean. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenAVEDEV(A1:A5) equals 7.84.See also STDEV.
NORMDISTNORMDISTNORMDIST(x,mean,stdev,cumulative)DescriptionNORMDIST function returns the normal cumulative distribution. @x is the value for which you want the distribution, @mean is the mean of the distribution, @stdev is the standard deviation.If @stdev is 0 NORMDIST returns #DIV/0! error. This function is Excel compatible.ExamplesNORMDIST(2,1,2,0) equals 0.176032663.See also POISSON.
GEOMEANGEOMEANGEOMEAN(b1, b2, ...)DescriptionGEOMEAN returns the geometric mean of the given arguments. This is equal to the Nth root of the product of the terms. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenGEOMEAN(A1:A5) equals 21.279182482.See also AVERAGE,
HARMEAN,
MEDIAN,
MODE,
TRIMMEAN.
TIMETIMETIME (hours,minutes,seconds)DescriptionReturns a fraction representing the time of day.ExamplesSee also HOUR.
MINMINMIN(b1, b2, ...)DescriptionMIN returns the value of the element of the values passed that has the smallest value. With negative numbers considered smaller than positive numbers. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenMIN(A1:A5) equals 11.4.See also MAX,
ABS.
MEDIANMEDIANMEDIAN(n1, n2, ...)DescriptionMEDIAN returns the median of the given data set.Strings and empty cells are simply ignored. If even numbers are given MEDIAN returns the average of the two numbers in the middle. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenMEDIAN(A1:A5) equals 21.3.See also AVERAGE,
COUNT,
COUNTA,
DAVERAGE,
MODE,
SUM.
FREQUENCYFREQUENCYFREQUENCY(data_array,bins_array)DescriptionFREQUENCY function counts how often given values occur within a range of values. The results are given as an array.@data_array is a data array for which you want to count the frequencies. @bin_array is an array containing the intervals into which you want to group the values in data_array. If the @bin_array is empty, FREQUENCY returns the number of data points in @data_array. This function is Excel compatible.ExamplesSee alsoGAMMAINVGAMMAINVGAMMAINV(p,alpha,beta)DescriptionGAMMAINV function returns the inverse of the cumulative gamma distribution.If @p < 0 or @p > 1 GAMMAINV returns #NUM! error. If @alpha <= 0 or @beta <= 0 GAMMAINV returns #NUM! error. This function is Excel compatible.ExamplesGAMMAINV(0.34,2,4) equals 4.829093908.See also GAMMADIST.
IMSUBIMSUBIMSUB(inumber,inumber)DescriptionIMSUB returns the difference of two complex numbers. This function is Excel compatible.ExamplesIMSUB("3-j","2+j") equals 1-2j.See also IMSUM.
ISTEXTISTEXTISTEXT(value)DescriptionISTEXT returns TRUE if the value is text. This function is Excel compatible.ExamplesSee also ISNONTEXT.
SQRTSQRTSQRT(x)DescriptionSQRT function returns the square root of @x. This function is Excel compatible.If @x is negative, SQRT returns #NUM! error.ExamplesSQRT(2) equals 1.4142136.See also POWER.
COUPDAYSNCCOUPDAYSNCCOUPDAYSNC(settlement,maturity,frequency[,basis])DescriptionReturns the number of days from the settlement date to the next coupon date.ExamplesSee alsoINTERCEPTINTERCEPTINTERCEPT(known_y's,known_x's)DescriptionINTERCEPT function calculates the point where the linear regression line intersects the y-axis.If @known_x or @known_y contains no data entries or different number of data entries, INTERCEPT returns #N/A! error. If the variance of the @known_x is zero, INTERCEPT returns #DIV/0 error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenINTERCEPT(A1:A5,B1:B5) equals -20.785117212.See also FORECAST,
TREND.
LENLENLEN(string)DescriptionLEN returns the length in characters of the string @string.Exampleslen("Helsinki") equals 8.See also CHAR,
CODE.
RIGHTRIGHTRIGHT(text[,num_chars])DescriptionRIGHT returns the rightmost @num_chars characters or the right character if @num_chars is not specified.ExamplesRIGHT("end") equals "d".RIGHT("end",2) equals "nd".See also MID,
LEFT.
PERMUTPERMUTPERMUT(n,k)DescriptionPERMUT function returns the number of permutations. @n is the number of objects, @k is the number of objects in each permutation.If @n = 0 PERMUT returns #NUM! error. If @n < @k PERMUT returns #NUM! error. This function is Excel compatible.ExamplesPERMUT(7,3) equals 210.See also COMBIN.
ODDFPRICEODDFPRICEODDFPRICE(settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis)DescriptionExamplesSee alsoAVERAGEAAVERAGEAAVERAGEA(number1,number2,...)DescriptionAVERAGEA returns the average of the given arguments. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenAVERAGEA(A1:A5) equals 18.94.See also AVERAGE.
PERCENTRANKPERCENTRANKPERCENTRANK(array,x[,significance])DescriptionPERCENTRANK function returns the rank of a data point in a data set. @array is the range of numeric values, @x is the data point which you want to rank, and the optional @significance indentifies the number of significant digits for the returned value. If @significance is omitted, PERCENTRANK uses three digits.If @array contains not data points, PERCENTRANK returns #NUM! error. If @significance is less than one, PERCENTRANK returns #NUM! error. If @x does not match any of the values in @array or @x matches more than once, PERCENTRANK interpolates the returned value.ExamplesSee also LARGE,
MAX,
MEDIAN,
MIN,
PERCENTILE,
QUARTILE,
SMALL.
RANDNEGBINOMRANDNEGBINOMRANDNEGBINOM(p,failures)DescriptionRANDNEGBINOM returns a negitive binomialy distributed random number.If @p < 0 or @p > 1, RANDNEGBINOM returns #NUM! error. If @failures RANDNEGBINOM returns #NUM! error.ExamplesRANDNEGBINOM(0.5,2).See also RAND,
RANDBETWEEN.
COUPDAYSCOUPDAYSCOUPDAYS(settlement,maturity,frequency[,basis])DescriptionReturns the number of days in the coupon period of the settlement date.ExamplesSee alsoDATEDATEDATE (year,month,day)DescriptionComputes the number of days since the 1st of january of 1900(the date serial number) for the given year, month and day.The @day might be negative (to count backwards) and it is relative to the previous @month. The @years should be at least 1900.ExamplesSee also TODAY,
NOW.
STEYXSTEYXSTEYX(known_y's,known_x's)DescriptionSTEYX function returns the standard error of the predicted y-value for each x in the regression.If @known_y's and @known_x's are empty or have a different number of arguments then STEYX returns #N/A! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenSTEYX(A1:A5,B1:B5) equals 1.101509979.See also PEARSON,
RSQ,
SLOPE.
OCT2BINOCT2BINOCT2BIN(number[,places])DescriptionThe OCT2BIN function converts an octal number to a binary number. @places is an optional field, specifying to zero pad to that number of spaces. This function is Excel compatible.If @places is too small or negative #NUM! error is returned.ExamplesOCT2BIN("213") equals 10001011.See also BIN2OCT,
OCT2DEC,
OCT2HEX.
PRICEMATPRICEMATPRICEMAT(settlement,maturity,issue,rate,yield[,basis])DescriptionPRICEMAT calculates and returns the price per $100 face value of a security. The security pays interest at maturity. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, PRICEMAT returns #NUM! error. If @basis < 0 or @basis > 4, PRICEMAT returns #NUM! error. If @settlement date is after @maturity date or they are the same, PRICEMAT returns #NUM! error.ExamplesSee also PRICEDISC.
IMCONJUGATEIMCONJUGATEIMCONJUGATE(inumber)DescriptionIMCONJUGATE returns the complex conjugate of a complex number. This function is Excel compatible.ExamplesIMCONJUGATE("1-j") equals 1+j.See also IMAGINARY,
IMREAL.
SUMIFSUMIFSUMIF(range,criteria[,actual_range])DescriptionSUMIF function sums the values in the given @range that meet the given @criteria. If @actual_range is given, SUMIF sums the values in the @actual_range whose corresponding components in @range meet the given @criteria. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 23, 27, 28, 33, and 39. ThenSUMIF(A1:A5,"<=28") equals 78.SUMIF(A1:A5,"<28") equals 50.In addition, if the cells B1, B2, ..., B5 hold numbers 5, 3, 2, 6, and 7 then:SUMIF(A1:A5,"<=27",B1:B5) equals 8.See also COUNTIF,
SUM.
LINESTLINESTLINEST(known_y's[,known_x's[,const[,stat]]])DescriptionLINEST function calculates the ``least squares'' line that best fit to your data in @known_y's. @known_x's contains the corresponding x's where y=mx+b.If @known_x's is omitted, an array {1, 2, 3, ...} is used. LINEST returns an array having two columns and one row. The slope (m) of the regression line y=mx+b is given in the first column and the y-intercept (b) in the second.If @known_y's and @known_x's have unequal number of data points, LINEST returns #NUM! error.If @const is FALSE, the line will be forced to go through the origin, i.e., b will be zero. The default is TRUE.If @stat is TRUE, extra statistical information will be returned. Extra statistical information is written bellow the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares.The default of @stat is FALSE.ExamplesSee also LOGEST,
TREND.
IMREALIMREALIMREAL(inumber)DescriptionIMREAL returns the real coefficient of a complex number. This function is Excel compatible.Examplesimreal("132-j") equals 132.See also IMAGINARY.
IMSUMIMSUMIMSUM(inumber,inumber)DescriptionIMSUM returns the sum of two complex numbers. This function is Excel compatible.ExamplesIMSUM("2-4j","9-j") equals 11-5j.See also IMSUB.
SERIESSUMSERIESSUMSERIESSUM(x,n,m,coefficients)DescriptionSERIESSUM function returns the sum of a power series. @x is the base of the power serie, @n is the initial power to raise @x, @m is the increment to the power for each term in the series, and @coefficients is the coefficents by which each successive power of @x is multiplied. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 1.23, 2.32, 2.98, 3.42, and 4.33. ThenSERIESSUM(3,1,2.23,A1:A5) equals 251416.43018.See also COUNT,
SUM.
XIRRXIRRXIRR(values,dates[,guess])DescriptionXIRR calculates and returns the internal rate of return of an investment that has not necessarily periodic payments. This function is closely related to the net present value function (NPV and XNPV). The XIRR is the interest rate for a serie of cash flow where the XNPV is zero.@values contains the serie of cash flow generated by the investment. @dates contains the dates of the payments. The first date describes the payment day of the initial payment and thus all the other dates should be after this date. The optional @guess is the initial value used in calculating the XIRR. You do not have to use that, it is only provided for the Excel compatibility.This function is Excel compatible.ExamplesLet us assume that the cells A1:A5 contain the numbers -6000, 2134, 1422, 1933, and 1422, and the cells B1:B5 contain the dates "1999-01-15", "1999-04-04", "1999-05-09", "2000-03-12", and "2000-05-1". ThenXIRR(A1:A5,B1:B5) returns 0.224838.See also IRR,
XNPV.
LEFTLEFTLEFT(text[,num_chars])DescriptionLEFT returns the leftmost @num_chars characters or the left character if @num_chars is not specified.ExamplesLEFT("Directory",3) equals "Dir".See also MID,
RIGHT.
DURATIONDURATIONDURATION(rate,pv,fv)DescriptionDURATION calculates number of periods needed for an investment to attain a desired value. This function is similar to FV and PV with a difference that we do not need give the direction of cash flows e.g. -100 for a cash outflow and +100 for a cash inflow.ExamplesSee also PPMT,
PV,
FV.
COMPLEXCOMPLEXCOMPLEX(real,im[,suffix])DescriptionCOMPLEX returns a complex number of the form x + yi. @real is the real and @im is the imaginary coefficient of the complex number. @suffix is the suffix for the imaginary coefficient. If it is omitted, COMPLEX uses 'i' by default.If @suffix is neither 'i' nor 'j', COMPLEX returns #VALUE! error. This function is Excel compatible.ExamplesCOMPLEX(1,-1) equals 1-i.See alsoDEC2HEXDEC2HEXDEC2HEX(number[,places])DescriptionDEC2HEX function converts a decimal number to a hexadecimal number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesDEC2HEX(42) equals 2A.See also HEX2DEC,
DEC2BIN,
DEC2OCT.
COLUMNSCOLUMNSCOLUMNS(reference)DescriptionThe COLUMNS function returns the number of columns in area or array reference.If @reference is neither an array nor a reference nor a range returns #VALUE!.ExamplesSee also COLUMN,
ROW,
ROWS.
LNLNLN(x)DescriptionLN returns the natural logarithm of @x. If @x <= 0, LN returns #NUM! error. This function is Excel compatible.ExamplesLN(7) equals 1.94591.See also EXP,
LOG2,
LOG10.
DGETDGETDGET(database,field,criteria)DescriptionDGET function returns a single value from a column that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DGET(A1:C7, "Salary", A9:A10) equals 34323.DGET(A1:C7, "Name", A9:A10) equals "Clark".If none of the items match the conditions, DGET returns #VALUE! error. If more than one items match the conditions, DGET returns #NUM! error.See also DCOUNT.
FALSEFALSEFALSE()DescriptionFALSE returns boolean value false. This function is Excel compatible.ExamplesFALSE() equals FALSE.See also TRUE.
DATEVALUEDATEVALUEDATEVALUE(date_str)DescriptionDATEVALUE returns the serial number of the date. @date_str is the string that contains the date. For example, DATEVALUE("1/1/1999") equals to 36160.ExamplesSee also DATE.
COUNTBLANKCOUNTBLANKCOUNTBLANK(range)DescriptionCOUNTBLANK returns the number of blank cells in a @range. This function is Excel compatible.ExamplesSee also COUNT.
AVERAGEAVERAGEAVERAGE(value1, value2,...)DescriptionAVERAGE computes the average of all the values and cells referenced in the argument list. This is equivalent to the sum of the arguments divided by the count of the arguments. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenAVERAGE(A1:A5) equals 23.2.See also SUM,
COUNT.
CORRELCORRELCORREL(array1,array2)DescriptionCORREL returns the correlation coefficient of two data sets.Strings and empty cells are simply ignored. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenCORREL(A1:A5,B1:B5) equals 0.996124788.See also COVAR,
FISHER,
FISHERINV.
CUMIPMTCUMIPMTCUMIPMT(rate,nper,pv,start_period,end_period,type)DescriptionReturns the cumulative interest paid on a loan between @start_period and @end_period.ExamplesSee alsoSUMSQSUMSQSUMSQ(value1, value2, ...)DescriptionSUMSQ returns the sum of the squares of all the values and cells referenced in the argument list. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43. ThenSUMSQ(A1:A5) equals 2925.See also SUM,
COUNT.
IMPRODUCTIMPRODUCTIMPRODUCT(inumber1[,inumber2,...])DescriptionIMPRODUCT returns the product of given complex numbers. This function is Excel compatible.ExamplesIMPRODUCT("2-j","4-2j") equals 6-8j.See also IMDIV.
CHARCHARCHAR(x)DescriptionCHAR returns the ASCII character represented by the number @x.ExamplesCHAR(65) equals A.See also CODE.
PMTPMTPMT(rate,nper,pv[,fv,type])DescriptionFIXME: Below is a PV function description!PMT calculates the present value of an investment.ExamplesSee also PPMT,
PV,
FV.
DAYDAYDAY (serial_number)DescriptionConverts a serial number to a day of month.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.Examplesday ("10/24/1968") equals 24.See also MONTH,
TIME,
NOW,
YEAR.
GROWTHGROWTHGROWTH(known_y's[,known_x's,new_x's,const])DescriptionGROWTH function applies the ``least squares'' method to fit an exponential curve to your data and predicts the exponential growth by using this curve.If @known_x's is omitted, an array {1, 2, 3, ...} is used. If @new_x's is omitted, it is assumed to be the same as @known_x's.GROWTH returns an array having one column and a row for each data point in @new_x.If @known_y's and @known_x's have unequal number of data points, GROWTH returns #NUM! error.If @const is FALSE, the line will be forced to go through the origin, i.e., b will be zero. The default is TRUE.ExamplesSee also LOGEST,
GROWTH,
TREND.
INDEXINDEXINDEX(reference,[row, col, area])DescriptionThe INDEX function returns a reference to the cell at a offset into the reference specified by row, col.If things go wrong returns #REF!ExamplesSee alsoSQRTPISQRTPISQRTPI(number)DescriptionSQRTPI function returns the square root of a @number multiplied by pi. This function is Excel compatible.ExamplesSQRTPI(2) equals 2.506628275.See also PI.
FISHERFISHERFISHER(x)DescriptionFISHER function returns the Fisher transformation at @x.If @x is not-number FISHER returns #VALUE! error. If @x <= -1 or @x >= 1 FISHER returns #NUM! error. This function is Excel compatible.ExamplesFISHER(0.332) equals 0.345074339.See also SKEW.
VARAVARAVARA(number1,number2,...)DescriptionVARA returns the variance based on a sample. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenVARA(A1:A5) equals 228.613.See also VAR,
VARPA.
DMAXDMAXDMAX(database,field,criteria)DescriptionDMAX function returns the largest number in a column that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DMAX(A1:C7, "Salary", A9:A11) equals 47242.DMAX(A1:C7, "Age", A9:A11) equals 45.DMAX(A1:C7, "Age", A9:B11) equals 43.See also DMIN.
ISLOGICALISLOGICALISLOGICAL(value)DescriptionISLOGICAL returns TRUE if the value is a logical value. This function is Excel compatible.ExamplesSee alsoATAN2ATAN2ATAN2(b1,b2)DescriptionATAN2 function calculates the arc tangent of the two variables @b1 and @b2. It is similar to calculating the arc tangent of @b2 / @b1, except that the signs of both arguments are used to determine the quadrant of the result. The result is in radians. This function is Excel compatible.ExamplesATAN2(0.5,1.0) equals 1.107149.ATAN2(-0.5,2.0) equals 1.815775.See also ATAN,
ATANH,
COS,
SIN,
DEGREES,
RADIANS.
MINAMINAMINA(number1,number2,...)DescriptionMINA returns the smallest value of the given arguments. Numbers, text and logical values are included in the calculation, blank cells are not. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenMAXA(A1:A5) equals 40.1.See also MIN,
MAXA.
LOOKUPLOOKUPLOOKUP(value,vector1,vector2)DescriptionThe LOOKUP function finds the row index of 'value' in @vector1 and returns the contents of value2 at that row index. If the area is longer than it is wide then the sense of the search is rotated. Alternatively a single array can be used.If LOOKUP can't find @value it uses the next largest value less than value. The data must be sorted.If @value is smaller than the first value it returns #N/AExamplesSee also VLOOKUP,
HLOOKUP.
CEILCEILCEIL(x)DescriptionCEIL function rounds @x up to the next nearest integer.This function is Excel compatible.ExamplesCEIL(0.4) equals 1.CEIL(-1.1) equals -1.CEIL(-2.9) equals -2.See also ABS,
FLOOR,
INT.
MDETERMMDETERMMDETERM(matrix)DescriptionMDETERM function returns the determinant of a given matrix.If the @matrix does not contain equal number of columns and rows, MDETERM returns #VALUE! error. This function is Excel compatible.ExamplesLet us assume that A1, ..., A4 contain numbers 2, 3, 7, and 3, B1, ..., B4 4, 2, 4, and 1, C1, ..., C4 9, 4, 3, and 2, and D1, ..., D4 7, 3, 6, and 5. ThenMDETERM(A1:D4) equals 148.See also MMULT,
MINVERSE.
COUPNCDCOUPNCDCOUPNCD(settlement,maturity,frequency[,basis])DescriptionReturns the coupon date following settlement.ExamplesSee alsoMDURATIONMDURATIONMDURATION(settlement,maturity,coupon,yield,frequency[,basis])DescriptionReturns the Macauley duration for a security with par value 100.ExamplesSee alsoHEX2DECHEX2DECHEX2DEC(x)DescriptionThe HEX2DEC function converts a hexadecimal number to its decimal equivalent. This function is Excel compatible.ExamplesHEX2DEC("2A") equals 42.See also DEC2HEX,
HEX2BIN,
HEX2OCT.
MINUTEMINUTEMINUTE (serial_number)DescriptionConverts a serial number to a minute. The minute is returned as an integer in the range 0 to 59.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also HOUR,
NOW,
TIME,
SECOND.
VARPAVARPAVARPA(number1,number2,...)DescriptionVARPA returns the variance based on the entire population. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenVARPA(A1:A5) equals 182.8904.See also VARP,
VARP.
NOTNOTNOT(number)DescriptionNOT implements the logical NOT function: the result is TRUE if the @number is zero; otherwise the result is FALSE.This function is Excel compatible.ExamplesNOT(0) equals TRUE.NOT(TRUE) equals FALSE.See also AND,
OR.
TINVTINVTINV(p,dof)DescriptionTINV function returns the inverse of the two-tailed Student's t-distribution.If @p < 0 or @p > 1 or @dof < 1 TINV returns #NUM! error. This function is Excel compatible.ExamplesTINV(0.4,32) equals 0.852998454.See also TDIST,
TTEST.
TANTANTAN(x)DescriptionTAN function returns the tangent of @x, where @x is given in radians. This function is Excel compatible.ExamplesTAN(3) equals -0.1425465.See also TANH,
COS,
COSH,
SIN,
SINH,
DEGREES,
RADIANS.
G_PRODUCTG_PRODUCTG_PRODUCT(value1, value2, ...)DescriptionPRODUCT returns the product of all the values and cells referenced in the argument list. Empty cells are ignored and the empty product in 1.ExamplesG_PRODUCT(2,5,9) equals 90.See also SUM,
COUNT.
SUMXMY2SUMXMY2SUMXMY2(array1,array2)DescriptionSUMXMY2 function returns the sum of squares of differences of corresponding values in two arrays. @array1 is the first array or range of data points and @array2 is the second array or range of data points. The equation of SUMXMY2 is SUM (x-y)^2.Strings and empty cells are simply ignored.If @array1 and @array2 have different number of data points, SUMXMY2 returns #N/A! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43 and the cells B1, B2, ..., B5 hold numbers 13, 22, 31, 33, and 39. ThenSUMXMY2(A1:A5,B1:B5) equals 409.See also SUMSQ,
SUMX2MY2,
SUMX2PY2.
NOWNOWNOW ()DescriptionReturns the serial number for the date and time at the time it is evaluated.Serial Numbers in Gnumeric are represented as follows:The integral part is the number of days since the 1st of January of 1900. The decimal part represent the fraction of the day and is mapped into hour, minutes and seconds.For example: .0 represents the beginning of the day, and 0.5 represents noon.ExamplesSee also TODAY,
NOW.
NANANA()DescriptionNA returns the error value #N/A. This function is Excel compatible.ExamplesSee alsoBETAINVBETAINVBETAINV(p,alpha,beta[,a,b])DescriptionBETAINV function returns the inverse of cumulative beta distribution. @a is the optional lower bound of @x and @b is the optinal upper bound of @x. If @a is not given, BETAINV uses 0. If @b is not given, BETAINV uses 1.If @p < 0 or @p > 1 BETAINV returns #NUM! error. If @alpha <= 0 or @beta <= 0, BETAINV returns #NUM! error. If @a >= @b BETAINV returns #NUM! error. This function is Excel compatible.ExamplesBETAINV(0.45,1.6,1) equals 0.607096629.See also BETADIST.
ROWSROWSROWS(reference)DescriptionThe ROWS function returns the number of rows in area or array reference.If @reference is neither an array nor a reference nor a range returns #VALUE!.ExamplesSee also COLUMN,
ROW,
ROWS.
DSTDEVPDSTDEVPDSTDEVP(database,field,criteria)DescriptionDSTDEVP function returns the standard deviation of a population based on the entire populations. The populations consists of numbers that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DSTDEVP(A1:C7, "Age", A9:B11) equals 7.DSTDEVP(A1:C7, "Salary", A9:B11) equals 6459.5.See also DSTDEV.
CHITESTCHITESTCHITEST(actual_range,theoretical_range)DescriptionCHITEST function returns the test for independence of chi-squared distribution.@actual_range is a range that contains the observed data points. @theoretical_range is a range that contains the expected values of the data points. This function is Excel compatible.ExamplesSee also CHIDIST,
CHIINV.
CRITBINOMCRITBINOMCRITBINOM(trials,p,alpha)DescriptionCRITBINOM function returns the smallest value for which thecumulative is greater than or equal to a given value. @n is the number of trials, @p is the probability of success in trials, and @alpha is the criterion value.If @trials is a non-integer it is truncated. If @trials < 0 CRITBINOM returns #NUM! error. If @p < 0 or @p > 1 CRITBINOM returns #NUM! error. If @alpha < 0 or @alpha > 1 CRITBINOM returns #NUM! error. This function is Excel compatible.ExamplesCRITBINOM(10,0.5,0.75) equals 6.See also BINOMDIST.
SUMPRODUCTSUMPRODUCTSUMPRODUCT(range1,range2,...)DescriptionSUMPRODUCT function multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products. If an array entry is not numeric, the value zero is used instead.If arrays or range arguments do not have the same dimentions, SUMPRODUCT returns #VALUE! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43 and the cells B1, B2, ..., B5 hold numbers 13, 22, 31, 33, and 39. ThenSUMPRODUCT(A1:A5,B1:B5) equals 3370.See also SUM,
PRODUCT.
INTINTINT(a)DescriptionThe INT function returns the largest integer that is not bigger than its argument. This function is Excel compatible.ExamplesINT(7.2) equals 7.INT(-5.5) equals -6.See also FLOOR,
CEIL,
ABS.
BINOMDISTBINOMDISTBINOMDIST(n,trials,p,cumulative)DescriptionBINOMDIST function returns the binomial distribution. @n is the number of successes, @trials is the total number of independent trials, @p is the probability of success in trials, and @cumulative describes whether to return the sum of thebinomial function from 0 to @n.If @n or @trials are non-integer they are truncated. If @n < 0 or @trials < 0 BINOMDIST returns #NUM! error. If @n > trials BINOMDIST returns #NUM! error. If @p < 0 or @p > 1 BINOMDIST returns #NUM! error. This function is Excel compatible.ExamplesBINOMDIST(3,5,0.8,0) equals 0.2048.See also POISSON.
DBDBDB(cost,salvage,life,period[,month])DescriptionDB calculates the depreciation of an asset for a given period using the fixed-declining balance method. @cost is the initial value of the asset. @salvage is the value after the depreciation. @life is the number of periods overall. @period is the period for which you want the depreciation to be calculated. @month is the number of months in the first year of depreciation. If @month is omitted, it is assumed to be 12.ExamplesSee also DDB,
SLN,
SYD.
IMLOG2IMLOG2IMLOG2(inumber)DescriptionIMLOG2 returns the logarithm of a complex number in base 2. This function is Excel compatible.ExamplesIMLOG2("3-j") equals 1.66096-0.46419j.See also IMLN,
IMLOG10.
VARPVARPVARP(b1, b2, ...)DescriptionVARP calculates the variance of a set of numbers where each number is a member of a population and the set is the entire population.(VARP is also known as the N-variance.)ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenVARP(A1:A5) equals 94.112.See also AVERAGE,
DVAR,
DVARP,
STDEV,
VAR.
AMORLINCAMORLINCAMORLINC(cost,purchase_date,first_period,salvage,period,rate,basis)DescriptionReturns the depreciation for each accounting period.ExamplesSee alsoEXACTEXACTEXACT(string1, string2)DescriptionEXACT returns true if @string1 is exactly equal to @string2 (this routine is case sensitive).ExamplesEXACT("key","key") equals TRUE.EXACT("key","Key") equals FALSE.See also LEN.
EDATEEDATEEDATE(date,months)DescriptionEDATE returns the serial number of the date that is the specified number of months before or after a given date. @date is the serial number of the initial date and @months is the number of months before (negative number) or after (positive number) the initial date.If @months is not an integer, it is truncated.ExamplesSee also DATE.
DVARDVARDVAR(database,field,criteria)DescriptionDVAR function returns the estimate of variance of a population based on a sample. The populations consists of numbers that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DVAR(A1:C7, "Age", A9:B11) equals 98.DVAR(A1:C7, "Salary", A9:B11) equals 83450280.5.See also DVARP.
YEARYEARYEAR (serial_number)DescriptionConverts a serial number to a year.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also DAY,
MONTH,
TIME,
NOW.
LOWERLOWERLOWER(text)DescriptionLOWER returns a lower-case version of the string in @text.ExamplesLOWER("J. F. Kennedy") equals "j. f. kennedy".See also UPPER.
TIMEVALUETIMEVALUETIMEVALUE (timetext)DescriptionReturns a fraction representing the time of day, a number between 0 and 1.ExamplesSee also HOUR.
DEC2OCTDEC2OCTDEC2OCT(number[,places])DescriptionDEC2OCT function converts a decimal number to an octal number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesDEC2OCT(42) equals 52.See also OCT2DEC,
DEC2BIN,
DEC2HEX.
RANDRANDRAND()DescriptionRAND returns a random number between zero and one ([0..1]). This function is Excel compatible.ExamplesRAND() returns a random number greater than zero but less than one.See also RANDBETWEEN.
KURTKURTKURT(n1, n2, ...)DescriptionKURT returns an unbiased estimate of the kurtosis of a data set.Note, that this is only meaningful is the underlying distribution really has a fourth moment. The kurtosis is offset by three such that a normal distribution will have zero kurtosis.Strings and empty cells are simply ignored.If fewer than four numbers are given or all of them are equal KURT returns #DIV/0! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenKURT(A1:A5) equals 1.234546305.See also AVERAGE,
VAR,
SKEW,
KURTP.
BIN2DECBIN2DECBIN2DEC(x)DescriptionBIN2DEC function converts a binary number in string or number to its decimal equivalent. This function is Excel compatible.ExamplesBIN2DEC(101) equals 5.See also DEC2BIN,
BIN2OCT,
BIN2HEX.
ERFERFERF([lower limit,]upper_limit)DescriptionWith a single argument ERF returns the error function, defined as erf(x) = 2/sqrt(pi)* integral from 0 to x of exp(-t*t) dt. If two arguments are supplied, they are the lower and upper limits of the integral.If either @lower_limit or @upper_limit is not numeric a #VALUE! error is returned. This function is upward-compatible with that in Excel. (If two arguments are supplied, Excel will not allow either to be negative.)ExamplesERF(0.4) equals 0.428392355.ERF(1.6448536269515/SQRT(2)) equals 0.90.The second example shows that a random variable with a normal distribution has a 90 percent chance of falling within approximately 1.645 standard deviations of the mean.See also ERFC.
MAXMAXMAX(b1, b2, ...)DescriptionMAX returns the value of the element of the values passed that has the largest value. With negative numbers considered smaller than positive numbers. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenMAX(A1:A5) equals 40.1.See also MIN,
ABS.
NEGBINOMDISTNEGBINOMDISTNEGBINOMDIST(f,t,p)DescriptionNEGBINOMDIST function returns the negative binomial distribution. @f is the number of failures, @t is the threshold number of successes, and @p is the probability of a success.If @f or @t is a non-integer it is truncated. If (@f + @t -1) <= 0 NEGBINOMDIST returns #NUM! error. If @p < 0 or @p > 1 NEGBINOMDIST returns #NUM! error. This function is Excel compatible.ExamplesNEGBINOMDIST(2,5,0.55) equals 0.152872629.See also BINOMDIST,
COMBIN,
FACT,
HYPGEOMDIST,
PERMUT.
DOLLARDEDOLLARDEDOLLARDE(fractional_dollar,fraction)DescriptionDOLLARDE converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.If @fraction is non-integer it is truncated. If @fraction <= 0, DOLLARDE returns #NUM! error.ExamplesSee also DOLLARFR.
EOMONTHEOMONTHEOMONTH (start_date,months)DescriptionReturns the last day of the month which is @months from the @start_date.Returns #NUM! if start_date or months are invalid.ExamplesIf A1 contains 12/21/00 then EOMONTH(A1,0)=12/31/00, EOMONTH(A1,5)=5/31/01, and EOMONTH(A1,2)=2/28/01See also MONTH.
MROUNDMROUNDMROUND(number,multiple)DescriptionMROUND function rounds a given number to the desired multiple. @number is the number you want rounded and @multiple is the the multiple to which you want to round the number.If @number and @multiple have different sign, MROUND returns #NUM! error. This function is Excel compatible.ExamplesMROUND(1.7,0.2) equals 1.8.MROUND(321.123,0.12) equals 321.12.See also ROUNDDOWN,
ROUND,
ROUNDUP.
DEVSQDEVSQDEVSQ(n1, n2, ...)DescriptionDEVSQ returns the sum of squares of deviations of a data set from the sample mean.Strings and empty cells are simply ignored. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenDEVSQ(A1:A5) equals 470.56.See also STDEV.
SELECTIONSELECTIONSELECTION(permit_intersection)DescriptionThe SELECTION function returns a list with the values in the current selection. This is usually used to implement on-the-fly computation of values. If @permit_intersection is TRUE the user specifed selection ranges are returned, EVEN IF THEY OVERLAP. If @permit_intersection is FALSE a distict set of regions is returned, however, there may be more of them than the user initially specified.ExamplesSee alsoROUNDROUNDROUND(number[,digits])DescriptionROUND function rounds a given number. @number is the number you want rounded and @digits is the number of digits to which you want to round that number.If @digits is greater than zero, @number is rounded to the given number of digits. If @digits is zero or omitted, @number is rounded to the nearest integer. If @digits is less than zero, @number is rounded to the left of the decimal point. This function is Excel compatible.ExamplesROUND(5.5) equals 6.ROUND(-3.3) equals -3.ROUND(1501.15,1) equals 1501.2.ROUND(1501.15,-2) equals 1500.0.See also ROUNDDOWN,
ROUNDUP.
FINDFINDFIND(string1,string2[,start])DescriptionFIND returns position of @string1 in @string2 (case-sesitive), searching only from character @start onwards (assumed 1 if omitted).ExamplesFIND("ac","Jack") equals 2.See also EXACT,
LEN,
MID,
SEARCH.
VALUEVALUEVALUE(text)DescriptionVALUE returns numeric value of @text.ExamplesVALUE("$1,000") equals 1000.See also DOLLAR,
FIXED,
TEXT.
WEIBULLWEIBULLWEIBULL(x,alpha,beta,cumulative)DescriptionWEIBULL function returns the Weibull distribution. If the @cumulative boolean is true it will return: 1 - exp (-(@x/@beta)^@alpha), otherwise it will return (@alpha/@beta^@alpha) * @x^(@alpha-1) * exp(-(@x/@beta^@alpha)).If @x < 0 WEIBULL returns #NUM! error. If @alpha <= 0 or @beta <= 0 WEIBULL returns #NUM! error. This function is Excel compatible.ExamplesWEIBULL(3,2,4,0) equals 0.213668559.See also POISSON.
BIN2HEXBIN2HEXBIN2HEX(number[,places])DescriptionBIN2HEX function converts a binary number to a hexadecimal number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesBIN2HEX(100111) equals 27.See also HEX2BIN,
BIN2OCT,
BIN2DEC.
DDBDDBDDB(cost,salvage,life,period[,factor])DescriptionDDB returns the depreciation of an asset for a given period using the double-declining balance method or some other similar method you specify. @cost is the initial value of the asset, @salvage is the value after the last period, @life is the number of periods, @period is the period for which you want the depreciation to be calculated, and @factor is the factor at which the balance declines. If @factor is omitted, it is assumed to be two (double-declining balance method).ExamplesSee also SLN,
SYD.
NPVNPVNPV(rate,v1,v2,...)DescriptionNPV calculates the net present value of an investment generating peridic payments. @rate is the periodic interest rate and @v1, @v2, ... are the periodic payments. If the schedule of the cash flows are not periodic use the XNPV function.ExamplesNPV(0.17,-10000,3340,2941,2493,3233,1732,2932) equals 186.30673.See also PV,
XNPV.
VLOOKUPVLOOKUPVLOOKUP(value,range,column[,approximate])DescriptionVLOOKUP function finds the row in range that has a first column similar to value. If @approximate is not true it finds the row with an exact equivilance. If @approximate is true, then the values must be sorted in order of ascending value for correct function; in this case it finds the row with value less than @value. It returns the value in the row found at a 1 based offset in @column columns into the @range.Returns #NUM! if @column < 0. Returns #REF! if @column falls outside @range.ExamplesSee also HLOOKUP.
DAVERAGEDAVERAGEDAVERAGE(database,field,criteria)DescriptionDAVERAGE function returns the average of the values in a list or database that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DAVERAGE(A1:C7, "Salary", A9:A11) equals 42296.3333.DAVERAGE(A1:C7, "Age", A9:A11) equals 39.DAVERAGE(A1:C7, "Salary", A9:B11) equals 40782.5.DAVERAGE(A1:C7, "Age", A9:B11) equals 36.See also DCOUNT.
MINVERSEMINVERSEMINVERSE(matrix)DescriptionMINVERSE function returns the inverse matrix of a given matrix.If the @matrix cannot be inverted, MINVERSE returns #NUM! error. If the @matrix does not contain equal number of columns and rows, MINVERSE returns #VALUE! error. This function is Excel compatible.ExamplesSee also MMULT,
MDETERM.
LOGNORMDISTLOGNORMDISTLOGNORMDIST(x,mean,stdev)DescriptionLOGNORMDIST function returns the lognormal distribution. @x is the value for which you want the distribution, @mean is the mean of the distribution, and @stdev is the standard deviation of the distribution. This function is Excel compatible.If @stdev = 0 LOGNORMDIST returns #DIV/0! error. If @x <= 0, @mean < 0 or @stdev < 0 LOGNORMDIST returns #NUM! error.ExamplesLOGNORMDIST(3,1,2) equals 0.519662338.See also NORMDIST.
RANKRANKRANK(x,ref[,order])DescriptionRANK returns the rank of a number in a list of numbers. @x is the number whose rank you want to find, @ref is the list of numbers, and @order specifies how to rank numbers. If @order is 0, numbers are ranked in descending order, otherwise numbers are ranked in ascending order. This function is Excel compatible.ExamplesSee also PERCENTRANK.
INTRATEINTRATEINTRATE(settlement,maturity,investment,redemption[,basis])DescriptionINTRATE calculates and returns the interest rate of a fully vested security. @investment is the prize of the security paid at @settlement date and @redemption is the amount to be received at @maturity date. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, INTRATE returns #NUM! error. If @basis < 0 or @basis > 4, INTRATE returns #NUM! error. If @settlement date is after @maturity date or they are the same, INTRATE returns #NUM! error.ExamplesIf you had a bond with a settlement date of April 15, 2000, maturity date September 30, 2000, investment of $100,000, redemption value $103,525, using the actual/actual basis, the bond discount rate is:=INTRATE(36631, 36799, 100000, 103525, 1) which equals 0.0648 or 6.48%See also RECEIVED,
DATE.
BESSELIBESSELIBESSELI(x,y)DescriptionBESSELI function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the bessel function, if non-integer it is truncated.If @x or @y are not numeric a #VALUE! error is returned. If @y < 0 a #NUM! error is returned. This function is Excel compatible.ExamplesBESSELI(0.7,3) equals 0.007367374.See also BESSELJ,
BESSELK,
BESSELY.
BESSELJBESSELJBESSELJ(x,y)DescriptionBESSELJ function returns the bessel function with @x is where the function is evaluated. @y is the order of the bessel function, if non-integer it is truncated.If @x or @y are not numeric a #VALUE! error is returned. If @y < 0 a #NUM! error is returned. This function is Excel compatible.ExamplesBESSELJ(0.89,3) equals 0.013974004.See also BESSELJ,
BESSELK,
BESSELY.
COUPPCDCOUPPCDCOUPPCD(settlement,maturity,frequency[,basis])DescriptionReturns the coupon date preceeding settlement.ExamplesSee alsoTBILLEQTBILLEQTBILLEQ(settlement,maturity,discount)DescriptionTBILLEQ function returns the bond-yield equivalent (BEY) for a treasury bill. TBILLEQ is equivalent to (365 * @discount) / (360 - @discount * DSM) where DSM is the days between @settlement and @maturity.If @settlement is after @maturity or the @maturity is set to over one year later than the @settlement, TBILLEQ returns #NUM! error. If @discount is negative, TBILLEQ returns #NUM! error.ExamplesSee also TBILLPRICE,
TBILLYIELD.
BESSELKBESSELKBESSELK(x,y)DescriptionBESSELK function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the bessel function, if non-integer it is truncated.If x or n are not numeric a #VALUE! error is returned. If y < 0 a #NUM! error is returned. This function is Excel compatible.ExamplesBESSELK(3,9) equals 397.95880.See also BESSELI,
BESSELJ,
BESSELY.
ADDRESSADDRESSADDRESS(row_num,col_num[,abs_num,a1,text])DescriptionADDRESS returns a cell address as text for specified row and column numbers.If @abs_num is 1 or omitted, ADDRESS returns absolute reference. If @abs_num is 2 ADDRESS returns absolute row and relative column. If @abs_num is 3 ADDRESS returns relative row and absolute column. If @abs_num is 4 ADDRESS returns relative reference. If @abs_num is greater than 4 ADDRESS returns #NUM! error.@a1 is a logical value that specifies the reference style. If @a1 is TRUE or omitted, ADDRESS returns an A1-style reference, i.e. $D$4. Otherwise ADDRESS returns an R1C1-style reference, i.e. R4C4.@text specifies the name of the worksheet to be used as the external reference.If @row_num or @col_num is less than one, ADDRESS returns #NUM! error.ExamplesSee alsoINDIRECTINDIRECTINDIRECT(ref_text,[format])DescriptionINDIRECT function returns the contents of the cell pointed to by the ref_text string. The string specifices a single cell reference the format of which is either A1 or R1C1 style. The style is set by the format boolean, which defaults to the former.If @ref_text is not a valid reference returns #REF!ExamplesSee alsoSIGNSIGNSIGN(number)DescriptionSIGN function returns 1 if the @number is positive, zero if the @number is 0, and -1 if the @number is negative. This function is Excel compatible.ExamplesSIGN(3) equals 1.SIGN(-3) equals -1.SIGN(0) equals 0.See alsoREPLACEREPLACEREPLACE(old,start,num,new)DescriptionREPLACE returns @old with @new replacing @num characters from @start.ExamplesREPLACE("testing",2,3,"*****") equals "t*****ing".See also MID,
SEARCH,
SUBSTITUTE,
TRIM.
GAMMADISTGAMMADISTGAMMADIST(x,alpha,beta,cum)DescriptionGAMMADIST function returns the gamma distribution. If @cum is TRUE, GAMMADIST returns the incomplete gamma function, otherwise it returns the probability mass function.If @x < 0 GAMMADIST returns #NUM! error. If @alpha <= 0 or @beta <= 0, GAMMADIST returns #NUM! error. This function is Excel compatible.ExamplesGAMMADIST(1,2,3,0) equals 0.07961459.See also GAMMAINV.
SKEWSKEWSKEW(n1, n2, ...)DescriptionSKEW returns an unbiased estimate for skewness of a distribution.Note, that this is only meaningful is the underlying distribution really has a third moment. The skewness of a symmetric (e.g., normal) distribution is zero.Strings and empty cells are simply ignored.If less than three numbers are given, SKEW returns #DIV/0! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenSKEW(A1:A5) equals 0.976798268.See also AVERAGE,
VAR,
SKEWP,
KURT.
CHIINVCHIINVCHIINV(p,dof)DescriptionCHIINV function returns the inverse of the one-tailed probability of the chi-squared distribution.If @p < 0 or @p > 1 or @dof < 1 CHIINV returns #NUM! error. This function is Excel compatible.ExamplesCHIINV(0.98,7) equals 1.564293004.See also CHIDIST,
CHITEST.
CODECODECODE(char)DescriptionCODE returns the ASCII number for the character @char.ExamplesCODE("A") equals 65.See also CHAR.
LOGINVLOGINVLOGINV(p,mean,stdev)DescriptionLOGINV function returns the inverse of the lognormal cumulative distribution. @p is the given probability corresponding to the normal distribution, @mean is the arithmetic mean of the distribution, and @stdev is the standard deviation of the distribution.If @p < 0 or @p > 1 or @stdev <= 0 LOGINV returns #NUM! error. This function is Excel compatible.ExamplesLOGINV(0.5,2,3) equals 7.389056099.See also EXP,
LN,
LOG,
LOG10,
LOGNORMDIST.
ERRORERRORERROR(text)DescriptionERROR return the specified errorExamplesSee also ISERROR.
ROUNDDOWNROUNDDOWNROUNDDOWN(number[,digits])DescriptionROUNDDOWN function rounds a given @number down, towards zero. @number is the number you want rounded down and @digits is the number of digits to which you want to round that number.If @digits is greater than zero, @number is rounded down to the given number of digits. If @digits is zero or omitted, @number is rounded down to the nearest integer. If @digits is less than zero, @number is rounded down to the left of the decimal point. This function is Excel compatible.ExamplesROUNDDOWN(5.5) equals 5.ROUNDDOWN(-3.3) equals -4.ROUNDDOWN(1501.15,1) equals 1501.1.ROUNDDOWN(1501.15,-2) equals 1500.0.See also ROUND,
ROUNDUP.
ISNAISNAISNA(value)DescriptionISNA returns TRUE if the value is the #N/A error value. This function is Excel compatible.ExamplesSee alsoSUMX2MY2SUMX2MY2SUMX2MY2(array1,array2)DescriptionSUMX2MY2 function returns the sum of the difference of squares of corresponding values in two arrays. @array1 is the first array or range of data points and @array2 is the second array or range of data points. The equation of SUMX2MY2 is SUM (x^2-y^2).Strings and empty cells are simply ignored.If @array1 and @array2 have different number of data points, SUMX2MY2 returns #N/A! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43 and the cells B1, B2, ..., B5 hold numbers 13, 22, 31, 33, and 39. ThenSUMX2MY2(A1:A5,B1:B5) equals -1299.See also SUMSQ,
SUMX2PY2.
VARVARVAR(b1, b2, ...)DescriptionVAR estimates the variance of a sample of a population. To get the true variance of a complete population use @VARP.(VAR is also known as the N-1-variance. Under reasonable conditions, it is the maximum-likelihood estimator for the true variance.)This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenVAR(A1:A5) equals 117.64.See also VARP,
STDEV.
HEX2OCTHEX2OCTHEX2OCT(number[,places])DescriptionThe HEX2OCT function converts a hexadecimal number to an octal number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesHEX2OCT("2A") equals 52.See also OCT2HEX,
HEX2BIN,
HEX2DEC.
STDEVPASTDEVPASTDEVPA(number1,number2,...)DescriptionSTDEVPA returns the standard deviation based on the entire population. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenSTDEVPA(A1:A5) equals 13.523697719.See also STDEVA,
STDEVP.
DAYS360DAYS360DAYS360 (date1,date2,method)DescriptionReturns the number of days from @date1 to @date2 following a 360-day calendar in which all months are assumed to have 30 days.If @method is true, the European method will be used. In this case, if the day of the month is 31 it will be considered as 30.If @method is false or omitted, the US method will be used. This is a somewhat complicated industry standard method.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also MONTH,
TIME,
NOW,
YEAR.
DVARPDVARPDVARP(database,field,criteria)DescriptionDVARP function returns the variance of a population based on the entire populations. The populations consists of numbers that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DVARP(A1:C7, "Age", A9:B11) equals 49.DVARP(A1:C7, "Salary", A9:B11) equals 41725140.25.See also DVAR.
DATEDIFDATEDIFDATEDIF(date1,date2,interval)DescriptionDATEDIF returns the difference between two dates. @interval is one of six possible values: "y", "m", "d", "ym", "md", and "yd".The first three options will return the number of complete years, months, or days, respectively, between the two dates specified."ym" will return the number of full months between the two dates, not including the difference in years."md" will return the number of full days between the two dates, not including the difference in months."yd" will return the number of full days between the two dates, not including the difference in years.ExamplesSee also DATE.
FINVFINVFINV(p,dof1,dof2)DescriptionFINV function returns the inverse of the F probability distribution.If @p < 0 or @p > 1 FINV returns #NUM! error. If @dof1 < 1 or @dof2 < 1 FINV returns #NUM! error. This function is Excel compatible.ExamplesFINV(0.2,2,4) equals 2.472135955.See also FDIST.
ISPMTISPMTISPMT(rate,per,nper,pv)DescriptionISPMT function returns the interest paid on a given period.If @per < 1 or @per > @nper, ISPMT returns #NUM! error.ExamplesSee also PV.
IMCOSIMCOSIMCOS(inumber)DescriptionIMCOS returns the cosine of a complex number. This function is Excel compatible.ExamplesIMCOS("1+j") equals 0.833730-0.988898j.See also IMSIN,
IMTAN.
IMDIVIMDIVIMDIV(inumber,inumber)DescriptionIMDIV returns the quotient of two complex numbers. This function is Excel compatible.ExamplesIMDIV("2-j","2+j") equals 0.6-0.8j.See also IMPRODUCT.
ISBLANKISBLANKISBLANK(value)DescriptionISBLANK returns TRUE if the value is blank. This function is Excel compatible.ExamplesSee alsoSECONDSECONDSECOND (serial_number)DescriptionConverts a serial number to a second. The second is returned as an integer in the range 0 to 59.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also HOUR,
MINUTE,
NOW,
TIME.
IMEXPIMEXPIMEXP(inumber)DescriptionIMEXP returns the exponential of a complex number. This function is Excel compatible.ExamplesIMEXP("2-j") equals 3.992324-6.217676j.See also IMLN.
ACOSACOSACOS(x)DescriptionACOS function calculates the arc cosine of @x; that is the value whose cosine is @x. If @x falls outside the range -1 to 1, ACOS fails and returns the NUM! error. The value it returns is in radians. This function is Excel compatible.ExamplesACOS(0.1) equals 1.470629.ACOS(-0.1) equals 1.670964.See also COS,
SIN,
DEGREES,
RADIANS.
STANDARDIZESTANDARDIZESTANDARDIZE(x,mean,stdev)DescriptionSTANDARDIZE function returns a normalized value. @x is the number to be normalized, @mean is the mean of the distribution, @stdev is the standard deviation of the distribution.If stddev is 0 STANDARDIZE returns #DIV/0! error. This function is Excel compatible.ExamplesSTANDARDIZE(3,2,4) equals 0.25.See also AVERAGE.
BESSELYBESSELYBESSELY(x,y)DescriptionBESSELY function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the bessel function, if non-integer it is truncated.If x or n are not numeric a #VALUE! error is returned. If n < 0 a #NUM! error is returned. This function is Excel compatible.ExamplesBESSELY(4,2) equals 0.215903595.See also BESSELJ,
BESSELK,
BESSELY.
SINSINSIN(x)DescriptionSIN function returns the sine of @x, where @x is given in radians. This function is Excel compatible.ExamplesSIN(0.5) equals 0.479426.See also COS,
COSH,
SINH,
TAN,
TANH,
RADIANS,
DEGREES.
EFFECTEFFECTEFFECT(r,nper)DescriptionEFFECT calculates the effective interest rate from a given nominal rate.Effective interest rate is calculated using this formulae: @r( 1 + ------ ) ^ @nper - 1 @nperwhere:@r = nominal interest rate (stated in yearly terms)@nper = number of periods used for compoundingExamplesFor example credit cards will list an APR (annual percentage rate) which is a nominal interest rate.For example if you wanted to find out how much you are actually paying interest on your credit card that states an APR of 19% that is compounded monthly you would type in:=EFFECT(.19,12) and you would get .2075 or 20.75%. That is the effective percentage you will pay on your loan.See also NOMINAL.
OFFSETOFFSETOFFSET(range,row,col,height,width)DescriptionThe OFFSET function returns a cell range. The cell range starts at offset (@col,@row) from @range, and is of height @height and width @width.If range is neither a reference nor a range returns #VALUE!. If either height or width is omitted the height or width of the reference is used.ExamplesSee also COLUMN,
COLUMNS,
ROWS.
OROROR(b1, b2, ...)DescriptionOR implements the logical OR function: the result is TRUE if any of the values evaluated to TRUE.@b1, trough @bN are expressions that should evaluate to TRUE or FALSE. If an integer or floating point value is provided zero is considered FALSE and anything else is TRUE.If the values contain strings or empty cells those values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is Excel compatible.ExamplesOR(TRUE,FALSE) equals TRUE.OR(3>4,4<3) equals FALSE.See also AND,
NOT.
TYPETYPETYPE(value)DescriptionTYPE returns a number indicating the data type of a value. This function is Excel compatible.ExamplesSee alsoQUARTILEQUARTILEQUARTILE(array,quart)DescriptionQUARTILE function returns the quartile of the given data points.If @quart is equal to: QUARTILE returns:0 the smallest value of @array.1 the first quartile2 the second quartile3 the third quartile4 the largest value of @array.If @array is empty, QUARTILE returns #NUM! error. If @quart < 0 or @quart > 4, QUARTILE returns #NUM! error. If @quart is not an integer, it is truncated. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenQUARTILE(A1:A5,1) equals 17.3.See also LARGE,
MAX,
MEDIAN,
MIN,
PERCENTILE,
SMALL.
GETPIVOTDATAGETPIVOTDATAGETPIVOTDATA(pivot_table,field_name)DescriptionGETPIVOTDATA function fetches summary data from a pivot table. @pivot_table is a cell range containing the pivot table. @field_name is the name of the field of which you want the summary data.If the summary data is unavailable, GETPIVOTDATA returns #REF! error.See alsoQUOTIENTQUOTIENTQUOTIENT(num,den)DescriptionQUOTIENT function returns the integer portion of a division. @num is the divided and @den is the divisor. This function is Excel compatible.ExamplesQUOTIENT(23,5) equals 4.See also MOD.
FORECASTFORECASTFORECAST(x,known_y's,known_x's)DescriptionFORECAST function estimates a future value according to existing values using simple linear regression. The estimated future value is a y-value for a given x-value (@x).If @known_x or @known_y contains no data entries or different number of data entries, FORECAST returns #N/A! error. If the variance of the @known_x is zero, FORECAST returns #DIV/0 error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenFORECAST(7,A1:A5,B1:B5) equals -10.859397661.See also INTERCEPT,
TREND.
BIN2OCTBIN2OCTBIN2OCT(number[,places])DescriptionBIN2OCT function converts a binary number to an octal number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesBIN2OCT(110111) equals 67.See also OCT2BIN,
BIN2DEC,
BIN2HEX.
CHIDISTCHIDISTCHIDIST(x,dof)DescriptionCHIDIST function returns the one-tailed probability of the chi-squared distribution. @dof is the number of degrees of freedom.If @dof is non-integer it is truncated. If @dof < 1 CHIDIST returns #NUM! error. This function is Excel compatible.ExamplesCHIDIST(5.3,2) equals 0.070651213.See also CHIINV,
CHITEST.
CONFIDENCECONFIDENCECONFIDENCE(x,stddev,size)DescriptionCONFIDENCE function returns the confidence interval for a mean. @x is the significance level, @stddev is the standard deviation, and @size is the size of the sample.If @size is non-integer it is truncated. If @size < 0 CONFIDENCE returns #NUM! error. If @size is 0 CONFIDENCE returns #DIV/0! error. This function is Excel compatible.ExamplesCONFIDENCE(0.05,1,33) equals 0.341185936.See also AVERAGE.
PIPIPI()DescriptionPI functions returns the value of Pi.This function is called with no arguments. This function is Excel compatible.ExamplesPI() equals 3.141593.See also SQRTPI.
COUNTCOUNTCOUNT(b1, b2, ...)DescriptionCOUNT returns the total number of integer or floating point arguments passed. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenCOUNT(A1:A5) equals 5.See also AVERAGE.
EUROEUROEURO(currency)DescriptionEURO converts one Euro to a given national currency in the European monetary union. @currency is one of the following: ATS (Austria) BEF (Belgium) DEM (Germany) ESP (Spain) FIM (Finland) FRF (France) IEP (Ireland) ITL (Italy) LUF (Luxemburg) NLG (Netherlands) PTE (Portugal)If the given @currency is other than one of the above, EURO returns #NUM! error.ExamplesEURO("DEM") returns 1.95583.See alsoIMPOWERIMPOWERIMPOWER(inumber,number)DescriptionIMPOWER returns a complex number raised to a power. @inumber is the complex number to be raised to a power and @number is the power to which you want to raise the complex number. This function is Excel compatible.ExamplesIMPOWER("4-j",2) equals 15-8j.See also IMSQRT.
NORMSINVNORMSINVNORMSINV(p)DescriptionNORMSINV function returns the inverse of the standard normal cumulative distribution. @p is the given probability corresponding to the normal distribution. This function is Excel compatible.If @p < 0 or @p > 1 NORMSINV returns #NUM! error.ExamplesNORMSINV(0.2) equals -0.841621234.See also NORMDIST,
NORMINV,
NORMSDIST,
STANDARDIZE,
ZTEST.
CELLCELLCELL(ref)DescriptionCELL returns information about the formatting, location, or contents of a cell.ExamplesSee alsoDSUMDSUMDSUM(database,field,criteria)DescriptionDSUM function returns the sum of numbers in a column that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DSUM(A1:C7, "Age", A9:B11) equals 72.DSUM(A1:C7, "Salary", A9:B11) equals 81565.See also DPRODUCT.
EXPRESSIONEXPRESSIONEXPRESSION(cell)DescriptionEXPRESSION returns expression in @cell as a string, orempty if the cell is not an expression.Examplesin A1 EXPRESSION(A2) equals 'EXPRESSION(A3)'.in A2 EXPRESSION(A3) equals empty.See also TEXT.
TBILLPRICETBILLPRICETBILLPRICE(settlement,maturity,discount)DescriptionTBILLPRICE function returns the price per $100 value for a treasury bill where @settlement is the settlement date and @maturity is the maturity date of the bill. @discount is the treasury bill's discount rate.If @settlement is after @maturity or the @maturity is set to over one year later than the @settlement, TBILLPRICE returns #NUM! error. If @discount is negative, TBILLPRICE returns #NUM! error.ExamplesSee also TBILLEQ,
TBILLYIELD.
RandExpRandExpRandExp(b)DescriptionRandExp returns a exponentially distributed random number.ExamplesRandExp(0.5).See also RAND,
RANDBETWEEN.
LOG2LOG2LOG2(x)DescriptionLOG2 computes the base-2 logarithm of @x. If @x <= 0, LOG2 returns #NUM! error.ExamplesLOG2(1024) equals 10.See also EXP,
LOG10,
LOG.
ABSABSABS(b1)DescriptionABS implements the Absolute Value function: the result is to drop the negative sign (if present). This can be done for integers and floating point numbers. This function is Excel compatible.ExamplesABS(7) equals 7.ABS(-3.14) equals 3.14.See also CEIL,
FLOOR.
PEARSONPEARSONPEARSON(array1,array2)DescriptionPEARSON returns the Pearson correlation coefficient of two data sets.Strings and empty cells are simply ignored. This function is Excel compatible.ExamplesSee also INTERCEPT,
LINEST,
RSQ,
SLOPE,
STEYX.
IMAGINARYIMAGINARYIMAGINARY(inumber)DescriptionIMAGINARY returns the imaginary coefficient of a complex number. This function is Excel compatible.ExamplesIMAGINARY("132-j") equals -1.See also IMREAL.
ROWROWROW([reference])DescriptionThe ROW function returns an array of the row numbers taking a default argument of the containing cell position.If @reference is neither an array nor a reference nor a range returns #VALUE!.ExamplesSee also COLUMN,
COLUMNS,
ROWS.
ATANHATANHATANH(x)DescriptionATANH function calculates the inverse hyperbolic tangent of @x; that is the value whose hyperbolic tangent is @x. If the absolute value of @x is greater than 1.0, ATANH returns NUM! error. This function is Excel compatible.ExamplesATANH(0.5) equals 0.549306. ATANH(0.8) equals 1.098612.See also ATAN,
TAN,
SIN,
COS,
DEGREES,
RADIANS.
ERFCERFCERFC(x)DescriptionThe ERFC function returns the complementary error function, defined as 1 - erf(x). erfc(x) is calculated more accurately than 1 - erf(x) for arguments larger than about 0.5.If @x is not numeric a #VALUE! error is returned.ExamplesERFC(6) equals 2.15197367e-17.See also ERF.
NNN(value)DescriptionN returns a value converted to a number. Strings containing text are converted to the zero value. This function is Excel compatible.ExamplesSee alsoWORKDAYWORKDAYWORKDAY (start_date,days,holidays)DescriptionReturns the day which is @days working days from the @start_date. Weekends and holidays optionally supplied in @holidays are respected.Returns #NUM! if @start_date or @days are invalid.ExamplesSee also NETWORKDAYS.
ROMANROMANROMAN(number[,type])DescriptionROMAN function returns an arabic number in the roman numeral style, as text. @number is the number you want to convert and @type is the type of roman numeral you want.If @type is 0 or it is omitted, ROMAN returns classic roman numbers. Type 1 is more concise than classic type, type 2 is more concise than type 1, and type 3 is more concise than type 2. Type 4 is simplified type.If @number is negative or greater than 3999, ROMAN returns #VALUE! error. This function is Excel compatible.ExamplesROMAN(999) equals CMXCIX.ROMAN(999,1) equals LMVLIV.ROMAN(999,2) equals XMIX.ROMAN(999,3) equals VMIV.ROMAN(999,4) equals IM.See alsoPOWERPOWERPOWER(x,y)DescriptionPOWER returns the value of @x raised to the power @y. This function is Excel compatible.ExamplesPOWER(2,7) equals 128.POWER(3,3.141) equals 31.523749.See also EXP.
NORMSDISTNORMSDISTNORMSDIST(x)DescriptionNORMSDIST function returns the standard normal cumulative distribution. @x is the value for which you want the distribution. This function is Excel compatible.ExamplesNORMSDIST(2) equals 0.977249868.See also NORMDIST.
STDEVASTDEVASTDEVA(number1,number2,...)DescriptionSTDEVA returns the standard deviation based on a sample. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenSTDEVA(A1:A5) equals 15.119953704.See also STDEV,
STDEVPA.
TTESTTTESTTTEST(array1,array2,tails,type)DescriptionTTEST function returns the probability of a Student's t-Test.@array1 is the first data set and @array2 is the second data set. If @tails is one, TTEST uses the one-tailed distribution and if @tails is two, TTEST uses the two-tailed distribution. @type determines the kind of the test:1 Paired test2 Two-sample equal variance3 Two-sample unequal varianceIf the data sets contain a different number of data points and the test is paired (@type one), TTEST returns the #N/A error. @tails and @type are truncated to integers. If @tails is not one or two, TTEST returns #NUM! error. If @type is any other than one, two, or three, TTEST returns #NUM! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenTTEST(A1:A5,B1:B5,1,1) equals 0.003127619.TTEST(A1:A5,B1:B5,2,1) equals 0.006255239.TTEST(A1:A5,B1:B5,1,2) equals 0.111804322.TTEST(A1:A5,B1:B5,1,3) equals 0.113821797.See also FDIST,
FINV.
DISCDISCDISC(settlement,maturity,par,redemption[,basis])DescriptionDISC calculates and returns the discount rate for a sequrity. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, DISC returns #NUM! error. If @basis < 0 or @basis > 4, DISC returns #NUM! error. If @settlement date is after @maturity date or they are the same, DISC returns #NUM! error.ExamplesSee alsoNPERNPERNPER(rate,pmt,pv,fv,type)DescriptionNPER calculates number of periods of an investment based on periodic constant payments and a constant interest rate. The interest rate per period is @rate, @pmt is the payment made each period, @pv is the present value, @fv is the future value and @type is when the payments are due. If @type = 1, payments are due at the begining of the period, if @type = 0, payments are due at the end of the period.ExamplesFor example, if you deposit $10,000 in a savings account that earns an interest rate of 6%. To calculate home many years it will take to double your investment use NPER as follows:=NPER(0.06, 0, -10000, 20000,0)returns 11.895661046 which indicates that you can double your money just before the end of the 12th year.See also PPMT,
PV,
FV.
NETWORKDAYSNETWORKDAYSNETWORKDAYS (start_date,end_date,holidays)DescriptionReturns the number of non-weekend non-holidays between @start_date and @end_date. Holidays optionally supplied in @holidays.Returns #NUM if start_date or end_date are invalidExamplesSee also WORKDAY.
STDEVSTDEVSTDEV(b1, b2, ...)DescriptionSTDEV returns standard deviation of a set of numbers treating these numbers as members of a population. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenSTDEV(A1:A5) equals 10.84619749.See also AVERAGE,
DSTDEV,
DSTDEVP,
STDEVA,
STDEVPA,
VAR.
MODMODMOD(number,divisor)DescriptionMOD function returns the remainder when @divisor is divided into @number. This function is Excel compatible.MOD returns #DIV/0! if divisor is zero.ExamplesMOD(23,7) equals 2.See also INT,
FLOOR,
CEIL.
FACTDOUBLEFACTDOUBLEFACTDOUBLE(number)DescriptionFACTDOUBLE function returns the double factorial of a @number.If @number is not an integer, it is truncated. If @number is negative FACTDOUBLE returns #NUM! error. This function is Excel compatible.ExamplesFACTDOUBLE(5) equals 15.See also FACT.
GAMMALNGAMMALNGAMMALN(x)DescriptionGAMMALN function returns the natural logarithm of the gamma function.If @x is non-number then GAMMALN returns #VALUE! error. If @x <= 0 then GAMMALN returns #NUM! error. This function is Excel compatible.ExamplesGAMMALN(23) equals 48.471181352.See also POISSON.
SMALLSMALLSMALL(n1, n2, ..., k)DescriptionSMALL returns the k-th smallest value in a data set.If data set is empty SMALL returns #NUM! error. If @k <= 0 or @k is greater than the number of data items given SMALL returns #NUM! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenSMALL(A1:A5,2) equals 17.3.SMALL(A1:A5,4) equals 25.9.See also PERCENTILE,
PERCENTRANK,
QUARTILE,
LARGE.
OCT2DECOCT2DECOCT2DEC(x)DescriptionOCT2DEC function converts an octal number in a string or number to its decimal equivalent. This function is Excel compatible.ExamplesOCT2DEC("124") equals 84.See also DEC2OCT,
OCT2BIN,
OCT2HEX.
TTT(value)DescriptionT returns @value if and only if it is text, otherwise a blank string.ExamplesT("text") equals "text".T(64) returns an empty cell.See also CELL,
N,
VALUE.
LOGESTLOGESTLOGEST(known_y's[,known_x's,const,stat])DescriptionThe LOGEST function applies the ``least squares'' method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.If @known_x's is omitted, an array {1, 2, 3, ...} is used. LOGEST returns an array { m{n},m{n-1}, ...,m{1},b }.If @known_y's and @known_x's have unequal number of data points, LOGEST returns #NUM! error.If @const is FALSE, the line will be forced to go through (0,1),i.e., b will be one. The default is TRUE.If @stat is TRUE, extra statistical information will be returned. Extra statistical information is written bellow the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares.The default of @stat is FALSE.ExamplesSee also LOGEST,
GROWTH,
TREND.
NORMINVNORMINVNORMINV(p,mean,stdev)DescriptionNORMINV function returns the inverse of the normal cumulative distribution. @p is the given probability corresponding to the normal distribution, @mean is the arithmetic mean of the distribution, and @stdev is the standard deviation of the distribution.If @p < 0 or @p > 1 or @stdev <= 0 NORMINV returns #NUM! error. This function is Excel compatible.ExamplesNORMINV(0.76,2,3) equals 4.118907689.See also NORMDIST,
NORMSDIST,
NORMSINV,
STANDARDIZE,
ZTEST.
PVPVPV(rate,nper,pmt[,fv,type])DescriptionPV calculates the present value of an investment. @rate is the periodic interest rate, @nper is the number of periods used for compounding. @pmt is the payment made each period, @fv is the future value and @type is when the payment is made. If @type = 1 then the payment is made at the begining of the period. If @type = 0 (or omitted) it is made at the end of each period.@EXAMPLES=See also FV.
DOLLARDOLLARDOLLAR(num[,decimals])DescriptionDOLLAR returns @num formatted as currency.ExamplesDOLLAR(12345) equals "$12,345.00".See also FIXED,
TEXT,
VALUE.
TANHTANHTANH(x)DescriptionThe TANH function returns the hyperbolic tangent of @x, which is defined mathematically as sinh(@x) / cosh(@x). This function is Excel compatible.ExamplesTANH(2) equals 0.96402758.See also TAN,
SIN,
SINH,
COS,
COSH,
DEGREES,
RADIANS.
MATCHMATCHMATCH(seek,vector[,type])DescriptionThe MATCH function finds the row index of @seek in @vector and returns it. If the area is longer than it is wide then the sense of the search is rotated. Alternatively a single array can be used.The @type parameter, which defaults to +1, controls the search:If @type = 1, finds largest value <= @seek.If @type = 0, finds first value == @seek.If @type = -1, finds smallest value >= @seek.For type 0, the data can be in any order. For types -1 and +1, the data must be sorted. (And in this case, MATCH uses a binary search to locate the index.)If @seek could not be found, #N/A is returned.ExamplesSee also LOOKUP.
SUBSTITUTESUBSTITUTESUBSTITUTE(text, old, new [,num])DescriptionSUBSTITUTE replaces @old with @new in @text. Substitutions are only applied to instance @num of @old in @text, otherwise every one is changed.ExamplesSUBSTITUTE("testing","test","wait") equals "waiting".See also REPLACE,
TRIM.
TODAYTODAYTODAY ()DescriptionReturns the serial number for today (the number of days elapsed since the 1st of January of 1900).ExamplesSee also TODAY,
NOW.
FVFVFV(rate,term,pmt,pv,type)DescriptionFV computes the future value of an investment. This is based on periodic, constant payments and a constant interest rate. The interest rate per period is @rate, @term is the number of periods in an annuity, @pmt is the payment made each period, @pv is the present value and @type is when the payment is made. If @type = 1 then the payment is made at the begining of the period. If @type = 0 it is made at the end of each period.ExamplesSee also PV,
PMT,
PPMT.
GNUMERIC_VERSIONGNUMERIC_VERSIONGNUMERIC_VERSION()DescriptionReturn the version of gnumeric as a string.ExamplesSee alsoPPMTPPMTPPMT(rate,per,nper,pv[,fv,type])DescriptionPPMT calculates the amount of a payment of an annuity going towards principal.Formula for it is:PPMT(per) = PMT - IPMT(per)where:PMT = Payment received on annuityIPMT(per) = amount of interest for period perExamplesSee also IPMT,
PV,
FV.
VDBVDBVDB(cost,salvage,life,start_period,end_period[,factor,switch])DescriptionVDB calculates the depreciation of an asset for a given period or partial period using the double-declining balance method.ExamplesSee also DB.
PROPERPROPERPROPER(string)DescriptionPROPER returns @string with initial of each word capitalised.ExamplesPROPER("j. f. kennedy") equals "J. F. Kennedy".See also LOWER,
UPPER.
DELTADELTADELTA(x[,y])DescriptionThe DELTA function tests for numerical equivalence of two arguments returning 1 in case of equality. @y is optional, and defaults to 0.If either argument is non-numeric returns a #VALUE! error. This function is Excel compatible.ExamplesDELTA(42.99,43) equals 0.See also EXACT,
GESTEP.
CEILINGCEILINGCEILING(x,significance)DescriptionCEILING function rounds @x up to the nearest multiple of @significance.If @x or @significance is non-numeric CEILING returns #VALUE! error. If @x and @significance have different signs CEILING returns #NUM! error. This function is Excel compatible.ExamplesCEILING(2.43,1) equals 3.CEILING(123.123,3) equals 126.See also CEIL.
KURTPKURTPKURTP(n1, n2, ...)DescriptionKURTP returns the population kurtosis of a data set.Strings and empty cells are simply ignored.If fewer than two numbers are given or all of them are equal KURTP returns #DIV/0! error.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenKURTP(A1:A5) equals -0.691363424.See also AVERAGE,
VARP,
SKEWP,
KURT.
IMLOG10IMLOG10IMLOG10(inumber)DescriptionIMLOG10 returns the logarithm of a complex number in base 10. This function is Excel compatible.ExamplesIMLOG10("3-j") equals 0.5-0.13973j.See also IMLN,
IMLOG2.
ANDANDAND(b1, b2, ...)DescriptionAND implements the logical AND function: the result is TRUE if all of the expressions evaluate to TRUE, otherwise it returns FALSE.@b1, trough @bN are expressions that should evaluate to TRUE or FALSE. If an integer or floating point value is provided zero is considered FALSE and anything else is TRUE.If the values contain strings or empty cells those values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is Excel compatible.ExamplesAND(TRUE,TRUE) equals TRUE.AND(TRUE,FALSE) equals FALSE.Let us assume that A1 holds number five and A2 number one. ThenAND(A1>3,A2<2) equals TRUE.See also OR,
NOT.
ODDODDODD(number)DescriptionODD function returns the @number rounded up to the nearest odd integer. This function is Excel compatible.ExamplesODD(4.4) equals 5.See also EVEN.
MAXAMAXAMAXA(number1,number2,...)DescriptionMAXA returns the largest value of the given arguments. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1. ThenMINA(A1:A5) equals 0.See also MAX,
MINA.
ISNONTEXTISNONTEXTISNONTEXT(value)DescriptionISNONTEXT Returns TRUE if the value is not text. This function is Excel compatible.ExamplesSee also ISTEXT.
SUMSUMSUM(value1, value2, ...)DescriptionSUM computes the sum of all the values and cells referenced in the argument list. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43. ThenSUM(A1:A5) equals 107.See also AVERAGE,
COUNT.
FVSCHEDULEFVSCHEDULEFVSCHEDULE(principal,schedule)DescriptionFVSCHEDULE returns the future value of given initial value after applying a series of compound periodic interest rates. The argument @principal is the present value; @schedule is an array of interest rates to apply. The @schedule argument must be a range of cells.ExamplesLet us assume that the cells A1, A2, ..., A5 contain interest rates 0.11, 0.13, 0.09, 0.17, and 0.03. ThenFVSCHEDULE(3000,A1:A5) equals 4942.7911611.See also PV,
FV.
MONTHMONTHMONTH (serial_number)DescriptionConverts a serial number to a month.Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also DAY,
TIME,
NOW,
YEAR.
BETADISTBETADISTBETADIST(x,alpha,beta[,a,b])DescriptionBETADIST function returns the cumulative beta distribution. @a is the optional lower bound of @x and @b is the optional upper bound of @x. If @a is not given, BETADIST uses 0. If @b is not given, BETADIST uses 1.If @x < @a or @x > @b BETADIST returns #NUM! error. If @alpha <= 0 or @beta <= 0, BETADIST returns #NUM! error. If @a >= @b BETADIST returns #NUM! error. This function is Excel compatible.ExamplesBETADIST(0.12,2,3) equals 0.07319808.See also BETAINV.
ISERRISERRISERR(value)DescriptionISERR returns TRUE if the value is any error value except #N/A. This function is Excel compatible.ExamplesSee alsoFIXEDFIXEDFIXED(num,[decimals, no_commas])DescriptionFIXED returns @num as a formatted string with @decimals numbers after the decimal point, omitting commas if requested by @no_commas.ExamplesFIXED(1234.567,2) equals "1,234.57".See alsoSTDEVPSTDEVPSTDEVP(b1, b2, ...)DescriptionSTDEVP returns standard deviation of a set of numbers treating these numbers as members of a complete population. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenSTDEVP(A1:A5) equals 9.701133954.See also STDEV,
STDEVA,
STDEVPA.
ACCRINTMACCRINTMACCRINTM(issue,maturity,rate[,par,basis])DescriptionACCRINTM calculates and returns the accrued interest for a security from @issue to @maturity date. @rate is the annual rate of the security and @par is the par value of the security. If you omit @par, ACCRINTM applies $1,000 instead. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @issue date or @maturity date is not valid, ACCRINTM returns #NUM! error. If @rate or @par is zero or negative, ACCRINTM returns #NUM! error. If @basis < 0 or @basis > 4, ACCRINTM returns #NUM! error. If @issue date is after @maturity date or they are the same, ACCRINTM returns #NUM! error.ExamplesSee also ACCRINT.
DEC2BINDEC2BINDEC2BIN(number[,places])DescriptionDEC2BIN function converts a decimal number to a binary number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesDEC2BIN(42) equals 101010.See also BIN2DEC,
DEC2OCT,
DEC2HEX.
COUPNUMCOUPNUMCOUPNUM(settlement,maturity,frequency[,basis])DescriptionReturns the numbers of coupons to be paid between the settlement and maturity dates, rounded up.ExamplesSee alsoYIELDYIELDYIELD(settle,mat,rate,price,redemption_price,frequency,basis)DescriptionExamplesSee alsoHLOOKUPHLOOKUPHLOOKUP(value,range,row[,approximate])DescriptionHLOOKUP function finds the col in range that has a first row cell similar to value. If @approximate is not true it finds the col with an exact equivilance. If @approximate is true, then the values must be sorted in order of ascending value for correct function; in this case it finds the col with value less than @value it returns the value in the col found at a 1 based offset in @row rows into the @range.Returns #NUM! if @row < 0. Returns #REF! if @row falls outside @range.ExamplesSee also VLOOKUP.
MMULTMMULTMMULT(array1,array2)DescriptionMMULT function returns the matrix product of two arrays. The result is an array with the same number of rows as @array1 and the same number of columns as @array2. This function is Excel compatible.ExamplesSee also TRANSPOSE,
MINVERSE.
LOG10LOG10LOG10(x)DescriptionLOG10 computes the base-10 logarithm of @x. If @x <= 0, LOG10 returns #NUM! error. This function is Excel compatible.ExamplesLOG10(7) equals 0.845098.See also EXP,
LOG2,
LOG.
IRRIRRIRR(values[,guess])DescriptionIRR calculates and returns the internal rate of return of an investment. This function is closely related to the net present value function (NPV). The IRR is the interest rate for a serie of cash flow where the net preset value is zero.@values contains the serie of cash flow generated by the investment. The payments should occur at regular intervals. The optional @guess is the initial value used in calculating the IRR. You do not have to use that, it is only provided for the Excel compatibility.This function is Excel compatible.ExamplesLet us assume that the cells A1:A8 contain the numbers -32432, 5324, 7432, 9332, 12324, 4334, 1235, -3422. ThenIRR(A1:A8) returns 0.04375.See also FV,
NPV,
PV.
HYPERLINKHYPERLINKHYPERLINK(reference)DescriptionThe HYPERLINK function currently returns its 2nd argument, or if that is omitted the 1st argument.ExamplesSee alsoDCOUNTDCOUNTDCOUNT(database,field,criteria)DescriptionDCOUNT function counts the cells that contain numbers in a database that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DCOUNT(A1:C7, "Salary", A9:A11) equals 3.DCOUNT(A1:C7, "Salary", A9:B11) equals 2.DCOUNT(A1:C7, "Name", A9:B11) equals 0.See also DAVERAGE.
COUNTACOUNTACOUNTA(b1, b2, ...)DescriptionCOUNTA returns the number of arguments passed not including empty cells. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, "missing", "missing", 25.9, and 40.1. ThenCOUNTA(A1:A5) equals 5.See also AVERAGE,
COUNT,
DCOUNT,
DCOUNTA,
PRODUCT,
SUM.
PRICEPRICEPRICE(settle,mat,rate,yield,redemption_price,frequency,basis)DescriptionExamplesSee alsoSUBTOTALSUBTOTALSUMIF(function_nbr,ref1,ref2,...)DescriptionSUBTOTAL function returns a subtotal of given list of arguments. @function_nbr is the number that specifies which function to use in calculating the subtotal. The following functions are available:1 AVERAGE2 COUNT3 COUNTA4 MAX5 MIN6 PRODUCT7 STDEV8 STDEVP9 SUM10 VAR11 VARPThis function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 23, 27, 28, 33, and 39. ThenSUBTOTAL(1,A1:A5) equals 30.SUBTOTAL(6,A1:A5) equals 22378356.SUBTOTAL(7,A1:A5) equals 6.164414003.SUBTOTAL(9,A1:A5) equals 150.SUBTOTAL(11,A1:A5) equals 30.4.See also COUNT,
SUM.
CLEANCLEANCLEAN(string)DescriptionCLEAN cleans the string from any non-printable characters.ExamplesCLEAN("one"\&char(7)) equals "one".See alsoMODEMODEMODE(n1, n2, ...)DescriptionMODE returns the most common number of the data set. If the data set has many most common numbers MODE returns the first one of them.Strings and empty cells are simply ignored. If the data set does not contain any duplicates MODE returns #N/A! error. This function is Excel compatible.ExamplesSee also AVERAGE,
MEDIAN.
DCOUNTADCOUNTADCOUNTA(database,field,criteria)DescriptionDCOUNTA function counts the cells that contain data in a database that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DCOUNTA(A1:C7, "Salary", A9:A11) equals 3.DCOUNTA(A1:C7, "Salary", A9:B11) equals 2.DCOUNTA(A1:C7, "Name", A9:B11) equals 2.See also DCOUNT.
SUMX2PY2SUMX2PY2SUMX2PY2(array1,array2)DescriptionSUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. @array1 is the first array or range of data points and @array2 is the second array or range of data points. The equation of SUMX2PY2 is SUM (x^2+y^2).Strings and empty cells are simply ignored.If @array1 and @array2 have different number of data points, SUMX2PY2 returns #N/A! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43 and the cells B1, B2, ..., B5 hold numbers 13, 22, 31, 33, and 39. ThenSUMX2PY2(A1:A5,B1:B5) equals 7149.See also SUMSQ,
SUMX2MY2.
FTESTFTESTFTEST(array1,array2)DescriptionFTEST function returns the one-tailed probability that the variances in the given two data sets are not significantly different. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenFTEST(A1:A5,B1:B5) equals 0.510815017.See also FDIST,
FINV.
SKEWPSKEWPSKEWP(n1, n2, ...)DescriptionSKEWP returns the population skewness of a data set.Strings and empty cells are simply ignored.If less than two numbers are given, SKEWP returns #DIV/0! error.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenSKEWP(A1:A5) equals 0.655256198.See also AVERAGE,
VARP,
SKEW,
KURTP.
ISNUMBERISNUMBERISNUMBER(value)DescriptionISNUMBER returns TRUE if the value is a number. This function is Excel compatible.ExamplesSee alsoRADIANSRADIANSRADIANS(x)DescriptionRADIANS computes the number of radians equivalent to @x degrees. This function is Excel compatible.ExamplesRADIANS(180) equals 3.14159.See also PI,
DEGREES.
TRENDTRENDTREND(known_y's[,known_x's],new_x's])DescriptionTREND function estimates future values of a given data set using the ``least squares'' line that best fit to your data. @known_y's is the y-values where y=mx+b and @known_x's contains the corresponding x-values. @new_x's contains the x-values for which you want to estimate the y-values.If @known_x's is omitted, an array {1, 2, 3, ...} is used. If @new_x's is omitted, it is assumed to be the same as @known_x's. If @known_y's and @known_x's have unequal number of data points, TREND returns #NUM! error.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenTREND(A1:A5,B1:B5) equals 156.52.See also LINEST.
IPMTIPMTIPMT(rate,per,nper,pv,fv,type)DescriptionIPMT calculates the amount of a payment of an annuity going towards interest.Formula for IPMT is:IPMT(PER) = -PRINCIPAL(PER-1) * INTEREST_RATEwhere:PRINCIPAL(PER-1) = amount of the remaining principal from last periodExamplesSee also PPMT,
PV,
FV.
MIRRMIRRMIRR(values,finance_rate,reinvest_rate)DescriptionMIRR function returns the modified internal rate of return for a given periodic cash flow.ExamplesSee also NPV.
ISREFISREFISREF(value)DescriptionISREF returns TRUE if the value is a reference. This function is Excel compatible.ExamplesSee alsoROUNDUPROUNDUPROUNDUP(number[,digits])DescriptionROUNDUP function rounds a given number up, away from zero. @number is the number you want rounded up and @digits is the number of digits to which you want to round that number.If @digits is greater than zero, @number is rounded up to the given number of digits. If @digits is zero or omitted, @number is rounded up to the nearest integer. If @digits is less than zero, @number is rounded up to the left of the decimal point. This function is Excel compatible.ExamplesROUNDUP(5.5) equals 6.ROUNDUP(-3.3) equals -3.ROUNDUP(1501.15,1) equals 1501.2.ROUNDUP(1501.15,-2) equals 1600.0.See also ROUND,
ROUNDDOWN.
DSTDEVDSTDEVDSTDEV(database,field,criteria)DescriptionDSTDEV function returns the estimate of the standard deviation of a population based on a sample. The populations consists of numbers that match conditions specified.@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in @database range.@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''. Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria). If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).ExamplesLet us assume that the range A1:C7 contain the following values:Name Age SalaryJohn 34 54342Bill 35 22343Clark 29 34323Bob 43 47242Susan 37 42932Jill 45 45324In addition, the cells A9:B11 contain the following values:Age Salary<30>40 >46000DSTDEV(A1:C7, "Age", A9:B11) equals 9.89949.DSTDEV(A1:C7, "Salary", A9:B11) equals 9135.112506.See also DSTDEVP.
SUMASUMASUMA(value1, value2, ...)DescriptionSUMA computes the sum of all the values and cells referenced in the argument list. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1).ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43. ThenSUMA(A1:A5) equals 107.See also AVERAGE,
SUM,
COUNT.
ACCRINTACCRINTACCRINT(issue,first_interest,settlement,rate,par,frequency[,basis])DescriptionACCRINT calculates the accrued interest for a security that pays periodic interest. The @rate is the annual rate of the security and @par is the par value of the security. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @issue date or @settlement date is not valid, ACCRINT returns #NUM! error. If @rate or @par is zero or negative, ACCRINT returns #NUM! error. If @basis < 0 or @basis > 4, ACCRINT returns #NUM! error. If @issue date is after @settlement date or they are the same, ACCRINT returns #NUM! error.ExamplesSee also ACCRINTM.
IMTANIMTANIMTAN(inumber)DescriptionIMTAN returns the tangent of a complex number. This function is Excel compatible.ExamplesSee also IMSIN,
IMCOS.
FISHERINVFISHERINVFISHERINV(x)DescriptionFISHERINV function returns the inverse of the Fisher transformation at @x.If @x is non-number FISHERINV returns #VALUE! error. This function is Excel compatible.ExamplesFISHERINV(2) equals 0.96402758.See also FISHER.
ATANATANATAN(x)DescriptionATAN function calculates the arc tangent of @x; that is the value whose tangent is @x. Return value is in radians. This function is Excel compatible.ExamplesATAN(0.5) equals 0,463648.ATAN(1) equals 0,785398.See also TAN,
COS,
SIN,
DEGREES,
RADIANS.
SLNSLNSLN(cost,salvage_value,life)DescriptionThe SLN function will determine the straight line depreciation of an asset for a single period. The amount you paid for the asset is the @cost, @salvage is the value of the asset at the end of its useful life, and @life is the number of periods over which an the asset is depreciated. This method of deprecition devides the cost evenly over the life of an asset.The formula used for straight line depriciation is:Depriciation expense = ( @cost - @salvage_value ) / @life @cost = cost of an asset when acquired (market value). @salvage_value = amount you get when asset sold at the end of the assets's useful life. @life = anticipated life of an asset.ExamplesFor example, lets suppose your company purchases a new machine for $10,000, which has a salvage value of $700 and will have a useful life of 10 years. The SLN yearly depreciation is computed as follows:=SLN(10000, 700, 10)This will return the yearly depreciation figure of $930.See also SYD.
LARGELARGELARGE(n1, n2, ..., k)DescriptionLARGE returns the k-th largest value in a data set.If data set is empty LARGE returns #NUM! error. If @k <= 0 or @k is greater than the number of data items given LARGE returns #NUM! error. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. ThenLARGE(A1:A5,2) equals 25.9.LARGE(A1:A5,4) equals 17.3.See also PERCENTILE,
PERCENTRANK,
QUARTILE,
SMALL.
YIELDMATYIELDMATYIELDMAT(settlement,maturity,issue,rate,pr,basis)DescriptionExamplesSee alsoHEX2BINHEX2BINHEX2BIN(number[,places])DescriptionThe HEX2BIN function converts a hexadecimal number to a binary number. @places is an optional field, specifying to zero pad to that number of spaces.If @places is too small or negative #NUM! error is returned. This function is Excel compatible.ExamplesHEX2BIN("2A") equals 101010.See also BIN2HEX,
HEX2OCT,
HEX2DEC.
GESTEPGESTEPGESTEP(x[,y])DescriptionGESTEP function test for if @x is >= @y, returning 1 if it is so, and 0 otherwise @y is optional, and defaults to 0.If either argument is non-numeric returns a #VALUE! error. This function is Excel compatible.ExamplesGESTEP(5,4) equals 1.See also DELTA.
TDISTTDISTTDIST(x,dof,tails)DescriptionTDIST function returns the Student's t-distribution. @dof is the degree of freedom and @tails is 1 or 2 depending on whether you want one-tailed or two-tailed distribution.If @dof < 1 TDIST returns #NUM! error. If @tails is neither 1 or 2 TDIST returns #NUM! error. This function is Excel compatible.ExamplesTDIST(2,5,1) equals 0.050969739.See also TINV,
TTEST.
HOURHOURHOUR (serial_number)DescriptionConverts a serial number to an hour. The hour is returned as an integer in the range 0 (12:00 A.M.) to 23 (11:00 P.M.).Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.ExamplesSee also MINUTE,
NOW,
TIME,
SECOND.
FACTFACTFACT(x)DescriptionFACT computes the factorial of @x. ie, @x!This function is Excel compatible.ExamplesFACT(3) equals 6.FACT(9) equals 362880.See alsoSLOPESLOPESLOPE(known_y's,known_x's)DescriptionSLOPE returns the slope of the linear regression line. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenSLOPE(A1:A5,B1:B5) equals 1.417959936.See also STDEV,
STDEVPA.
COVARCOVARCOVAR(array1,array2)DescriptionCOVAR returns the covariance of two data sets.Strings and empty cells are simply ignored. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7. ThenCOVAR(A1:A5,B1:B5) equals 65.858.See also CORREL,
FISHER,
FISHERINV.
DOLLARFRDOLLARFRDOLLARFR(decimal_dollar,fraction)DescriptionDOLLARFR converts a decimal dollar price into a dollar price expressed as a fraction.If @fraction is non-integer it is truncated. If @fraction <= 0, DOLLARFR returns #NUM! error.ExamplesSee also DOLLARDE.
OCT2HEXOCT2HEXOCT2HEX(number[,places])DescriptionThe OCT2HEX function converts an octal number to a hexadecimal number. @places is an optional field, specifying to zero pad to that number of spaces. This function is Excel compatible.If @places is too small or negative #NUM! error is returned.ExamplesOCT2HEX(132) equals 5A.See also HEX2OCT,
OCT2BIN,
OCT2DEC.
COMBINCOMBINCOMBIN(n,k)DescriptionCOMBIN computes the number of combinations.Performing this function on a non-integer or a negative number returns an error. Also if @n is less than @k returns an error. This function is Excel compatible.ExamplesCOMBIN(8,6) equals 28.COMBIN(6,2) equals 15.See alsoEVENEVENEVEN(number)DescriptionEVEN function returns the number rounded up to the nearest even integer. This function is Excel compatible.ExamplesEVEN(5.4) equals 6.See also ODD.
RECEIVEDRECEIVEDRECEIVED(settlement,maturity,investment,rate[,basis])DescriptionRECEIVED calculates and returns the amount to be received at @maturity date for a security bond. @basis is the type of day counting system you want to use:0 US 30/3601 actual days/actual days2 actual days/3603 actual days/3654 European 30/360If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, RECEIVED returns #NUM! error. If @basis < 0 or @basis > 4, RECEIVED returns #NUM! error. If @settlement date is after @maturity date or they are the same, RECEIVED returns #NUM! error.ExamplesSee also INTRATE.
IFIFIF(condition[,if-true,if-false])DescriptionUse the IF statement to evaluate conditionally other expressions IF evaluates @condition. If @condition returns a non-zero value the result of the IF expression is the @if-true expression, otherwise IF evaluates to the value of @if-false. If ommitted @if-true defaults to TRUE and @if-false to FALSE. This function is Excel compatible.ExamplesIF(FALSE,TRUE,FALSE) equals FALSE.See alsoXNPVXNPVXNPV(rate,values,dates)DescriptionXNPV calculates the net present value of an investment. The schedule of the cash flows is given in @dates array. The first date indicates the beginning of the payment schedule. @rate is the interest rate and @values are the payments.If @values and @dates contain unequal number of values, XNPV returns the #NUM! error.ExamplesSee also NPV,
PV.
IMSQRTIMSQRTIMSQRT(inumber)DescriptionIMSQRT returns the square root of a complex number. This function is Excel compatible.ExamplesIMSQRT("1+j") equals 1.09868+0.4550899j.See also IMPOWER.
COUNTIFCOUNTIFCOUNTIF(range,criteria)DescriptionCOUNTIF function counts the number of cells in the given @range that meet the given @criteria. This function is Excel compatible.ExamplesLet us assume that the cells A1, A2, ..., A5 contain numbers 23, 27, 28, 33, and 39. ThenCOUNTIF(A1:A5,"<=28") equals 3.COUNTIF(A1:A5,"<28") equals 2.COUNTIF(A1:A5,"28") equals 1.COUNTIF(A1:A5,">28") equals 2.See also COUNT,
SUMIF.
CUMPRINCCUMPRINCCUMPRINC(rate,nper,pv,start_period,end_period,type)DescriptionReturns the cumulative principal paid on a loan between @start_period and @end_period.ExamplesSee alsoACOSHACOSHACOSH(x)DescriptionACOSH function calculates the inverse hyperbolic cosine of @x; that is the value whose hyperbolic cosine is @x. If @x is less than 1.0, acosh() returns the NUM! error. This function is Excel compatible.ExamplesACOSH(2) equals 1.31696.ACOSH(5.3) equals 2.35183.See also ACOS,
ASINH,
DEGREES,
RADIANS.
TRUNCTRUNCTRUNC(number[,digits])DescriptionTRUNC function returns the value of @number truncated to the number of digits specified. If @digits is omitted then @digits defaults to zero. This function is Excel compatible.ExamplesTRUNC(3.12) equals 3.TRUNC(4.15,1) equals 4.1.See also INT.
TRIMTRIMTRIM(text)DescriptionTRIM returns @text with only single spaces between words.ExamplesTRIM(" a bbb cc") equals "a bbb cc".See also CLEAN,
MID,
REPLACE,
SUBSTITUTE.
PROBPROBPROB(range_x,prob_range,lower_limit[,upper_limit])DescriptionPROB function returns the probability that values in a range or an array are between two limits. If @upper_limit is not given, PROB returns the probability that values in @x_range are equal to @lower_limit.If the sum of the probabilities in @prob_range is not equal to 1 PROB returns #NUM! error. If any value in @prob_range is <=0 or > 1, PROB returns #NUM! error. If @x_range and @prob_range contain a different number of data entries, PROB returns #N/A! error. This function is Excel compatible.ExamplesSee also BINOMDIST,
CRITBINOM.
TRANSPOSETRANSPOSETRANSPOSE(matrix)DescriptionTRANSPOSE function returns the transpose of the input @matrix.ExamplesSee also MMULT.
SEARCHSEARCHSEARCH(text,within[,start_num])DescriptionSEARCH returns the location of a character or text string within another string. @text is the string or character to be searched. @within is the string in which you want to search. @start_num is the start position of the search in @within. If @start_num is omitted, it is assumed to be one. The search is not case sensitive.@text can contain wildcard characters (*) and question marks (?) to control the search. A question mark matches with any character and wildcard matches with any string including empty string. If you want the actual wildcard or question mark to be searched, use tilde (~) before the character.If @text is not found, SEARCH returns #VALUE! error. If @start_num is less than one or it is greater than the length of @within, SEARCH returns #VALUE! error.ExamplesSEARCH("c","Cancel") equals 1.SEARCH("c","Cancel",2) equals 4.See also FIND.
CONCATENATECONCATENATECONCATENATE(string1[,string2...])DescriptionCONCATENATE returns up appended strings.ExamplesCONCATENATE("aa","bb") equals "aabb".See also LEFT,
MID,
RIGHT.
ISERRORISERRORISERROR(value)DescriptionISERROR returns a TRUE value if the expression has an errorThis function is Excel compatible.ExamplesSee also ERROR.
INFOINFOINFO()DescriptionINFO returns information about the current operating environment. This function is Excel compatible.ExamplesSee alsoAMORDEGRCAMORDEGRCAMORDEGRC(cost,purchase_date,first_period,salvage,period,rate,basis)DescriptionReturns the depreciation for each accounting period.ExamplesSee alsoIMLNIMLNIMLN(inumber)DescriptionIMLN returns the natural logarithm of a complex number. (The result will have an imaginary part between -pi and +pi. The natural logarithm is not uniquely defined on complex numbers. You may need to add or subtract an even multiple of pi to the imaginary part.)This function is Excel compatible.ExamplesIMLN("3-j") equals 1.15129-0.32175j.See also IMEXP,
IMLOG2,
IMLOG10.
ERROR.TYPEERROR.TYPEERROR(value)DescriptionERROR.TYPE returns an error number corresponding to the given error value. The error numbers for error values are#DIV/0! 2#VALUE! 3#REF! 4#NAME! 5#NUM! 6#NA! 7This function is Excel compatible.ExamplesERROR.TYPE(NA()) equals 7.See also ISERROR.