File: //lib64/libreoffice/program/resource/analysisen-US.res
� k � t f fReturns the serial number of the date before or after a specified number of workdays Start date The start date Days F FThe number of workdays before or after the start date Holidays L LList of date values of days off (vacation, holidays, etc.) � H Z ZReturns the number of years (including fractional part) between two dates Start date The start date End date The end date Basis T TBasis indicates the day-count convention to use in the calculation � z zReturns the serial number of the date that is a specified number of months before or after the start date Start date The start date Months @ @Number of months before or after the start date � � � �Returns the number of the calendar week in which the specified date occurs.
This function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead. Date 0 0The date or date serial number Return type N NIndicates the first day of the week (1 = Sunday, 2 = Monday) � 0 � �Returns the serial number of the last day of the month that comes a certain number of months before or after the start date Start date The start date Months @ @Number of months before or after the start date � � � �Returns the number of workdays between two dates.
This function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead. Start date The start date End date The end date Holidays V VList of date values representing days off (vacation, holidays, etc.) � � @ @Returns the value 'true' if the number is even Number The number � � > >Returns the value 'true' if the number is odd Number The number � � H HReturns the multinomial coefficient of a set of numbers Number Z ZNumber or list of numbers for which you want the multinomial coefficient � � 2 2Returns the sum of a power series X > >The independent variable of the power series N > >The initial power to which x is to be raised M R RThe increment by which to increase n for each term in the series Coefficients d dSet of coefficients by which each successive power of the variable x is multiplied � � : :Returns the integer portion of a division Numerator The dividend Denominator The divisor � � B BReturns a number rounded to a specified multiple Number ( (The number to round off Multiple @ @The multiple to which you want to round number � � T TReturns the square root of a number which has been multiplied by pi Number 6 6The number by which pi is multiplied � � J JReturns a random integer between the numbers you specify Bottom . .The smallest integer returned Top . .The largest integer returned � � � �Returns the greatest common divisor.
This function exists for interoperability with older Microsoft Excel documents, for new documents use GCD instead. Number * *Number or list of numbers � � � �Returns the least common multiple.
This function exists for interoperability with older Microsoft Excel documents, for new documents use LCM instead. Number * *Number or list of numbers � � < <Returns the modified Bessel function In(x) X D DThe value at which the function is to be evaluated N 2 2The order of the Bessel function � � 2 2Returns the Bessel function Jn(x) X D DThe value at which the function is to be evaluated N 2 2The order of the Bessel function � � 2 2Returns the Bessel function Kn(x) X D DThe value at which the function is to be evaluated N 2 2The order of the Bessel function � � 2 2Returns the Bessel function Yn(x) X D DThe value at which the function is to be evaluated N 2 2The order of the Bessel function � � < <Converts a binary number to an octal number Number < <The binary number to be converted (as text) Places & &Number of places used � � > >Converts a binary number to a decimal number Number < <The binary number to be converted (as text) � � B BConverts a binary number to a hexadecimal number Number < <The binary number to be converted (as text) Places ( (Number of places used. � � < <Converts an octal number to a binary number Number < <The octal number to be converted (as text) Places & &Number of places used � > >Converts an octal number to a decimal number Number < <The octal number to be converted (as text) � B BConverts an octal number to a hexadecimal number Number < <The octal number to be converted (as text) Places & &Number of places used � > >Converts a decimal number to a binary number Number 4 4The decimal integer to be converted Places & &Number of places used � B BConverts a decimal number to a hexadecimal number Number 4 4The decimal integer to be converted Places & &Number of places used � @ @Converts a decimal number into an octal number Number $ $The decimal number Places & &Number of places used � B BConverts a hexadecimal number to a binary number Number B BThe hexadecimal number to be converted (as text) Places & &Number of places used � B BConverts a hexadecimal number to a decimal number Number B BThe hexadecimal number to be converted (as text) � B BConverts a hexadecimal number to an octal number Number B BThe hexadecimal number to be converted (as text) Places & &Number of places used � 4 4Tests whether two values are equal Number 1 " "The first number Number 2 " "The second number � , ,Returns the error function Lower limit 0 0The lower limit for integration Upper limit 0 0The upper limit for integration
� : :Returns the complementary error function Lower limit 0 0The lower limit for integration � J JTests whether a number is greater than a threshold value Number 0 0The value to test against step Step $ $The threshold value | 8 8Returns the double factorial of Number Number The number
� J JReturns the absolute value (modulus) of a complex number Complex number $ $The complex number � F FReturns the imaginary coefficient of a complex number Complex number $ $The complex number � @ @Returns a complex number raised to a real power Complex number $ $The complex number Number < <Power to which the complex number is raised � J JReturns the argument theta, an angle expressed in radians Complex number " "A complex number � 8 8Returns the cosine of a complex number Complex number " "A complex number � < <Returns the quotient of two complex numbers Numerator The dividend Denominator The divisor � R RReturns the algebraic form of the exponential of a complex number Complex number $ $The complex number � B BReturns the complex conjugate of a complex number Complex number $ $The complex number � B BReturns the natural logarithm of a complex number Complex number $ $The complex number � B BReturns the base-10 logarithm of a complex number Complex number $ $The complex number � B BReturns the base-2 logarithm of a complex number Complex number $ $The complex number � @ @Returns the product of several complex numbers Complex number * *The first complex number Complex number ( (Another complex number � B BReturns the real coefficient of a complex number Complex number $ $The complex number � 6 6Returns the sine of a complex number Complex number $ $The complex number � > >Returns the difference of two complex numbers " "Complex number 1 " "Complex number 1 " "Complex number 2 " "Complex number 2 � < <Returns the square root of a complex number Complex number $ $The complex number � 4 4Returns the sum of complex numbers Complex number $ $The complex number E � 8 8Returns the tangent of a complex number Complex number " "A complex number F � 8 8Returns the secant of a complex number Complex number " "A complex number G � : :Returns the cosecant of a complex number Complex number " "A complex number H � : :Returns the cotangent of a complex number Complex number " "A complex number I � @ @Returns the hyperbolic sine of a complex number Complex number " "A complex number J � B BReturns the hyperbolic cosine of a complex number Complex number " "A complex number K � B BReturns the hyperbolic secant of a complex number Complex number " "A complex number L � D DReturns the hyperbolic cosecant of a complex number Complex number " "A complex number P PConverts real and imaginary coefficients into a complex number Real num & &The real coefficient I num * *The imaginary coefficient Suffix The suffix J JConverts a number from one measurement system to another Number The number From unit , ,Unit of measure for number To unit 0 0Unit of measure for the result L ` `Returns the prorated linear depreciation of an asset for each accounting period Cost " "Cost of the asset Date purchased , ,Purchase date of the asset First period , ,Date the first period ends Salvage B BSalvage value of an asset at the end of its life
Period The period Rate
* *The rate of depreciation Basis * *The year basis to be used ! T ` `Returns the prorated linear depreciation of an asset for each accounting period Cost " "Cost of the asset Date purchased , ,Purchase date of the asset First period 0 0The date the first period ends Salvage F FThe salvage value of an asset at the end of its life
Period The period Rate
* *The rate of depreciation Basis * *The year basis to be used " X XReturns the accrued interest for a security that pays periodic interest Issue , ,Issue date of the security First interest 4 4First interest date of the security Settlement The settlement Rate The rate
Par The par value Frequency
The frequency Basis The basis # p \ \Returns the accrued interest for a security that pays interest at maturity Issue The issue date Settlement The settlement Rate The rate Par The par value
Basis The basis $ ~ V VReturns the amount paid out at maturity for a fully invested security Settlement The settlement Maturity The maturity Investment The investment Discount The discount
Basis The basis % ` : :Returns the discount rate for a security Settlement The settlement Maturity The maturity Price The price Redemption & &The redemption value
Basis The basis & � d dReturns the annual Macaulay duration of a security with periodic interest payments Settlement The settlement Maturity The maturity Coupon The coupon rate Yield The yield
Frequency The frequency Basis
The basis ' � < <Returns the effective annual interest rate Nominal rate " "The nominal rate Npery The periods ( � Z ZReturns the cumulative principal on a loan to be paid between two periods Rate The rate Nper * *Number of payment periods Pv " "The present value Start period " "The start period
End period The end period Type
& &The type of maturity ) � P PReturns the cumulative interest to be paid between two periods Rate The rate Nper * *Number of payment periods Pv " "The present value Start period " "The start period
End period The end period Type
& &The type of maturity * � n nReturns the price per 100 currency units face value of a security that pays periodic interest Settlement The settlement Maturity The maturity Rate The rate Yield The yield
Redemption & &The redemption value Frequency
The frequency Basis The basis + � ^ ^Returns the price per 100 currency units face value of a discounted security Settlement The settlement Maturity The maturity Discount The discount Redemption & &The redemption value
Basis The basis , � r rReturns the price per 100 currency units face value of a security that pays interest at maturity Settlement The settlement Maturity The maturity Issue The issue date Rate The rate
Yield The yield Basis
The basis - � v vReturns the Macaulay modified duration for a security with an assumed par value of 100 currency units Settlement The settlement Maturity The maturity Coupon The coupon rate Yield The yield
Frequency The frequency Basis
The basis . � : :Returns the annual nominal interest rate Effective rate , ,The effective interest rate Npery The periods / � ^ ^Converts a price expressed as a decimal into a price expressed as a fraction Decimal dollar $ $The decimal number Fraction The divisor 0 � ^ ^Converts a price expressed as a fraction into a price expressed as a decimal " "Fractional dollar * *The number as a fraction Fraction The divisor 1 � L LReturns the yield on a security that pays periodic interest Settlement The settlement Maturity The maturity Rate The rate Price The price
Redemption & &The redemption value Frequency
The frequency Basis The basis 2 j D DReturns the annual yield for a discounted security Settlement The settlement Maturity The maturity Price The price Redemption & &The redemption value
Basis The basis 3 � V VReturns the annual yield of a security that pays interest at maturity Settlement The settlement Maturity The maturity Issue The issue date Rate The rate
Price The price Basis
The basis 4 F FReturns the bond-equivalent yield for a treasury bill Settlement The settlement Maturity The maturity Discount " "The discount rate 5 X XReturns the price of 100 currency units face value for a treasury bill Settlement The settlement Maturity The maturity Discount " "The discount rate 6 � 6 6Returns the yield for a treasury bill Settlement The settlement Maturity The maturity Price The price 7 f ^ ^Returns the price per $100 face value of a security with an odd first period Settlement The settlement Maturity The maturity Issue The issue date First coupon & &The first coupon date
Rate The rate Yield
The yield Redemption & &The redemption value Frequency The frequency Basis The basis 8 R J JReturns the yield of a security with an odd first period Settlement The settlement Maturity The maturity Issue The issue date First coupon & &The first coupon date
Rate The rate Price
The price Redemption & &The redemption value Frequency The frequency Basis The basis 9 0 \ \Returns the price per $100 face value of a security with an odd last period Settlement The settlement Maturity The maturity Last interest ( (The last interest date Rate The rate
Yield The yield Redemption
& &The redemption value Frequency The frequency Basis The basis : H HReturns the yield of a security with an odd last period Settlement The settlement Maturity The maturity Last interest ( (The last interest date Rate The rate
Price The price Redemption
& &The redemption value Frequency The frequency Basis The basis ; \ \Returns the internal rate of return for a non-periodic schedule of payments Values The values Dates The dates Guess The guess < � V VReturns the net present value for a non-periodic schedule of payments Rate The rate Values The values Dates The dates = z H HReturns the interest rate for a fully invested security Settlement The settlement Maturity The maturity Investment The investment Redemption & &The redemption value
Basis The basis > 4 H HReturns the first coupon date after the settlement date Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis ? L ` `Returns the number of days in the coupon period containing the settlement date Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis @ H \ \Returns the number of days from the settlement date to the next coupon date Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis A V j jReturns the number of days from the beginning of the coupon period to the settlement date Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis B 8 L LReturns the last coupon date preceding the settlement date Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis C L ` `Returns the number of coupons payable between the settlement and maturity dates Settlement The settlement Maturity The maturity Frequency The frequency Basis The basis D � x xReturns the future value of the initial principal after a series of compound interest rates are applied Principal The principal Schedule The schedule � � WORKDAY YEARFRAC EDATE WEEKNUM EOMONTH NETWORKDAYS 9 AMORDEGRC : AMORLINC ; ACCRINT < ACCRINTM = RECEIVED > DISC ? DURATION @ EFFECT A CUMPRINC B CUMIPMT C PRICE D PRICEDISC E PRICEMAT F MDURATION G NOMINAL H DOLLARFR I DOLLARDE J YIELD K YIELDDISC L YIELDMAT M TBILLEQ N TBILLPRICE O TBILLYIELD P ODDFPRICE Q ODDFYIELD R ODDLPRICE S ODDLYIELD T XIRR U XNPV V INTRATE W COUPNCD X COUPDAYS Y COUPDAYSNC Z COUPDAYBS [ COUPPCD \ COUPNUM ] FVSCHEDULE ISEVEN ISODD GCD LCM MULTINOMIAL
SERIESSUM QUOTIENT MROUND
SQRTPI RANDBETWEEN BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT ! DELTA DEC2BIN DEC2HEX DEC2OCT " ERF # ERFC $ GESTEP HEX2BIN HEX2DEC HEX2OCT & IMABS ' IMAGINARY ( IMPOWER ) IMARGUMENT * IMCOS + IMDIV , IMEXP - IMCONJUGATE . IMLN / IMLOG10 0 IMLOG2 1 IMPRODUCT 2 IMREAL 3 IMSIN 4 IMSUB 6 IMSUM 5 IMSQRT ^ IMTAN _ IMSEC ` IMCSC a IMCOT b IMSINH c IMCOSH d IMSECH e IMCSCH 7 COMPLEX OCT2BIN OCT2DEC OCT2HEX 8 CONVERT % FACTDOUBLE � r � y 0 0 ARBEITSTAG WORKDAY � y 2 2 BRTEILJAHRE YEARFRAC � y * * EDATUM EDATE � y 2 2 KALENDERWOCHE WEEKNUM � y 0 0 MONATSENDE EOMONTH � y : : NETTOARBEITSTAGE NETWORKDAYS � y 0 0 AMORDEGRK AMORDEGRC � y 2 2 AMORLINEARK AMORLINC � y 0 0 AUFGELZINS ACCRINT � y 2 2 AUFGELZINSF ACCRINTM � y 2 2 AUSZAHLUNG RECEIVED � y * * DISAGIO DISC � y 0 0 DURATION DURATION � y . . EFFEKTIV EFFECT � y 2 2 KUMKAPITAL CUMPRINC � y . . KUMZINSZ CUMIPMT � y ( ( KURS PRICE � y 2 2 KURSDISAGIO PRICEDISC � y 2 2 KURSFÄLLIG PRICEMAT � y 0 0 MDURATION MDURATION � y , , NOMINAL NOMINAL � y 4 4 NOTIERUNGBRU DOLLARFR � y 4 4 NOTIERUNGDEZ DOLLARDE � y * * RENDITE YIELD � y 2 2 RENDITEDIS YIELDDISC � y 4 4 RENDITEFÄLL YIELDMAT � y 0 0 TBILLÄQUIV TBILLEQ � y 2 2 TBILLKURS TBILLPRICE � y 6 6 TBILLRENDITE TBILLYIELD � y 4 4 UNREGER.KURS ODDFPRICE � y 4 4 UNREGER.REND ODDFYIELD � y 4 4 UNREGLE.KURS ODDLPRICE � y 4 4 UNREGLE.REND ODDLYIELD � y 0 0 XINTZINSFUSS XIRR � y 0 0 XKAPITALWERT XNPV � y . . ZINSSATZ INTRATE � y 0 0 ZINSTERMNZ COUPNCD � y 4 4 ZINSTERMTAGE COUPDAYS � y 6 6 ZINSTERMTAGNZ COUPDAYSNC � y 4 4 ZINSTERMTAGVA COUPDAYBS � y 0 0 ZINSTERMVZ COUPPCD � y 2 2 ZINSTERMZAHL COUPNUM � y , , ZW2 FVSCHEDULE � y . . ISTGERADE ISEVEN � y . . ISTUNGERADE ISODD � y $ $ GGT GCD � y $ $ KGV LCM � y 4 4 POLYNOMIAL MULTINOMIAL � y 2 2 POTENZREIHE SERIESSUM � y 0 0 QUOTIENT QUOTIENT � y , , VRUNDEN MROUND � y . . WURZELPI SQRTPI � y 8 8 ZUFALLSBEREICH RANDBETWEEN � y , , BESSELI BESSELI � y , , BESSELJ BESSELJ � y , , BESSELK BESSELK � y , , BESSELY BESSELY � y . . BININDEZ BIN2DEC � y . . BININHEX BIN2HEX � y . . BININOKT BIN2OCT � y ( ( DELTA DELTA � y . . DEZINBIN DEC2BIN � y . . DEZINHEX DEC2HEX � y . . DEZINOKT DEC2OCT � y , , GAUSSFEHLER ERF � y . . GAUSSFKOMPL ERFC � y . . GGANZZAHL GESTEP � y . . HEXINBIN HEX2BIN � y . . HEXINDEZ HEX2DEC � y . . HEXINOKT HEX2OCT � y ( ( IMABS IMABS � y 4 4 IMAGINÄRTEIL IMAGINARY � y . . IMAPOTENZ IMPOWER � y 4 4 IMARGUMENT IMARGUMENT � y ( ( IMCOS IMCOS � y ( ( IMDIV IMDIV � y ( ( IMEXP IMEXP � y 6 6 IMKONJUGIERTE IMCONJUGATE � y ( ( IMLN IMLN � y , , IMLOG10 IMLOG10 � y , , IMLOG2 IMLOG2 � y 0 0 IMPRODUKT IMPRODUCT � y 0 0 IMREALTEIL IMREAL � y ( ( IMSIN IMSIN � y ( ( IMSUB IMSUB � y * * IMSUMME IMSUM � y . . IMWURZEL IMSQRT � y ( ( IMTAN IMTAN � y ( ( IMSEC IMSEC y ( ( IMCSC IMCSC y ( ( IMCOT IMCOT y , , IMSINH IMSINH y , , IMCOSH IMCOSH y , , IMSECH IMSECH y , , IMCSCH IMCSCH � y . . KOMPLEXE COMPLEX � y . . OKTINBIN OCT2BIN � y . . OKTINDEZ OCT2DEC � y . . OKTINHEX OCT2HEX � y . . UMWANDELN CONVERT � y 6 6 ZWEIFAKULTÄT FACTDOUBLE � � �6 � � k � t� 4