Apache OpenOffice Calc — Function Directory
Browse 396 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Apache OpenOffice Calc.
396 functions
Browse by category
A
- absThe ABS function in OpenOffice Calc returns the absolute value of a number. Learn syntax, examples, behavior with negative …
- ACCRINTUnderstand Apache OpenOffice ACCRINT with checked accrued-interest examples and its important limitation: FirstInterest is …
- ACCRINTMCalculate maturity-paid accrued interest with OpenOffice ACCRINTM. Verify default par, five bases and the release’s February …
- acosThe ACOS function in OpenOffice Calc returns the arccosine (inverse cosine) of a value, in radians. Learn syntax, domain …
- ACOSHLearn the ACOSH function in Apache OpenOffice Calc: Returns the inverse hyperbolic cosine of a number.
- ACOTLearn the ACOT function in Apache OpenOffice Calc: Returns the inverse cotangent of a number.
- ACOTHLearn the ACOTH function in Apache OpenOffice Calc: Returns the inverse hyperbolic cotangent of a number.
- ADDRESSLearn the ADDRESS function in Apache OpenOffice Calc: Returns the reference to a cell as text.
- AMORDEGRCUnderstand OpenOffice AMORDEGRC’s coefficients, whole-unit rounding and final-period rule, including a checked schedule that …
- AMORLINCUse OpenOffice AMORLINC for initial-period and straight-line depreciation. Check period zero, residual caps, date basis and …
- ANDLearn the AND function in Apache OpenOffice Calc: Returns TRUE if all arguments are TRUE.
- ARABICUse OpenOffice ARABIC for Roman-numeral labels, with tested lowercase and simplified forms, empty-input behavior and a …
- AREASCount separate reference areas with AREAS in OpenOffice Calc. See tilde unions, blank-cell references and the difference …
- ASCConvert full-width Latin letters, digits, and katakana to half-width text in Apache OpenOffice Calc using ASC.
- asinThe ASIN function in OpenOffice Calc returns the arcsine (inverse sine) of a value, in radians. Learn syntax, domain limits, …
- ASINHLearn the ASINH function in Apache OpenOffice Calc: Returns the inverse hyperbolic sine of a number.
- atanThe ATAN function in OpenOffice Calc returns the arctangent (inverse tangent) of a value, in radians. Learn syntax, domain …
- atan2The ATAN2 function in OpenOffice Calc returns the angle (in radians) from the X-axis to a point (x, y), with full quadrant …
- ATANHLearn the ATANH function in Apache OpenOffice Calc: Returns the inverse hyperbolic tangent of a number.
- AVEDEVApache OpenOffice AVEDEV measures mean absolute deviation about the arithmetic mean. Follow numeric examples, scaling checks …
- averageThe AVERAGE function in OpenOffice Calc calculates the arithmetic mean of numbers in a range. Learn syntax, examples, common …
- AVERAGEALearn the AVERAGEA function in Apache OpenOffice Calc: Returns the average value for a sample. Text is evaluated as zero.
- averageifThe AVERAGEIF function in OpenOffice Calc calculates the average of values that meet a single condition. Learn syntax, …
- averageifsThe AVERAGEIFS function in OpenOffice Calc calculates the average of values that meet multiple conditions. Learn syntax, …
B
- BCalculate Apache OpenOffice B binomial count probabilities and inclusive ranges, with argument-order examples, endpoint rules …
- BAHTTEXTWrite baht amounts as Thai text with Apache OpenOffice BAHTTEXT. Check satang rounding, negative amounts, million blocks and …
- BASEFormat unsigned integers as base 2–36 text with OpenOffice BASE, using native padding and fractional-input examples plus …
- BESSELIEvaluate modified Bessel I in Apache OpenOffice Calc, with integer-order examples, negative-input parity and explicitly …
- BESSELJUse Apache OpenOffice BESSELJ for ordinary integer-order Bessel values, with sign checks, zero arguments, recurrence examples …
- BESSELKCalculate modified Bessel K in Apache OpenOffice, with positive-domain checks, integer orders and separate native versus …
- BESSELYEvaluate Apache OpenOffice BESSELY with positive X and integer orders, using signed reference values, recurrence checks and …
- BETADISTUse Apache OpenOffice BETADIST for bounded continuous distributions, including its sixth cumulative argument, scaled …
- BETAINVFind beta-distribution quantiles with OpenOffice BETAINV, including scaled intervals, round-trip checks and the 4.1.16 …
- BIN2DECLearn the BIN2DEC function in Apache OpenOffice Calc: Converts a binary number to a decimal number.
- BIN2HEXConvert signed binary codes to hexadecimal in Apache OpenOffice, with ten-digit sign rules, padding examples and exact …
- BIN2OCTTranslate signed binary strings to octal in Apache OpenOffice, with padding, negative sign extension and explicitly tested …
- BINOMDISTCalculate binomial count probabilities in Apache OpenOffice, with exact versus cumulative examples, inclusive-tail cutoffs …
C
- ceilingThe CEILING function in OpenOffice Calc rounds a number up to the nearest multiple of a specified significance. Learn syntax, …
- CELLUse CELL in OpenOffice Calc to inspect row, column, sheet, contents and type. Distinguish numeric values, text labels and …
- CHARCreate characters with Apache OpenOffice CHAR. Verify ASCII codes, spaces and line feeds while distinguishing system byte …
- CHIDISTEvaluate right-tail chi-square probabilities with Apache OpenOffice CHIDIST, including negative cutoffs, integer degrees of …
- CHIINVFind upper-tail chi-square cutoffs with OpenOffice CHIINV, using round trips, central intervals and reversed-tail ordering …
- CHISQDISTUse CHISQDIST in Apache OpenOffice for chi-square CDFs and densities, with the 3.1 introduction, optional mode and …
- CHISQINVApache OpenOffice CHISQINV converts cumulative probabilities to chi-square cutoffs. Check the 3.1 history, endpoint rules and …
- CHITESTApache OpenOffice Calc CHITEST examples turn observed and expected counts into a right-tail p-value, with table-shape degrees …
- CHOOSELearn the CHOOSE function in Apache OpenOffice Calc: Selects a value from a list of up to 30 value arguments.
- CLEANLearn the CLEAN function in Apache OpenOffice Calc: Removes all nonprintable characters from text.
- CODELearn the CODE function in Apache OpenOffice Calc: Returns a numeric code for the first character in a text string.
- COLUMNLearn the COLUMN function in Apache OpenOffice Calc: Returns the internal column number of a reference.
- COLUMNSLearn the COLUMNS function in Apache OpenOffice Calc: Returns the number of columns in an array or reference.
- COMBINLearn the COMBIN function in Apache OpenOffice Calc: Calculates the number of combinations for elements without repetition.
- COMBINALearn the COMBINA function in Apache OpenOffice Calc: Calculates the number of combinations of elements including repetition.
- COMPLEXBuild complex-number text with Apache OpenOffice COMPLEX, including i/j suffix rules, zero components and reproducible …
- CONCATENATELearn the CONCATENATE function in Apache OpenOffice Calc: Combines several text items into one.
- CONFIDENCEBuild a normal-model confidence interval in OpenOffice with CONFIDENCE, known population SD, explicit sample size and …
- CONVERTConvert fixed legacy euro currencies in Apache OpenOffice, with exact codes, historical factors and rounding examples.
- CONVERT_ADDConvert measurement units in Apache OpenOffice, with exact tokens, metric powers, temperature offsets and compatibility …
- CORRELUse CORREL in Apache OpenOffice to measure signed linear association, with paired ranges, reproducible coefficients and …
- cosThe COS function in OpenOffice Calc returns the cosine of an angle (in radians). Learn syntax, degree conversion, examples, …
- COSHLearn the COSH function in Apache OpenOffice Calc: Returns the hyperbolic cosine of a number.
- COTCalculate cotangent with OpenOffice COT, using native real-input examples, odd-function checks and precise zero and …
- COTHCalculate hyperbolic cotangent with OpenOffice COTH, using native real-input examples, odd-function checks and precise zero …
- countThe COUNT function in OpenOffice Calc counts numeric values in a range. Learn syntax, examples, common errors, and best …
- countaThe COUNTA function in OpenOffice Calc counts non‑empty cells, including text, numbers, formulas, and logical values. Learn …
- countblankThe COUNTBLANK function in OpenOffice Calc counts empty cells in a range. Learn syntax, examples, common errors, and best …
- countifThe COUNTIF function in OpenOffice Calc counts cells that meet a single condition. Learn syntax, examples, wildcard rules, …
- countifsThe COUNTIFS function in OpenOffice Calc counts cells that meet multiple conditions. Learn syntax, examples, wildcard rules, …
- COUPDAYBSCount coupon days before settlement with Apache OpenOffice COUPDAYBS. Check schedule anchoring, settlement on a coupon date …
- COUPDAYSFind the coupon-period denominator with OpenOffice COUPDAYS. Compare actual periods, 360/frequency and 365/frequency, …
- COUPDAYSNCCalculate days from settlement to the next coupon in OpenOffice Calc. Compare actual remaining days with the 30/360 remainder …
- COUPNCDFind the next coupon date with Apache OpenOffice COUPNCD. Reproduce date serials, month-end schedules and settlement exactly …
- COUPNUMCount remaining coupons with OpenOffice COUPNUM. Check maturity inclusion, settlement on a coupon date and annual, semiannual …
- COUPPCDFind the previous coupon date with OpenOffice COUPPCD. Check inclusive settlement dates, leap-year month ends and …
- COVARApache OpenOffice COVAR divides centered cross-products by n. Compare population and sample covariance with paired data, …
- CRITBINOMUse CRITBINOM in Apache OpenOffice for binomial count thresholds, with strict interior alpha values, cumulative checks and …
- CSCCalculate cosecant with OpenOffice CSC, using native real-input examples, odd-function checks and precise zero and …
- CSCHCalculate hyperbolic cosecant with OpenOffice CSCH, using native real-input examples, odd-function checks and precise zero …
- CUMIPMTSum loan interest with Apache OpenOffice CUMIPMT. Check inclusive payment periods, beginning-payment timing, negative …
- CUMIPMT_ADDUse OpenOffice CUMIPMT_ADD for compatible cumulative loan-interest formulas. Check the Analysis add-in identity, strict …
- CUMPRINCCalculate cumulative loan principal in Apache OpenOffice Calc with CUMPRINC. Reconcile amortization balances, payment timing …
- CUMPRINC_ADDCalculate compatible cumulative principal with OpenOffice CUMPRINC_ADD. Reconcile loan balances, inclusive intervals and the …
- CURRENTUnderstand OpenOffice Calc CURRENT with eight arithmetic examples. See how operator precedence changes the intermediate value …
D
- DATELearn the DATE function in Apache OpenOffice Calc: Provides an internal number for the date given.
- DATEVALUEConvert date text to a serial with Apache OpenOffice DATEVALUE. Check ISO-date examples, the date-system origin, locale …
- DAVERAGEUse DAVERAGE in Apache OpenOffice Calc to calculate the mean of a numeric field for records that meet your conditions. …
- DAYLearn the DAY function in Apache OpenOffice Calc: Returns the sequential date of the month as an integer (1-31) in relation …
- DAYSSubtract dates with DAYS in Apache OpenOffice Calc, including reversed dates, leap years and fractional-day timestamps. See …
- DAYS360Use Apache OpenOffice DAYS360 with US or European 30/360 rules. Understand February adjustments, reversed-date asymmetry and …
- DAYSINMONTHFind a month’s length with DAYSINMONTH in Apache OpenOffice Calc. Use date inputs, leap-year rules and end-of-month worksheet …
- DAYSINYEARUse DAYSINYEAR in Apache OpenOffice Calc to return 365 or 366 from a date, with leap-century examples and clear year-fraction …
- DBUse DB depreciation in Apache OpenOffice Calc. See the rounded fixed rate, partial first-year months and exact …
- DCOUNTUse DCOUNT in Apache OpenOffice Calc to count matching records whose selected field contains a number. Includes criteria …
- DCOUNTAUse DCOUNTA in Apache OpenOffice Calc to count populated cells in a field after selecting records with criteria. Includes …
- DDBCalculate DDB depreciation in Apache OpenOffice Calc. Compare default and custom factors, salvage caps and the distinction …
- DDEUnderstand OpenOffice Calc DDE links, the server/file/item arguments, optional conversion mode and platform limitations …
- DEC2BINLearn the DEC2BIN function in Apache OpenOffice Calc: Converts a decimal number to a binary number.
- DEC2HEXLearn the DEC2HEX function in Apache OpenOffice Calc: Converts a decimal number to a hexadecimal number.
- DEC2OCTEncode decimal integers as octal in Apache OpenOffice, with signed limits, fractional-input conversion and padded text …
- DECIMALRead unsigned positional strings with OpenOffice DECIMAL, including hexadecimal prefixes, binary suffixes, whitespace rules …
- DEGREESLearn the DEGREES function in Apache OpenOffice Calc: Converts a radian to degrees.
- DELTALearn the DELTA function in Apache OpenOffice Calc: Tests whether two values are equal.
- DEVSQCalculate sums of squared deviations in Apache OpenOffice with DEVSQ, including variance links, offset invariance and …
- DGETUse DGET in Apache OpenOffice Calc to retrieve one field from exactly one matching record. Includes criteria examples, …
- DISCCalculate DISC in Apache OpenOffice Calc with verified day-count examples. Distinguish redemption-based discount from …
- DMAXUse DMAX in Apache OpenOffice Calc to find the largest numeric value among records meeting your criteria. Includes criteria …
- DMINUse DMIN in Apache OpenOffice Calc to find the smallest numeric value among records meeting your criteria. Includes criteria …
- DOLLARFormat currency text with Apache OpenOffice DOLLAR. Check decimal rounding, locale-specific symbols and why the returned …
- DOLLARDEDecode fractional price notation with DOLLARDE in Apache OpenOffice Calc. Understand denominator digit width, signed values …
- DOLLARFREncode decimal prices with Apache OpenOffice DOLLARFR. See denominator-specific digit positions, negative values and DOLLARDE …
- DPRODUCTUse DPRODUCT in Apache OpenOffice Calc to multiply the numeric factors from records selected by criteria. Includes criteria …
- DSTDEVUse DSTDEV in Apache OpenOffice Calc to calculate sample standard deviation for a criteria-selected numeric field. Includes …
- DSTDEVPUse DSTDEVP in Apache OpenOffice Calc to calculate population standard deviation for the records selected by criteria. …
- DSUMUse DSUM in Apache OpenOffice Calc to total a numeric field from records that meet visible worksheet criteria. Includes …
- DURATIONUse the three-argument OpenOffice DURATION to find compound-growth periods. Distinguish it from bond DURATION_ADD and its …
- DURATION_ADDCalculate bond duration with OpenOffice DURATION_ADD. Verify coupon-weighted timing, frequency, date bases and its …
- DVARUse DVAR in Apache OpenOffice Calc to calculate sample variance of a numeric field selected by criteria. Includes criteria …
- DVARPUse DVARP in Apache OpenOffice Calc to calculate population variance for a criteria-selected numeric field. Includes criteria …
E
- EASTERSUNDAYCalculate Gregorian Easter Sunday with EASTERSUNDAY in Apache OpenOffice Calc. See checked dates, date formatting and …
- EDATEShift dates by calendar months with EDATE in Apache OpenOffice Calc. See month-end clamping, anchored schedules and native …
- EFFECT_ADDConvert nominal to effective annual interest with OpenOffice EFFECT_ADD. Verify compounding periods, the Analysis add-in …
- EFFECTIVEConvert a nominal annual rate with EFFECTIVE in Apache OpenOffice Calc. Check compounding periods, floor behavior and the …
- EOMONTHFind month-end dates with Apache OpenOffice EOMONTH. Use zero or signed month offsets, compare EDATE and build anchored …
- ERFUse Apache OpenOffice ERF for signed Gaussian integrals, with one- and two-limit examples and an observed far-tail …
- ERFCEvaluate complementary error-function tails in Apache OpenOffice, with tiny positive results, negative inputs and explicit …
- ERRORTYPEInspect OpenOffice Calc error codes with ERRORTYPE. The tested NA paths return 32767; learn why error codes, error values and …
- EUROCONVERTConvert historical euro currencies in OpenOffice Calc with EUROCONVERT. Worked rounding and triangulation examples, supported …
- EVENLearn the EVEN function in Apache OpenOffice Calc: Rounds a positive number up and negative number down to the nearest even …
- EXACTLearn the EXACT function in Apache OpenOffice Calc: Specifies whether two texts are identical.
- expThe EXP function in OpenOffice Calc returns e raised to a given power. Learn syntax, exponential growth behavior, examples, …
- EXPONDISTModel waiting times with Apache OpenOffice EXPONDIST, using a rate rather than a mean, density-versus-probability examples …
F
- FACTLearn the FACT function in Apache OpenOffice Calc: Calculates the factorial of a number.
- FACTDOUBLELearn the FACTDOUBLE function in Apache OpenOffice Calc: Returns the double factorial of Number.
- FALSELearn the FALSE function in Apache OpenOffice Calc: Defines the logical value as FALSE.
- FDISTUse Apache OpenOffice Calc FDIST for right-tail F probabilities, with numerator/denominator order, integer limits and a …
- FINDLearn the FIND function in Apache OpenOffice Calc: Looks for a string of text within another (case sensitive).
- FINVFind right-tail F cutoffs with Apache OpenOffice Calc FINV, including endpoint rules, ordered degrees of freedom and …
- FISHERTransform a correlation with Apache OpenOffice FISHER. Work through domain limits, inverse checks and an explicitly …
- FISHERINVUse Apache OpenOffice FISHERINV to return from Fisher z to correlation, with signed examples, interval endpoints and …
- FIXEDReturn fixed-decimal text with Apache OpenOffice FIXED. Compare grouping, negative precision, rounding and the distinction …
- floorThe FLOOR function in OpenOffice Calc rounds a number down to the nearest multiple of a specified significance. Learn syntax, …
- FORECASTFit a straight-line FORECAST in Apache OpenOffice Calc. Reproduce predictions, inspect least-squares coefficients and …
- FORMULARead formula text with FORMULA in OpenOffice Calc, including numeric, text, logical, date and error-producing formulas, …
- FREQUENCYCount numeric bins with FREQUENCY in Apache OpenOffice Calc. Verify upper-bound inclusion, the overflow bin and the release’s …
- FTESTApache OpenOffice Calc FTEST compares sample variances. Follow reproducible range examples, degrees of freedom and the 4.1.16 …
- FVProject constant-rate cash flows with OpenOffice FV, including native savings, initial-deposit, payment-timing and zero-rate …
- FVSCHEDULECompound a changing rate schedule with Apache OpenOffice FVSCHEDULE. Follow ordered period-rate examples and distinguish …
G
- GAMMAEvaluate the gamma function in Apache OpenOffice, with factorial and half-integer identities, negative noninteger values and …
- GAMMADISTApache OpenOffice GAMMADIST examples for gamma CDFs and densities, scale-based duration models, interval probabilities and …
- GAMMAINVBuild a gamma percentile worksheet with OpenOffice GAMMAINV, compare scale changes, and check valid probabilities against …
- GAMMALNUse GAMMALN in Apache OpenOffice for log-gamma values, large-factorial calculations and stable probability formulas, with an …
- GAUSSInterpret Apache OpenOffice GAUSS as signed standard-normal area from zero, with tail and interval examples that distinguish …
- GCDLearn the GCD function in Apache OpenOffice Calc: Greatest Common Divisor.
- GCD_ADDUse GCD_ADD in Apache OpenOffice for common-divisor calculations, with integer-group examples, zero handling and …
- GEOMEANUse Apache OpenOffice GEOMEAN for positive multiplicative data, with growth-factor examples, range checks and a clear …
- GESTEPLearn the GESTEP function in Apache OpenOffice Calc: Tests whether a number is greater than or equal to a threshold value.
- GETPIVOTDATAUse GETPIVOTDATA to retrieve a named result from an OpenOffice Calc pivot table without relying on its changing cell …
- GROWTHFit exponential GROWTH in Apache OpenOffice Calc. Reproduce positive-data predictions and see why forcing the log intercept …
H
- HARMEANCalculate harmonic means in Apache OpenOffice, using equal-distance rate examples, reciprocal checks and strictly positive …
- HEX2BINConvert hexadecimal codes to signed binary in Apache OpenOffice, with strict output limits, case-insensitive digits and …
- HEX2DECLearn the HEX2DEC function in Apache OpenOffice Calc: Converts a hexadecimal number to a decimal number.
- HEX2OCTTranslate hexadecimal text to octal in Apache OpenOffice, with forty-bit source decoding, thirty-bit output limits and exact …
- HLOOKUPLearn the HLOOKUP function in Apache OpenOffice Calc: Horizontal search and reference to the cells located below.
- HOURLearn the HOUR function in Apache OpenOffice Calc: Extracts the hour component of a time value, with source-checked rounding …
- HYPERLINKBuild OpenOffice Calc hyperlink formulas with a target and optional label. Understand text, numeric and empty labels without …
- HYPGEOMDISTOpenOffice HYPGEOMDIST takes four arguments for exact-count probabilities. Learn valid support bounds and how to sum masses …
I
- IFLearn the IF function in Apache OpenOffice Calc: Specifies a logical test to be performed.
- IMABSFind a complex magnitude with Apache OpenOffice IMABS, with quadrant examples, strict text parsing and a clear distinction …
- IMAGINARYExtract imaginary coefficients in Apache OpenOffice with IMAGINARY, including unit coefficients, signs and strict …
- IMARGUMENTCalculate complex phase in Apache OpenOffice, with all four quadrants, radian units, zero-input errors and an explicit …
- IMCONJUGATEReturn complex conjugates in Apache OpenOffice, preserving real parts and tested i/j suffixes while rejecting malformed …
- IMCOSEvaluate complex cosine in Apache OpenOffice Calc, with radian inputs, hyperbolic component formulas and exact native result …
- IMCOSHUse Apache OpenOffice IMCOSH for complex hyperbolic cosine, with component signs, imaginary inputs and finite-result …
- IMCOTCalculate complex cotangent in Apache OpenOffice, with a zero-input pole, conjugate checks and a clear distinction from …
- IMCSCEvaluate complex cosecant in Apache OpenOffice, with reciprocal-sine examples, zero errors and explicit real/imaginary sign …
- IMCSCHUse Apache OpenOffice IMCSCH for reciprocal hyperbolic sine, with imaginary-axis signs, pole diagnostics and independent …
- IMDIVDivide complex values in Apache OpenOffice, using two arguments, a nonzero divisor and reproducible component and error …
- IMEXPCalculate the complex exponential in Apache OpenOffice, with radian phase, magnitude checks and strict input diagnostics.
- IMLNUse Apache OpenOffice IMLN for principal complex logarithms, with magnitude and radian-phase components and explicit zero …
- IMLOG10Calculate principal base-10 complex logarithms in Apache OpenOffice, with natural-log scaling, phase units and zero-input …
- IMLOG2Evaluate base-2 complex logarithms in Apache OpenOffice, with scaled principal phase, reference components and strict nonzero …
- IMPOWERRaise complex values to a real power in Apache OpenOffice, with principal-branch examples, reciprocal powers and explicit …
- IMPRODUCTMultiply complex values in Apache OpenOffice, with cross-term examples, conjugate checks and the tested all-empty result.
- IMREALExtract real components with Apache OpenOffice IMREAL, with quadrant examples, numeric outputs and strict complex-text …
- IMSECFind complex secants in Apache OpenOffice, with reciprocal-cosine examples, even symmetry and precision cautions near poles.
- IMSECHEvaluate reciprocal complex hyperbolic cosine in Apache OpenOffice, with even symmetry, zero behavior and imaginary-axis pole …
- IMSINCalculate complex sine in Apache OpenOffice, with radian component formulas, quadrant examples and identities using complex …
- IMSINHUse complex hyperbolic sine in Apache OpenOffice, with component formulas, sign checks, zero and strict text-error …
- IMSQRTFind principal complex square roots in Apache OpenOffice, with quadrant examples, zero and negative-axis conventions.
- IMSUBSubtract complex numbers in Apache OpenOffice using two arguments, with sign-sensitive examples and strict empty-text …
- IMSUMAdd complex values in Apache OpenOffice Calc, with component-wise examples, range guidance and tested empty-input rules.
- IMTANEvaluate complex tangent in Apache OpenOffice, with double-angle formulas, imaginary-axis checks and explicit pole …
- INDEXLearn the INDEX function in Apache OpenOffice Calc: Returns a reference to a cell from a defined range.
- INDIRECTUse INDIRECT in Apache OpenOffice Calc to turn a text address into a live cell reference. Two original examples, expected …
- INFOReview OpenOffice Calc INFO keywords and the 4.1.16 source limits: OSVERSION and NUMFILE are constants, while release and …
- intThe INT function in OpenOffice Calc rounds a number down to the nearest integer. Learn syntax, behavior with negative …
- INTERCEPTFind the fitted y-intercept in Apache OpenOffice Calc, with explicit y-first argument order, centered-predictor examples and …
- INTRATEUse INTRATE in Apache OpenOffice Calc for annualized simple investment return, with checked basis differences and a clear …
- IPMTSplit the interest part of a level payment with OpenOffice IPMT, including native first-payment and annuity-due examples with …
- IRRFind equal-period cash-flow returns with Apache OpenOffice IRR. Check the initial investment, zero periods, guesses and a …
- ISBLANKLearn the ISBLANK function in Apache OpenOffice Calc: Returns TRUE if value refers to an empty cell.
- ISERRLearn the ISERR function in Apache OpenOffice Calc: Returns TRUE if the value is an error value not equal to #N/A.
- ISERRORLearn the ISERROR function in Apache OpenOffice Calc: Returns TRUE if the value is an error value.
- ISEVENLearn the ISEVEN function in Apache OpenOffice Calc: Returns TRUE if the value truncated to integer is even.
- ISEVEN_ADDCheck even integer values with OpenOffice ISEVEN_ADD. Distinguish numeric 1/0 add-in results, negative integers and the core …
- ISFORMULATest whether a referenced cell contains a formula in OpenOffice Calc. See literals, true blanks and formulas whose results …
- ISLEAPYEARCheck Gregorian leap years with Apache OpenOffice ISLEAPYEAR. Pass a date, understand the 1/0 result and handle century …
- ISLOGICALLearn the ISLOGICAL function in Apache OpenOffice Calc: Returns TRUE if the value carries a logical number format.
- ISNALearn the ISNA function in Apache OpenOffice Calc: Returns TRUE if value equals #N/A.
- ISNONTEXTLearn the ISNONTEXT function in Apache OpenOffice Calc: Returns TRUE if the value is not text.
- ISNUMBERLearn the ISNUMBER function in Apache OpenOffice Calc: Returns TRUE if value is a number.
- ISODDLearn the ISODD function in Apache OpenOffice Calc: Returns TRUE if the value truncated to integer is odd.
- ISODD_ADDTest odd integer values with OpenOffice ISODD_ADD. Verify the Analysis add-in identity, numeric indicators, negative values …
- ISPMTUse OpenOffice ISPMT’s equal-principal interest model, with native zero-index and endpoint examples that distinguish it from …
- ISREFLearn the ISREF function in Apache OpenOffice Calc: Returns TRUE if value is a reference.
- ISTEXTLearn the ISTEXT function in Apache OpenOffice Calc: Returns TRUE if value is text.
J
K
L
- largeThe LARGE function in OpenOffice Calc returns the k-th largest value in a dataset. Learn syntax, examples, ranking behavior, …
- LCMLearn the LCM function in Apache OpenOffice Calc: Lowest common multiple.
- LCM_ADDApache OpenOffice LCM_ADD examples for common multiples and repeating schedules, with whole-number input validation and …
- LEFTLearn the LEFT function in Apache OpenOffice Calc: Returns the first character or characters of a text.
- LEFTBUse LEFTB in OpenOffice Calc to extract a DBCS-counted prefix. Includes mixed CJK examples, split-character spaces, optional …
- LENLearn the LEN function in Apache OpenOffice Calc: Calculates length of a text string.
- LENBUnderstand LENB in OpenOffice Calc: DBCS length, mixed-language examples, empty text, whitespace and how it differs from LEN …
- LINESTRead LINEST coefficients and statistics in Apache OpenOffice Calc. Verify result positions, residual sums and degrees of …
- lnThe LN function in OpenOffice Calc returns the natural logarithm of a number. Learn syntax, domain rules, examples, and best …
- logThe LOG function in OpenOffice Calc returns the logarithm of a number to a specified base. Learn syntax, domain rules, …
- log10The LOG10 function in OpenOffice Calc returns the base‑10 logarithm of a number. Learn syntax, domain rules, examples, and …
- LOGESTInterpret LOGEST in Apache OpenOffice Calc. Verify exponential coefficients and log-space statistics with explicit INDEX …
- LOGINVOpenOffice LOGINV requires probability, log-mean and log-SD. Build a percentile calculator and verify its results with …
- LOGNORMDISTUse Apache OpenOffice LOGNORMDIST for positive-duration probabilities, with one-to-four-argument syntax, density mode and …
- LOOKUPUse LOOKUP in Apache OpenOffice Calc to find an approximate match in a sorted key column and return a corresponding category. …
- LOWERLearn the LOWER function in Apache OpenOffice Calc: Converts text to lowercase.
M
- MATCHLearn the MATCH function in Apache OpenOffice Calc: Defines a position in an array after comparing values.
- maxThe MAX function in OpenOffice Calc returns the largest numeric value from a list of numbers, ranges, or mixed arguments. …
- MAXAFind mixed-data maxima with OpenOffice MAXA, using native logical, text and blank examples and a clear warning about zero …
- MDETERMCalculate MDETERM in Apache OpenOffice Calc with checked square matrices, determinant identities and careful interpretation …
- MDURATIONCalculate modified bond duration with OpenOffice MDURATION. Check the yield-frequency divisor, source timing conventions and …
- medianThe MEDIAN function in OpenOffice Calc returns the middle value in a dataset. Learn syntax, examples, behavior with even/odd …
- MIDLearn the MID function in Apache OpenOffice Calc: Returns a partial text string of a text.
- MIDBUse MIDB in OpenOffice Calc with a one-based DBCS position, complete and split-character examples, errors, and version …
- minThe MIN function in OpenOffice Calc returns the smallest numeric value from a list of numbers, ranges, or mixed arguments. …
- MINAFind a mixed-data minimum with OpenOffice MINA, with tested text-as-zero, logical and empty-cell rules plus safer treatment …
- MINUTELearn the MINUTE function in Apache OpenOffice Calc: Determines the sequential number for the minute of the hour (0-59) for …
- MINVERSEFind MINVERSE components in Apache OpenOffice Calc using reproducible INDEX examples, exact small matrices and residual …
- MIRRCalculate periodic MIRR in Apache OpenOffice Calc. Separate financing and reinvestment rates, preserve zero periods and …
- MMULTMultiply matrices with Apache OpenOffice MMULT. Check inner dimensions, row-column products, noncommuting examples and …
- modThe MOD function in OpenOffice Calc returns the remainder after division. Learn syntax, behavior with negative numbers, …
- modeThe MODE function in OpenOffice Calc returns the most frequently occurring number in a dataset. Learn syntax, examples, …
- MONTHLearn the MONTH function in Apache OpenOffice Calc: Determines the sequential number of a month of the year (1-12) for the …
- MONTHSUse MONTHS in Apache OpenOffice Calc for complete or calendar-month intervals. See month-end behavior, reversed dates and …
- MROUNDLearn the MROUND function in Apache OpenOffice Calc: Returns a number rounded to a specified multiple.
- MULTINOMIALCount arrangements with OpenOffice MULTINOMIAL, including factorial-ratio examples, probability interpretation and its tested …
- MUNITBuild an identity matrix with MUNIT in Apache OpenOffice Calc. Verify diagonal and off-diagonal components, dimension …
N
- NLearn the N function in Apache OpenOffice Calc: Converts a value to a number.
- NAUse NA in OpenOffice Calc to produce a real missing-data error. See propagation, ISNA detection and the distinction from zero …
- NEGBINOMDISTCalculate failure-count probabilities with Apache OpenOffice Calc NEGBINOMDIST, using its exact count guards and avoiding …
- NETWORKDAYSUse NETWORKDAYS in Apache OpenOffice Calc to count workdays in a date interval without manually excluding weekends. Two …
- NOMINALConvert an effective annual rate to NOMINAL in Apache OpenOffice Calc. Use consistent compounding periods, percentage inputs …
- NOMINAL_ADDConvert effective annual interest to a nominal quote with OpenOffice NOMINAL_ADD. Check compounding frequency, the inverse …
- NORMDISTCalculate normal-model probabilities in Apache OpenOffice with NORMDIST, explicit mean and SD, a default cumulative result …
- NORMINVUse OpenOffice NORMINV to turn a cumulative probability into a normal cutoff, with mean and SD inputs, tail selection and …
- NORMSDISTOpenOffice NORMSDIST examples for standard-normal left-tail probabilities, z-score interpretation and interval checks, with …
- NORMSINVConvert probabilities to z-scores with OpenOffice NORMSINV, then check cutoffs using NORMSDIST and distinguish lower-tail …
- NOTLearn the NOT function in Apache OpenOffice Calc: Reverses the value of the argument.
- NOWUse NOW in Apache OpenOffice Calc to return a live date-and-time value, useful for elapsed-time monitoring. Two original …
- NPERSolve payment counts with OpenOffice NPER, using native zero-rate, beginning-period and growth examples while explaining …
- NPVCalculate periodic NPV in Apache OpenOffice Calc. Place time-zero cash flows correctly, preserve empty-period timing and …
O
- OCT2BINConvert octal strings to signed binary in Apache OpenOffice, with ten-bit output boundaries and a tested rejection of …
- OCT2DECDecode octal text to decimal in Apache OpenOffice, with ten-digit signed interpretation, empty-input behavior and numeric …
- OCT2HEXEncode signed octal values as uppercase hexadecimal in Apache OpenOffice, with forty-bit sign extension and precise width …
- ODDLearn the ODD function in Apache OpenOffice Calc: Rounds a positive number up and negative number down to the nearest odd …
- ODDLPRICEPrice an odd last coupon period with Apache OpenOffice ODDLPRICE. Follow the release’s simple-discount formula, accrued …
- ODDLYIELDDerive an odd-last-period yield in Apache OpenOffice using ODDLYIELD. Check clean versus accrued price, simple annualization …
- OFFSETUse OFFSET in Apache OpenOffice Calc to return a cell or rectangular range shifted from a starting cell. Two original …
- ORLearn the OR function in Apache OpenOffice Calc: Returns TRUE if an argument is TRUE.
P
- PEARSONApache OpenOffice PEARSON returns Pearson’s correlation coefficient. Check signed association, paired samples, covariance …
- percentileThe PERCENTILE function in OpenOffice Calc returns the value at a specified percentile of a dataset. Learn syntax, …
- PERCENTRANKApache OpenOffice Calc PERCENTRANK ranks and interpolates values in a sample, including ties, endpoints and its two-argument …
- PERMUTCount ordered selections without replacement with OpenOffice PERMUT, including zero-choice, fractional-input and …
- PERMUTATIONAUse OpenOffice PERMUTATIONA for ordered selections with repetition, with native n^k examples and its important tested …
- PHIEvaluate the standard-normal density with Apache OpenOffice PHI, including symmetry, scaling to other normal models and …
- piThe PI function in OpenOffice Calc returns the mathematical constant π (pi). Learn syntax, usage in geometry, trigonometry, …
- PMTCalculate level payments with OpenOffice PMT, using native zero-rate and annuity-due examples, signed balances and explicit …
- POISSONOpenOffice POISSON examples distinguish masses from cumulative counts, explain its zero-mean convention and use consistent …
- powerThe POWER function in OpenOffice Calc raises a number to a specified exponent. Learn syntax, examples, exponent rules, common …
- PPMTCalculate principal repayment with OpenOffice PPMT, using native payment splits, zero-interest cases and beginning-period …
- PRICECalculate OpenOffice PRICE for regular coupon bonds. Reconcile discounted coupons, redemption and accrued interest, with …
- PRICEDISCPrice a discounted redemption with Apache OpenOffice PRICEDISC. Follow verified date-basis examples and the release-specific …
- PRICEMATPrice maturity-paid interest with OpenOffice PRICEMAT. Separate the discounted total payment from accrued interest and verify …
- PROBSum discrete probabilities with OpenOffice PROB, using native inclusive ranges, duplicate outcomes, reversed bounds and the …
- productThe PRODUCT function in OpenOffice Calc multiplies all numbers in a list, range, or array. Learn syntax, examples, array …
- PROPERLearn the PROPER function in Apache OpenOffice Calc: Capitalizes the first letter in all words.
- PVDiscount fixed cash flows with OpenOffice PV, using native end- and beginning-period examples, zero-rate checks and …
Q
R
- RADIANSLearn the RADIANS function in Apache OpenOffice Calc: Converts degrees to radians.
- randThe RAND function in OpenOffice Calc returns a random decimal number between 0 and 1. Learn syntax, recalculation behavior, …
- randbetweenThe RANDBETWEEN function in OpenOffice Calc returns a random integer between two specified numbers. Learn syntax, …
- rankThe RANK function in OpenOffice Calc returns the rank of a number within a dataset. Learn syntax, descending vs ascending …
- RATESolve a level-payment interest rate in Apache OpenOffice with RATE. Check cash-flow signs, payment timing, periodic units and …
- RECEIVEDCalculate RECEIVED in Apache OpenOffice Calc. Reconcile discounted investment and redemption amounts with explicit day-count …
- REPLACELearn the REPLACE function in Apache OpenOffice Calc: Replaces characters within a text string with a different text string.
- REPTLearn the REPT function in Apache OpenOffice Calc: Repeats text a given number of times.
- RIGHTLearn the RIGHT function in Apache OpenOffice Calc: Returns the last character or characters of a text.
- RIGHTBLearn RIGHTB in OpenOffice Calc with DBCS suffix examples, partial-character spaces, default length, error cases and official …
- ROMANLearn the ROMAN function in Apache OpenOffice Calc: Converts a number to a Roman numeral.
- ROT13Use ROT13 in Apache OpenOffice Calc to rotate Latin letters by 13 positions for reversible text obfuscation.
- roundThe ROUND function in OpenOffice Calc rounds a number to a specified number of decimal places. Learn syntax, examples, …
- ROUNDDOWNLearn the ROUNDDOWN function in Apache OpenOffice Calc: Rounds a number down to a predefined accuracy.
- ROUNDUPLearn the ROUNDUP function in Apache OpenOffice Calc: Rounds a number up to the predefined accuracy.
- ROWLearn the ROW function in Apache OpenOffice Calc: Defines the internal row number of a reference.
- ROWSLearn the ROWS function in Apache OpenOffice Calc: Returns the number of rows in a reference or array.
- RRIFind an equivalent compound growth rate with OpenOffice RRI, using native ODF-mapped examples, loss cases and a clear …
- RSQUse RSQ in Apache OpenOffice for squared Pearson correlation, with an intercept-fitted regression example and cautions about …
S
- SEARCHLearn the SEARCH function in Apache OpenOffice Calc: Looks for one text value within another (not case-sensitive).
- SECCalculate secant with OpenOffice SEC, using native real-input examples, even-function checks and precise zero and …
- SECHCalculate hyperbolic secant with OpenOffice SECH, using native real-input examples, even-function checks and precise zero and …
- SECONDLearn the SECOND function in Apache OpenOffice Calc: Determines the sequential number of the second of a minute (0-59) for …
- SERIESSUMEvaluate power series with OpenOffice SERIESSUM, including native coefficient order, blank-position behavior and the …
- SHEETFind worksheet positions with SHEET in OpenOffice Calc using references, sheet-name text and three-dimensional ranges. …
- SHEETSCount sheets with SHEETS in OpenOffice Calc. Compare a whole workbook, a single-sheet reference and a contiguous …
- signThe SIGN function in OpenOffice Calc returns the sign of a number: -1, 0, or 1. Learn syntax, behavior, examples, and best …
- sinThe SIN function in OpenOffice Calc returns the sine of an angle (in radians). Learn syntax, degree conversion, examples, and …
- SINHLearn the SINH function in Apache OpenOffice Calc: Returns the hyperbolic sine of a number.
- SKEWMeasure adjusted sample skewness in Apache OpenOffice, with sign, scaling and constant-data examples plus exact formula and …
- SLNCompute straight-line depreciation with OpenOffice SLN, using native cost-and-salvage examples while separating arithmetic …
- SLOPEApache OpenOffice SLOPE estimates y change per x unit. Verify argument order, fitted values and why reversing the regression …
- smallThe SMALL function in OpenOffice Calc returns the k-th smallest value in a dataset. Learn syntax, examples, ranking behavior, …
- sqrtThe SQRT function in OpenOffice Calc returns the square root of a number. Learn syntax, examples, error conditions, and best …
- SQRTPILearn the SQRTPI function in Apache OpenOffice Calc: Returns the square root of a number which has been multiplied by pi.
- STANDARDIZEConvert a value to a z-score with Apache OpenOffice STANDARDIZE, using explicit mean and positive SD, signed results and …
- stdevThe STDEV function in OpenOffice Calc calculates the sample standard deviation of a dataset. Learn syntax, examples, …
- STDEVAMeasure sample standard deviation with OpenOffice STDEVA, including native logical and text coercion, sample-size errors and …
- stdevpThe STDEVP function in OpenOffice Calc calculates the population standard deviation of a dataset. Learn syntax, examples, …
- STDEVPACalculate population standard deviation with OpenOffice STDEVPA, using native typed-cell cases, logical-flag spread and clear …
- STEYXApache OpenOffice STEYX measures simple-regression residual spread with n−2 degrees of freedom. Compare fitted errors, mean …
- STYLEUse OpenOffice Calc STYLE syntax to understand cell-style requests, optional timed changes and the zero numeric result, with …
- SUBSTITUTELearn the SUBSTITUTE function in Apache OpenOffice Calc: Substitutes new text for old text in a string.
- subtotalThe SUBTOTAL function in OpenOffice Calc performs calculations on filtered or visible data. Learn syntax, function codes, …
- sumThe SUM function in OpenOffice Calc adds numbers, cell ranges, or mixed arguments. Learn syntax, examples, common errors, and …
- sumifThe SUMIF function in OpenOffice Calc adds values based on a single condition. Learn syntax, examples, common errors, and …
- sumifsThe SUMIFS function in OpenOffice Calc adds values that meet multiple conditions. Learn syntax, examples, common errors, and …
- sumproductThe SUMPRODUCT function in OpenOffice Calc multiplies corresponding elements in arrays and returns the sum of those products. …
- SUMSQLearn the SUMSQ function in Apache OpenOffice Calc: Returns the sum of the squares of the arguments.
- SUMX2MY2Use SUMX2MY2 in Apache OpenOffice Calc to subtract paired squared values. Compare the three sum-of-squares functions with …
- SUMX2PY2Add paired squared values with SUMX2PY2 in Apache OpenOffice Calc. Follow numeric-range examples and distinguish squared sums …
- SUMXMY2Sum squared pairwise differences with SUMXMY2 in Apache OpenOffice Calc. Use aligned numeric ranges, exact examples and …
- SYDCalculate sum-of-years-digits depreciation with OpenOffice SYD, including native early and final periods, weighting checks …
T
- TLearn the T function in Apache OpenOffice Calc: Returns a value if it is text, otherwise an empty string.
- tanThe TAN function in OpenOffice Calc returns the tangent of an angle (in radians). Learn syntax, degree conversion, undefined …
- TANHLearn the TANH function in Apache OpenOffice Calc: Returns the hyperbolic tangent of a number.
- TBILLEQCalculate OpenOffice TBILLEQ with verified discount-yield examples. Understand its maturity-plus-one US 30/360 count instead …
- TBILLPRICEInspect TBILLPRICE in Apache OpenOffice Calc with native examples. Its verified 30/360-plus-maturity-day implementation needs …
- TBILLYIELDUse TBILLYIELD in Apache OpenOffice Calc with verified date arithmetic. Distinguish its inclusive US 30/360 day count from …
- TDISTUse Apache OpenOffice Calc TDIST for one- or two-tail Student t probabilities, with mandatory mode, nonnegative input and …
- TEXTUse TEXT in Apache OpenOffice Calc to produce a formatted text label from a number without changing the original numeric …
- TIMELearn the TIME function in Apache OpenOffice Calc: Determines a time value from the details for hour, minute and second.
- TIMEVALUEConvert time text to a fraction of a day with Apache OpenOffice TIMEVALUE. Verify seconds, midnight, date-time extraction and …
- TINVCalculate two-tail Student t cutoffs with Apache OpenOffice Calc TINV, including confidence margins, probability endpoints …
- TODAYUse TODAY in Apache OpenOffice Calc to insert the current calendar date without typing it again. Two original examples, …
- TRANSPOSEUse TRANSPOSE in Apache OpenOffice Calc to rotate a rectangular dataset so rows become columns and columns become rows. Two …
- TRENDReturn linear TREND components in Apache OpenOffice Calc. Compare fitted and forced-origin models, default x values and …
- TRIMLearn the TRIM function in Apache OpenOffice Calc: Removes extra spaces from text.
- TRIMMEANUse Apache OpenOffice TRIMMEAN with total trimming fractions, even-count rounding and worked outlier examples that …
- TRUELearn the TRUE function in Apache OpenOffice Calc: Returns the logical value TRUE.
- truncThe TRUNC function in OpenOffice Calc removes the fractional part of a number by truncating toward zero. Learn syntax, …
- TTESTApache OpenOffice Calc TTEST covers paired, pooled and Welch mean comparisons, with reproducible p-values and the one-tail …
- TYPEIdentify numbers, text, logical values, formulas, errors, and arrays with TYPE in Apache OpenOffice Calc.
U
- UNICHARConvert a Unicode number into a character with UNICHAR in Apache OpenOffice Calc, with practical symbol examples and …
- UNICODEFind the Unicode number of the first character in text with Apache OpenOffice Calc UNICODE, including practical audit …
- UPPERLearn the UPPER function in Apache OpenOffice Calc: Converts text to uppercase.
V
- VALUELearn the VALUE function in Apache OpenOffice Calc: Converts text to a number.
- varThe VAR function in OpenOffice Calc calculates the sample variance of a dataset. Learn syntax, examples, statistical meaning, …
- VARACalculate sample variance with OpenOffice VARA, including native mixed-type examples, the n−1 denominator and the difference …
- varpThe VARP function in OpenOffice Calc calculates the population variance of a dataset. Learn syntax, examples, statistical …
- VARPAUse OpenOffice VARPA for population variance, with verified mixed-data coercion, the n denominator and explicit singleton …
- VDBCalculate variable declining-balance depreciation in Apache OpenOffice VDB. Compare straight-line switching, fractional …
- VLOOKUPLearn the VLOOKUP function in Apache OpenOffice Calc: Vertical search and reference to indicated cells.
W
- WEEKDAYLearn the WEEKDAY function in Apache OpenOffice Calc: Returns the day of the week for the date value as an integer.
- WEEKNUMUse WEEKNUM in Apache OpenOffice Calc to calculate an ISO-8601 week number in Apache OpenOffice Calc without accidentally …
- WEEKNUM_ADDApache OpenOffice WEEKNUM_ADD returns legacy week numbers. Compare Sunday and Monday starts, check year boundaries and …
- WEEKSCount date intervals with WEEKS in Apache OpenOffice Calc. Compare whole weeks and calendar mode, including the verified New …
- WEEKSINYEARReturn 52 or 53 with WEEKSINYEAR in Apache OpenOffice Calc. Understand the calendar-year input and ISO week-year boundary …
- WEIBULLModel lifetime probabilities with WEIBULL in Apache OpenOffice, using explicit shape, scale and cumulative mode, interval …
- WORKDAYUse WORKDAY in Apache OpenOffice Calc to find a due date a set number of working days after an initial date. Two original …
X
- XIRRCalculate dated cash-flow returns with Apache OpenOffice XIRR. Verify actual-day timing, the fixed 365 denominator, guesses …
- XNPVDiscount irregular dated cash flows with OpenOffice XNPV. Verify the first-date anchor, fixed 365-day exponent and leap-year …
- XORLearn the XOR function in Apache OpenOffice Calc: Returns TRUE if an odd number of arguments evaluates to TRUE.
Y
- YEARLearn the YEAR function in Apache OpenOffice Calc: Returns the year of a date value as an integer.
- YEARFRACUse YEARFRAC in Apache OpenOffice Calc with explicit day-count bases. See its actual/actual implementation, positive reversed …
- YEARSCalculate year intervals with YEARS in Apache OpenOffice Calc. Compare calendar years, completed-month rules and leap-day …
- YIELDFind a regular-coupon bond yield in Apache OpenOffice Calc. Check clean price, coupon frequency, day-count basis and a PRICE …
- YIELDDISCCalculate a discount security’s yield with OpenOffice YIELDDISC. Compare price-based return with DISC and inspect …
- YIELDMATFind OpenOffice YIELDMAT for interest paid at maturity. Include accrued interest in the settlement denominator and check the …
Z
No functions match your filters. Try a different name or category.