Gnumeric — Function Directory
Browse 641 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Gnumeric.
641 functions
Browse by category
A
- ABSCalculate absolute magnitudes with Gnumeric ABS, distinguish signed differences from error sizes and reproduce a native …
- ACCRINTMCalculate Gnumeric accrued interest paid at maturity, with optional par, basis-specific day counts and source-checked …
- ACOSRecover a principal angle with Gnumeric ACOS, convert radians to degrees and diagnose inputs outside the closed cosine …
- ACOSHLearn the ACOSH function in Gnumeric: Returns the inverse hyperbolic cosine of a number.
- ACOTUse Gnumeric ACOT with radians, worked examples and the negative-input branch difference from Excel, checked against Gnumeric …
- ACOTHLearn the ACOTH function in Gnumeric: Returns the inverse hyperbolic cotangent of a number.
- ADDRESSBuild Gnumeric cell-reference text with ADDRESS, including absolute and relative modes, sheet names and verified argument …
- ADTESTRun Gnumeric Anderson-Darling normality checks with ADTEST, reading its p-value, corrected statistic and included sample …
- AGMCalculate the arithmetic-geometric mean with Gnumeric AGM. Includes syntax, a worked example and numerical guidance.
- AMORDEGRCCalculate coefficient-based declining depreciation for a selected accounting period in Gnumeric, including first-period …
- AMORLINCCalculate prorated first-period and straight-line asset depreciation in Gnumeric with AMORLINC, required basis, schedules and …
- ANDCombine logical tests with Gnumeric AND, interpreting numeric truth values, ignored range entries and errors without assuming …
- ARABICLearn the ARABIC function in Gnumeric: Calculates the value of a Roman numeral.
- AREASCount separate reference areas with Gnumeric AREAS, distinguishing a single rectangular range from multiple referenced areas.
- ARRAYConstruct a vertical Gnumeric ARRAY from ordered arguments and ranges, preserve types, and verify nested lists and …
- ASCConvert fullwidth inventory labels with Gnumeric ASC. Learn syntax, katakana handling, leading-zero text, locale effects, and …
- ASCENSIONTHURSDAYCalculate Gnumeric ASCENSIONTHURSDAY and audit its 39-day Easter offset, explicit-year schedule and next-occurrence default.
- ASHWEDNESDAYUse Gnumeric ASHWEDNESDAY for Gregorian calendar dates. Verify its 46-day offset, optional-year behavior and two-digit-year …
- ASINFind principal inverse-sine angles in Gnumeric with ASIN, valid ratios, radian-to-degree conversion and right-triangle …
- ASINHUse Gnumeric ASINH for signed inverse-hyperbolic transformations, with SINH inverse checks and reproducible numeric examples.
- ATANLearn the ATAN function in Gnumeric: Returns the arctangent of a number.
- ATAN2Find quadrant-aware angles in Gnumeric with ATAN2, spreadsheet x/y order, radian output and normalized degree bearings.
- ATANHUse Gnumeric ATANH inside its strict open domain, verify endpoint errors and check the inverse transformation with TANH.
- AVEDEVLearn the AVEDEV function in Gnumeric: Returns the average of the absolute deviations of a sample from the mean.
- AVERAGELearn the AVERAGE function in Gnumeric: Returns the average of a sample.
- AVERAGEALearn Gnumeric AVERAGEA with numbers, logical values, text and blanks. Includes a reproducible dataset and the 1.12.57 versus …
- AVERAGEIFAverage values selected by one criterion with Gnumeric AVERAGEIF, keeping criteria and value ranges aligned and checking …
- AVERAGEIFSLearn the AVERAGEIFS function in Gnumeric: Averages the value of the cells that meet multiple criteria in multiple ranges.
B
- BERNOULLICalculate Bernoulli point probabilities in Gnumeric, validate 0/1 outcomes and probability bounds, and build weighted and …
- BESSELIEvaluate modified Bessel I in Gnumeric with native examples, fractional orders, recurrence checks and the …
- BESSELJCalculate Bessel J in Gnumeric with native examples, fractional-order history, signed inputs, recurrence checks and a precise …
- BESSELKEvaluate modified Bessel K in Gnumeric with native examples, fractional orders, positive-input checks and a precise …
- BESSELYUse Gnumeric BESSELY with native real-valued examples, fractional-order history, recurrence checks and explicit negative-x …
- BETABETA evaluates Euler’s beta special function B(x,y).
- BETA.DISTUse Gnumeric BETA.DIST for bounded probabilities or densities, including optional interval bounds, rescaled density and …
- BETADISTBETADIST returns the left-tail cumulative probability of a beta model on a bounded interval.
- BETAINVBETAINV finds a cutoff on a bounded beta distribution from a left-tail probability.
- BETALNBETALN returns the natural logarithm of the absolute value of Euler’s beta function: ln|B(x,y)|.
- BIN2DECDecode Gnumeric binary strings with BIN2DEC, the signed 10-bit convention, leading zeros and invalid-digit checks.
- BIN2HEXConvert binary text to hexadecimal with Gnumeric BIN2HEX, including padded output, ten-bit signed values, native examples and …
- BIN2OCTUse Gnumeric BIN2OCT to convert binary strings to octal text, with padding, signed ten-bit examples, roundtrips and tested …
- BINOM.DIST.RANGEFind inclusive binomial interval probabilities in Gnumeric, with optional upper count, cumulative checks and out-of-support …
- BINOMDISTBINOMDIST returns either the probability of exactly n successes or the probability of at most n successes in a fixed number …
- BITANDUse Gnumeric BITAND to test shared binary flags, with range examples, fractional inputs and explicit 1.12.57 versus 1.12.62 …
- BITLSHIFTShift binary masks left in Gnumeric, with negative shifts, fractional-count flooring, 64-bit wraparound and explicitly scoped …
- BITORCombine numeric flags with Gnumeric BITOR, including multiple inputs, ranges, empty collections and version-specific text and …
- BITRSHIFTUse Gnumeric BITRSHIFT for binary fields and integer division, with negative-shift reversal, lost-bit examples and native …
- BITXORToggle and compare binary flags with Gnumeric BITXOR, with native examples and clear newer-source differences for text, …
C
- CAUCHYUse Gnumeric CAUCHY with its verified upper-tail cumulative mode, density examples, positive scale and a clear comparison …
- CEILRound a number up to the nearest integer with Gnumeric CEIL. Includes numeric examples and how CEIL differs from CEILING.
- CEILINGRound to multiples with Gnumeric CEILING, including negative values, significance signs and omitted defaults.
- CELLInspect a referenced cell with Gnumeric CELL, using supported information selectors and recognizing format-dependent results.
- CHARLearn the CHAR function in Gnumeric: Converts a code number into a character or letter.
- CHIDISTCHIDIST returns the right-tail probability of a chi-squared distribution.
- CHIINVCHIINV converts a right-tail probability into a chi-squared cutoff.
- CHITESTLearn the CHITEST function in Gnumeric: Returns the chi square independence test.
- CHOLESKYFactor a symmetric positive-definite matrix in Gnumeric with CHOLESKY, lower-triangular array output and covariance …
- CHOOSESelect a value by its one-based position with Gnumeric CHOOSE, including scenario controls, truncation and index errors.
- CLEANLearn the CLEAN function in Gnumeric: Removes character codes below32 from text in Gnumeric 1.12.62.
- CODEInspect Windows-1252 character codes in Gnumeric with CODE, first-character behavior, non-ASCII examples and empty-text …
- COLUMNReturn worksheet column numbers with Gnumeric COLUMN, including omitted references, absolute references and horizontal range …
- COLUMNNUMBERConvert an Excel-style column label such as AA into a column index using Gnumeric COLUMNNUMBER.
- COLUMNSLearn the COLUMNS function in Gnumeric: Returns the number of columns in an array or reference.
- COMBINCount unordered selections in Gnumeric with COMBIN, no-repetition assumptions, fractional coercion and small-set checks.
- COMBINACount unordered selections with repetition using Gnumeric COMBINA, with enumeration, flooring and domain checks.
- COMPLEXLearn the COMPLEX function in Gnumeric: Converts real and imaginary coefficients into a complex number.
- CONCATJoin Gnumeric text and ranges with CONCAT, preserve identifiers and explicit formatting, and check blank, error and delimiter …
- CONCATENATELearn the CONCATENATE function in Gnumeric: Combines several text items into one.
- CONFIDENCELearn the CONFIDENCE function in Gnumeric: Calculates the normal-based margin of error for a mean confidence interval; add or …
- CONFIDENCE.TLearn the CONFIDENCE.T function in Gnumeric: Calculates a Student's t-based confidence-interval margin of error using the …
- CONVERTConvert compatible measurement units in Gnumeric with CONVERT, exact unit symbols, verified examples and incompatible-unit …
- CORRELLearn the CORREL function in Gnumeric: Returns the correlation coefficient.
- COSLearn the COS function in Gnumeric: Returns the cosine of a number.
- COSHCalculate hyperbolic cosine in Gnumeric with COSH, symmetry checks and a scaled catenary-height example.
- COSPIUse Gnumeric COSPI to calculate cosine at exact multiples of pi. See a simple example, syntax and interpretation.
- COTLearn the COT function in Gnumeric: Returns the cotangent of a number.
- COTHLearn the COTH function in Gnumeric: Returns the hyperbolic cotangent of a number.
- COTPIUse COTPI in Gnumeric to calculate cotangent of a multiple of pi. Includes half-turn examples, singularities and degree …
- COUNTCount numeric observations in Gnumeric with COUNT, zeros, text-formatted numbers, blanks and build-specific direct arguments.
- COUNTACount populated values with Gnumeric COUNTA, including errors and formula-generated empty text while distinguishing truly …
- COUNTBLANKLearn the COUNTBLANK function in Gnumeric: Counts the blank cells in a specified range.
- COUNTIFCount cells meeting one criterion in Gnumeric with COUNTIF, category matches, numeric thresholds and escaped wildcards.
- COUNTIFSCount aligned rows meeting multiple criteria in Gnumeric COUNTIFS, with quoted conditions, cell-driven thresholds and …
- COUPDAYBSWith settlement May 15, 2026, maturity December 31, 2028, semiannual coupons and basis 0, COUPDAYBS returns 135 convention …
- COUPDAYSFor the same semiannual coupon schedule, COUPDAYS can return 180, 181 or 182.5, depending on basis. It is a coupon-period …
- COUPDAYSNCFor settlement May 15, 2026 and the next semiannual coupon on June 30, COUPDAYSNC gives 45 under basis 0 and 46 under …
- COUPNCDFor settlement May 15, 2026, maturity December 31, 2028 and two payments per year, COUPNCD identifies June 30, 2026, the next …
- COUPNUMFor settlement May 15, 2026, maturity December 31, 2028 and two payments per year, COUPNUM returns 6 scheduled coupons after …
- COUPPCDFor settlement May 15, 2026, maturity December 31, 2028 and two payments per year, COUPPCD identifies December 31, 2025. On a …
- COVARLearn the COVAR function in Gnumeric: Calculates the population covariance.
- COVARIANCE.SCalculate sample covariance with COVARIANCE.S in Gnumeric. Includes paired data, ignored-row behavior, the n−1 divisor and …
- CRITBINOMCRITBINOM returns a binomial quantile: the smallest count k whose cumulative probability P(X≤k) reaches the requested alpha.
- CRONBACHCalculate Cronbach's alpha in Gnumeric from aligned item ranges, with a reproducible two-item example and careful …
- CSCLearn the CSC function in Gnumeric: Return the cosecant of an angle. CSC(x)=1/SIN(x).
- CSCHLearn the CSCH function in Gnumeric: Return the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x).
- CUM_BIV_NORM_DISTUse Gnumeric CUM_BIV_NORM_DIST for joint normal probabilities, with standardization, correlation, native examples and …
- CUMIPMTCalculate total loan interest paid across selected payment periods with Gnumeric CUMIPMT; compare to IPMT and audit signs.
- CUMPRINCCalculate total loan principal repaid across selected payment periods with Gnumeric CUMPRINC and verify remaining balances.
- CVMTESTTest fitted-normal sample shape in Gnumeric with CVMTEST, a three-row p-value/statistic/count result and Cramer-von Mises …
D
- DATELearn the DATE function in Gnumeric: Provides an internal number for the date given.
- DATE2HDATEConvert a Gregorian spreadsheet date to romanized Hebrew-date text in Gnumeric, with explicit date inputs and …
- DATE2HDATE_HEBConvert a Gregorian date serial to Hebrew-calendar text with Gnumeric DATE2HDATE_HEB, using explicit dates and exact Unicode …
- DATE2JULIANConvert a Gnumeric Gregorian date into an integer Julian day number, with noon-convention, date-system and near-midnight …
- DATEDIFUse DATEDIF in Gnumeric to measure completed years or days between two dates without counting partial anniversaries as full …
- DATEVALUELearn the DATEVALUE function in Gnumeric: Returns an internal number for a text having a possible date format.
- DAVERAGEUse DAVERAGE in Gnumeric to calculate the mean of a numeric field for records that meet your conditions. Includes criteria …
- DAYExtract day-of-month numbers in Gnumeric with DAY, leap dates, timestamps and a first-of-month calculation.
- DAYSLearn the DAYS function in Gnumeric: Calculates the number of days between two dates.
- DAYS360Learn the DAYS360 function in Gnumeric: Calculates the number of days between two dates based on a 360-day year.
- DBUse DB in Gnumeric for fixed-declining depreciation. Reproduce the three-decimal rate, partial first year and …
- DCOUNTUse DCOUNT in Gnumeric to count matching records whose selected field contains a number. Includes criteria examples, expected …
- DCOUNTAUse DCOUNTA in Gnumeric to count populated cells in a field after selecting records with criteria. Includes criteria …
- DDBBuild a double-declining depreciation schedule with DDB in Gnumeric. Understand the optional factor, salvage clipping, period …
- DEC2BINConvert decimal integers to binary text in Gnumeric, with zero padding, signed ten-bit results and verified range errors.
- DEC2HEXLearn the DEC2HEX function in Gnumeric: Converts a decimal number to a hexadecimal number.
- DEC2OCTConvert decimal values with Gnumeric DEC2OCT: signed range, fractional truncation, padded octal text, negative complements …
- DECIMALConvert digit text from a specified base to its decimal numeric value in Gnumeric, with examples and version-specific limits.
- DEGREESLearn the DEGREES function in Gnumeric: Converts a radian to degrees.
- DELTALearn the DELTA function in Gnumeric: Tests whether two values are equal.
- DEVSQLearn the DEVSQ function in Gnumeric: Returns the sum of squares of deviations from the sample mean value.
- DGETUse DGET in Gnumeric to retrieve one field from exactly one matching record. Includes criteria examples, expected results and …
- DIGAMMAEvaluate Gnumeric DIGAMMA with native examples, harmonic-number identities, recurrence checks and explicit poles on the …
- DIMCIRCSize a loss-system circuit group in Gnumeric with DIMCIRC using offered traffic and a target blocking probability, with …
- DISCCalculate a security’s annual discount rate in Gnumeric with DISC. Compare redemption-based discounts with investment-based …
- DMAXUse DMAX in Gnumeric to find the largest numeric value among records meeting your criteria. Includes criteria examples, …
- DMINUse DMIN in Gnumeric to find the smallest numeric value among records meeting your criteria. Includes criteria examples, …
- DOLLARFormat numbers as currency text with Gnumeric DOLLAR, checking decimal rounding and locale-sensitive presentation.
- DOLLARDEConvert fractional quote notation with DOLLARDE in Gnumeric. Distinguish encoded decimal digits from an ordinary decimal …
- DOLLARFREncode decimal values as fractional quotes with DOLLARFR in Gnumeric. Learn denominator scaling, non-rounded numerators and …
- DPRODUCTUse DPRODUCT in Gnumeric to multiply the numeric factors from records selected by criteria. Includes criteria examples, …
- DSTDEVUse DSTDEV in Gnumeric to calculate sample standard deviation for a criteria-selected numeric field. Includes criteria …
- DSTDEVPUse DSTDEVP in Gnumeric to calculate population standard deviation for the records selected by criteria. Includes criteria …
- DSUMUse DSUM in Gnumeric to total a numeric field from records that meet visible worksheet criteria. Includes criteria examples, …
- DVARUse DVAR in Gnumeric to calculate sample variance of a numeric field selected by criteria. Includes criteria examples, …
- DVARPUse DVARP in Gnumeric to calculate population variance for a criteria-selected numeric field. Includes criteria examples, …
E
- EASTERSUNDAYCalculate Gregorian Easter Sunday in Gnumeric, with explicit-year examples, two-digit-year rules and carefully scoped …
- EDATELearn the EDATE function in Gnumeric: Returns the serial number of the date that is a specified number of months before or …
- EFFECTConvert a nominal yearly interest rate to its effective annual rate in Gnumeric, with quarterly and monthly compounding …
- EIGENFind eigenvalues and eigenvectors of real symmetric matrices in Gnumeric with EIGEN, column layout, ordering and …
- ENCODEURLEncode text for URL use with Gnumeric ENCODEURL, preserving the distinction between encoding a component and building an …
- EOMONTHLearn the EOMONTH function in Gnumeric: Returns the serial number of the last day of the month that comes a certain number of …
- ERFCalculate Gnumeric ERF with one or two limits, including signed intervals, native tail examples, normal-probability …
- ERFCUse Gnumeric ERFC for complementary error-function tails, with native small-value examples, negative inputs and a clear …
- ERRORCreate actual spreadsheet error values with Gnumeric ERROR, including custom messages and verified ISNA and ISERROR checks.
- ERROR.TYPELearn the ERROR.TYPE function in Gnumeric: Returns a number corresponding to one of the error values or #N/A if no error …
- EUROLook up Gnumeric’s fixed historical euro conversion constants with EURO. Use exact legacy currency codes and distinguish this …
- EVENLearn the EVEN function in Gnumeric: Rounds a positive number up and negative number down to the nearest even integer.
- EXACTLearn the EXACT function in Gnumeric: Specifies whether two texts are identical.
- EXPCalculate exponential growth and decay in Gnumeric with EXP, continuous-rate units and reproducible time-based models.
- EXPM1Use Gnumeric EXPM1 for exp(x) minus one, especially for small values where numerical accuracy matters. Includes a worked …
- EXPONDISTEXPONDIST evaluates an exponential waiting-time model.
- EXPPOWDISTUse Gnumeric EXPPOWDIST for symmetric exponential-power densities. See shape versus scale, Laplace and normal cases, native …
- EXPRESSIONRead a cell formula as text without its leading equals sign using Gnumeric EXPRESSION, with constant and multi-cell checks.
F
- FACTCalculate Gnumeric factorials and fractional Gamma extensions, with verified examples and negative-integer errors.
- FACTDOUBLELearn the FACTDOUBLE function in Gnumeric: Returns the double factorial of Number.
- FALSELearn the FALSE function in Gnumeric: Defines the logical value as FALSE.
- FDISTFDIST returns the right-tail probability of an F distribution.
- FIBUse FIB in Gnumeric for Fibonacci numbers, with worked recurrence checks, input rules and native evidence of large-index …
- FINDLearn the FIND function in Gnumeric: Looks for a string of text within another (case sensitive).
- FINDBFind case-sensitive UTF-8 byte positions with FINDB in Gnumeric. Check starting offsets, empty searches, multibyte text and …
- FINVFINV returns an F-distribution cutoff from a right-tail probability.
- FISHERLearn the FISHER function in Gnumeric: Returns the Fisher transformation.
- FISHERINVLearn the FISHERINV function in Gnumeric: Returns the inverse of the Fisher transformation.
- FIXEDFormat a number as text with Gnumeric FIXED, choosing decimal places and separator behavior while retaining numeric inputs …
- FLIPReverse rows or columns with Gnumeric FLIP while preserving matrix dimensions and values; verify direction, changed inputs …
- FLOORRound to multiples in Gnumeric with FLOOR, optional sign-dependent defaults and explicit negative-number behavior.
- FLT.MAXUse Gnumeric FLT.MAX to inspect the numeric upper limit, distinguish range from precision and build overflow-aware binary64 …
- FLT.MINUnderstand Gnumeric FLT.MIN as the smallest positive normal value, with binary64 examples, subnormal comparisons and scaling …
- FLT.NEXTAFTERUse Gnumeric FLT.NEXTAFTER to inspect neighboring representable numbers, direction rules, binary64 spacing and source-checked …
- FLT.RADIXInspect Gnumeric’s floating-point radix, distinguish binary and decimal numeric builds, and avoid confusing internal base …
- FORECASTLearn the FORECAST function in Gnumeric: Returns a value along a linear regression.
- FOURIERTransform real sequences in Gnumeric with FOURIER, complex or split output, power-of-two padding and normalization in both …
- FREQUENCYBuild Gnumeric frequency arrays with sorted upper cutoffs, an overflow bucket and explicit treatment of duplicate bins, …
- FTESTCompare two independent sample variances in Gnumeric with FTEST, a two-sided p-value, numeric sample checks and normality …
- FVLearn the FV function in Gnumeric: Future value. Returns the future value of an investment based on regular payments and a …
- FVSCHEDULECompound a changing rate schedule with FVSCHEDULE in Gnumeric. Reproduce a period-by-period balance and distinguish blank …
G
- G_DURATIONUse G_DURATION in Gnumeric to solve the number of compounding periods between two values. Interpret fractional periods and …
- G_PRODUCTMultiply numeric inputs with Gnumeric G_PRODUCT. See empty-product behavior, ignored text and Booleans, range examples and …
- GAMMAGAMMA evaluates the complete Gamma special function Γ(x), extending the factorial relationship beyond positive integers.
- GAMMADISTCalculate Gnumeric gamma probabilities and densities with required cumulative mode, scale parameters and shape-dependent …
- GAMMAINVFind gamma quantiles in Gnumeric using shape and scale, including parameter conversion, inverse checks and probability …
- GAMMALNUse Gnumeric GAMMALN for log-gamma and factorial work, with native examples and its product-specific accepted negative …
- GAUSSCalculate signed area under the standard normal curve between zero and a z-score.
- GCDFind a greatest common divisor in Gnumeric, with fractional truncation, mixed ranges and the all-zero error explained.
- GDCalculate the Gudermannian with Gnumeric GD, using native radian examples, hyperbolic identities and finite-precision …
- GEOMDISTCalculate failures-before-success probabilities in Gnumeric, with exact-count versus cumulative examples and its rejected …
- GEOMEANLearn the GEOMEAN function in Gnumeric: Returns the geometric mean of a sample.
- GESTEPLearn Gnumeric GESTEP: return 1 when a number meets or exceeds a threshold, including the default threshold of zero.
- GET.FORMULARead a cell formula including its leading equals sign with Gnumeric GET.FORMULA, distinguishing formulas, constants and …
- GET.LINKExtract a styled cell hyperlink target with Gnumeric GET.LINK, including a verified GUI example, empty-link behavior and …
- GETENVRead a named process-environment value with Gnumeric GETENV, using harmless synthetic variables and checking missing-variable …
- GETPIVOTDATAUse Gnumeric GETPIVOTDATA for its limited range-first field lookup, with bottom-row controls, errors and pivot-compatibility …
- GNUMERIC_VERSIONDisplay the installed Gnumeric version using GNUMERIC_VERSION to troubleshoot formula compatibility.
- GOODFRIDAYCalculate Good Friday in Gnumeric with a two-day Easter offset. Build explicit-year checks and distinguish calendar dates …
- GROWTHLearn the GROWTH function in Gnumeric: Calculates points on the exponential regression function.
H
- HARMEANLearn the HARMEAN function in Gnumeric: Returns the harmonic mean of a sample.
- HDATEConvert Gregorian components to transliterated Hebrew-calendar labels with Gnumeric HDATE, distinguishing display text from …
- HDATE_DAYConvert Gregorian date components to Hebrew day-of-month numbers in Gnumeric with HDATE_DAY, reproducible dates and …
- HDATE_HEBConvert Gregorian date components to Hebrew-script calendar labels with Gnumeric HDATE_HEB, preserving exact Unicode output.
- HDATE_JULIANCalculate a Julian day number from explicit Gregorian components in Gnumeric and distinguish optional current-date defaults …
- HDATE_MONTHConvert Gregorian year, month, and day components to Gnumeric's zero-based Hebrew month index, with Tishrei and leap-month …
- HDATE_YEARConvert Gregorian date components to Hebrew calendar years in Gnumeric with HDATE_YEAR, new-year boundaries and explicit date …
- HEX2BINDecode hexadecimal text with Gnumeric HEX2BIN, using native-tested binary outputs, width rules, prefix handling and important …
- HEX2DECLearn the HEX2DEC function in Gnumeric: Converts a hexadecimal number to a decimal number.
- HEX2OCTConvert hexadecimal text to octal with Gnumeric HEX2OCT, with reproducible native examples, padded fields, parser behavior …
- HEXREPInspect Gnumeric HEXREP debugging output with version-specific examples: old byte strings, newer formatting, binary rounding …
- HLOOKUPSearch horizontal tables in Gnumeric with HLOOKUP, exact and sorted-threshold modes, row offsets and the native index-return …
- HOURExtract Gnumeric hour-of-day values from numeric times and timestamps, distinguishing clock components from elapsed hours.
- HPFILTERSeparate a numeric time series into Hodrick-Prescott trend and cycle components in Gnumeric, with smoothing-parameter choices …
- HYPERLINKUnderstand the text-label behavior of HYPERLINK in the inspected Gnumeric implementation, including optional labels and the …
- HYPGEOMDISTCalculate exact-count or cumulative sampling probabilities without replacement, with feasible counts and an optional …
- HYPOTFind the hypotenuse with Gnumeric HYPOT using a 3-4-5 triangle example. Includes syntax, the result and practical tips.
I
- IFLearn the IF function in Gnumeric: Specifies a logical test to be performed.
- IFERRORProvide error fallbacks in Gnumeric with IFERROR while preserving successful zero, FALSE and empty-text results.
- IFNALearn the IFNA function in Gnumeric: Returns value if not a #N/A error, else alternative.
- IFSUse IFS in Gnumeric to return the first matching outcome from several ordered conditions. Two original examples, expected …
- IGAMMACalculate incomplete gamma values with Gnumeric IGAMMA. Choose lower or upper tails, regularization and real or imaginary …
- ILOGFind integer logarithms with Gnumeric ILOG. See supported bases, power-boundary examples and a tested negative-exponent …
- IMABSFind complex-number magnitude in Gnumeric with exact examples, modulus checks, and error guidance.
- IMAGINARYLearn the IMAGINARY function in Gnumeric: Returns the imaginary coefficient of a complex number.
- IMARCCOSFind the principal complex arccosine in Gnumeric, keeping both components and checking branch-sensitive results.
- IMARCCOSHCalculate the inverse complex hyperbolic cosine in Gnumeric, including modeled responses and principal branches.
- IMARCCOTUse IMARCCOT in Gnumeric to invert a complex cotangent response. Learn the syntax, branch limits and reproducible examples.
- IMARCCOTHUse IMARCCOTH in Gnumeric to invert a complex hyperbolic cotangent response. Learn the syntax, branch limits and reproducible …
- IMARCCSCUse IMARCCSC in Gnumeric to invert a complex cosecant response. Learn the syntax, branch limits and reproducible examples.
- IMARCCSCHUse IMARCCSCH in Gnumeric to invert a complex hyperbolic cosecant response. Learn the syntax, branch limits and reproducible …
- IMARCSECUse IMARCSEC in Gnumeric to invert a complex secant response. Learn the syntax, branch limits and reproducible examples.
- IMARCSECHUse IMARCSECH in Gnumeric to invert a complex hyperbolic secant response. Learn the syntax, branch limits and reproducible …
- IMARCSINFind the principal complex arcsine in Gnumeric, with reproducible inputs, forward checks and branch cuts.
- IMARCSINHCalculate the inverse complex hyperbolic sine in Gnumeric with branch-aware examples and reconstruction checks.
- IMARCTANCalculate the principal complex arctangent in Gnumeric and check imaginary-axis branch behavior.
- IMARCTANHCalculate the inverse complex hyperbolic tangent in Gnumeric with examples, reconstruction checks and pole cautions.
- IMARGUMENTLearn the IMARGUMENT function in Gnumeric: Returns the argument theta, an angle expressed in radians.
- IMCONJUGATELearn the IMCONJUGATE function in Gnumeric: Returns the complex conjugate of a complex number.
- IMCOSLearn the IMCOS function in Gnumeric: Returns the cosine of a complex number.
- IMCOSHLearn the IMCOSH function in Gnumeric: Returns the hyperbolic cosine of a complex number.
- IMCOTLearn the IMCOT function in Gnumeric: Returns the cotangent of a complex number.
- IMCOTHLearn about the IMCOTH function in Gnumeric, with usage notes and documentation links.
- IMCSCLearn the IMCSC function in Gnumeric: Returns the cosecant of a complex number.
- IMCSCHLearn the IMCSCH function in Gnumeric: Returns the hyperbolic cosecant of a complex number.
- IMDIVLearn the IMDIV function in Gnumeric: Returns the quotient of two complex numbers.
- IMEXPLearn the IMEXP function in Gnumeric: Returns the algebraic form of the exponential of a complex number.
- IMFACTCalculate complex and noninteger factorials in Gnumeric with Gamma identities, examples and pole warnings.
- IMGAMMACalculate complex Gamma values in Gnumeric with factorial relationships, recurrence checks and pole cautions.
- IMIGAMMAEvaluate lower or upper incomplete gamma functions in Gnumeric with IMIGAMMA, regularized or unregularized options and …
- IMINVFind a complex reciprocal in Gnumeric, convert impedance to admittance, and check near-zero risks.
- IMLNLearn the IMLN function in Gnumeric: Returns the natural logarithm of a complex number.
- IMLOG10Learn the IMLOG10 function in Gnumeric: Returns the base-10 logarithm of a complex number.
- IMLOG2Learn the IMLOG2 function in Gnumeric: Returns the base-2 logarithm of a complex number.
- IMNEGNegate both parts of a complex number in Gnumeric, with cancellation checks and sign examples.
- IMPOWERRaise a complex base to a complex exponent in Gnumeric, with integer-power examples and branch cautions.
- IMPRODUCTMultiply complex values in Gnumeric; learn reproducible examples, magnitude checks, and troubleshooting.
- IMREALLearn the IMREAL function in Gnumeric: Returns the real coefficient of a complex number.
- IMSECLearn the IMSEC function in Gnumeric: Returns the secant of a complex number.
- IMSECHLearn the IMSECH function in Gnumeric: Returns the hyperbolic secant of a complex number.
- IMSINLearn the IMSIN function in Gnumeric: Returns the sine of a complex number.
- IMSINHLearn the IMSINH function in Gnumeric: Returns the hyperbolic sine of a complex number.
- IMSQRTLearn the IMSQRT function in Gnumeric: Returns the square root of a complex number.
- IMSUBLearn the IMSUB function in Gnumeric: Returns the difference of two complex numbers.
- IMSUMAdd Gnumeric complex numbers with verified syntax, reproducible phasor examples, and input-error checks.
- IMTANLearn the IMTAN function in Gnumeric: Returns the tangent of a complex number.
- IMTANHLearn about the IMTANH function in Gnumeric, with usage notes and documentation links.
- INDEXLearn the INDEX function in Gnumeric: Returns a reference to a cell from a defined range.
- INDIRECTUse INDIRECT in Gnumeric. Turn an A1 or R1C1 address stored as text into a usable reference. Includes native 1.12.57 examples …
- INFOLearn the INFO function in Gnumeric: Returns information about the environment.
- INTLearn the INT function in Gnumeric: Rounds a number down to the nearest integer.
- INTERCEPTLearn the INTERCEPT function in Gnumeric: Returns the intercept of the linear regression line and the Y axis.
- INTERPOLATIONEstimate points or interval averages in Gnumeric with INTERPOLATION, linear, staircase and natural cubic spline methods.
- INTRATEUse Gnumeric INTRATE for an annualized simple return between settlement and redemption. Work through dates, amount signs and …
- INVSUMINVCompute the reciprocal sum with Gnumeric INVSUMINV, including parallel-value examples, harmonic-mean differences and native …
- IPMTCalculate the interest component of a regular loan payment in Gnumeric, with period-specific examples and source-verified …
- IRRLearn the IRR function in Gnumeric: Returns the actuarial rate of interest of an investment excluding costs or profits.
- ISBLANKLearn the ISBLANK function in Gnumeric: Returns TRUE if value refers to an empty cell.
- ISERRLearn the ISERR function in Gnumeric: Returns TRUE if the value is an error value not equal to #N/A.
- ISERRORLearn the ISERROR function in Gnumeric: Returns TRUE if the value is an error value.
- ISEVENTest parity in Gnumeric with ISEVEN, truncation of fractional values, negative inputs and integer-validation cautions.
- ISFORMULALearn the ISFORMULA function in Gnumeric: Returns TRUE if the cell is a formula cell.
- ISLOGICALLearn the ISLOGICAL function in Gnumeric: Returns TRUE if the value is a Boolean TRUE or FALSE.
- ISNALearn the ISNA function in Gnumeric: Returns TRUE if value equals #N/A.
- ISNONTEXTLearn the ISNONTEXT function in Gnumeric: Returns TRUE if the value is not text.
- ISNUMBERTest stored numeric types with Gnumeric ISNUMBER, distinguishing numeric text, booleans, blanks, errors and date serials.
- ISODDLearn the ISODD function in Gnumeric: Returns TRUE if the value truncated to integer is odd.
- ISOWEEKNUMLearn the ISOWEEKNUM function in Gnumeric: Calculates the ISO 8601 calendar week for the given date.
- ISOYEARLearn about the ISOYEAR function in Gnumeric, with usage notes and documentation links.
- ISPMTCalculate ISPMT interest in Gnumeric from its actual period convention. Compare the straight-line principal model, signed …
- ISPRIMECheck whether an integer is prime using Gnumeric ISPRIME. Includes formula syntax, a 17 example and input considerations.
- ISREFLearn the ISREF function in Gnumeric: Returns TRUE if value is a reference.
- ISTEXTCheck stored text types in Gnumeric with ISTEXT, numeric-looking strings, empty strings, blank cells and errors.
- ITHPRIMEFind indexed prime numbers with Gnumeric ITHPRIME, using one-based indices, native examples and explicit source limits for …
J
K
L
- LAMBERTWSolve w·exp(w)=x with Gnumeric LAMBERTW. Choose the principal or lower real branch and check domain endpoints and equation …
- LANDAUEvaluate the approximate standard Landau probability density in Gnumeric, with a checked value at zero and guidance on …
- LAPLACEUse Gnumeric LAPLACE to calculate a zero-centered Laplace density. See scale versus mean, shifted examples, interval …
- LARGELearn the LARGE function in Gnumeric: Returns the k-th largest value of a sample.
- LCMFind a common integer period with Gnumeric LCM, including truncation, ignored text and the zero-input error.
- LEFTExtract leading characters with Gnumeric LEFT, with an identifier example, optional character count and Unicode limitations.
- LEFTBUse LEFTB in Gnumeric to keep a UTF-8 byte-limited prefix. Learn whole-character truncation, optional byte counts, empty …
- LENCount text characters with Gnumeric LEN, including spaces and Unicode distinctions, without confusing length with storage …
- LENBCount UTF-8 bytes with LENB in Gnumeric. Compare characters and byte lengths, inspect combining accents, and reproduce …
- LEVERAGECalculate regression leverage in Gnumeric from a numeric design matrix, explicit intercept columns and independently checked …
- LINESTLearn the LINEST function in Gnumeric: Calculates parameters of the linear regression as an array.
- LINSOLVESolve square linear systems in Gnumeric with LINSOLVE, multiple right-hand sides, array dimensions and residual checks.
- LKSTESTRun a Lilliefors-adjusted normality test in Gnumeric with LKSTEST, fitted sample parameters and a three-row …
- LNLearn the LN function in Gnumeric: Calculates the natural logarithm of a number.
- LN1PLearn Gnumeric LN1P for log(1+x) with better precision near zero. Includes a simple example and troubleshooting tips.
- LOGCalculate logarithms in Gnumeric with LOG, optional base 10, valid base ranges and discrete-growth doubling time.
- LOG10Calculate base-ten logarithms in Gnumeric, interpret negative logarithms and diagnose zero or negative inputs.
- LOG2Calculate base-two logarithms in Gnumeric with native power-of-two examples, fractional inputs, roundtrip checks and explicit …
- LOGESTLearn the LOGEST function in Gnumeric: Calculates the parameters of the exponential regression curve as an array.
- LOGFITFit a shifted logarithmic curve with Gnumeric LOGFIT and read the sign, coefficients, horizontal shift and residual sum of …
- LOGINVFind lognormal percentiles in Gnumeric using explicit log-mean and log-SD, including zero-probability and inverse-check …
- LOGISTICCalculate Gnumeric logistic densities with LOGISTIC. Learn positive scale, shifted inputs, density versus sigmoid, native …
- LOGNORMDISTEvaluate Gnumeric lognormal cumulative probabilities with required parameters and its unusual nonnegative log-mean …
- LOGREGFit a logarithmic predictor model in Gnumeric with LOGREG, returning coefficients for y = m*ln(x) + b and optional regression …
- LOOKUPUse LOOKUP in Gnumeric to find an approximate match in a sorted key column and return a corresponding category. Two original …
- LOWERConvert text to lowercase in Gnumeric with LOWER, literal versus cell inputs, accented examples and explicit casing …
M
- MATCHLearn the MATCH function in Gnumeric: Defines a position in an array after comparing values.
- MAXFind the largest numeric value with Gnumeric MAX, using mixed-range examples and distinguishing a maximum value from its …
- MAXAFind the largest included value with MAXA in Gnumeric. See text-as-zero effects, logical values, empty ranges and …
- MAXIFSFind the largest matching numeric value with Gnumeric MAXIFS, including paired criteria, no-result errors and source-specific …
- MDETERMCalculate determinants in Gnumeric with MDETERM. Reproduce square-matrix examples, check row swaps and understand text, …
- MEDIANLearn the MEDIAN function in Gnumeric: Returns the median of a given sample.
- MIDExtract text by character position in Gnumeric with MID, one-based indexing, identifier examples and empty/error boundaries.
- MIDBExtract UTF-8 substrings with MIDB in Gnumeric. See its three required arguments, byte-boundary errors, partial-end trimming …
- MINFind the smallest numeric value in Gnumeric with MIN, ignored text/booleans, empty ranges and source-error handling.
- MINAUse MINA in Gnumeric with typed examples showing text, logical values and blanks, including zero minima and the newer …
- MINIFSFind the smallest matching numeric value with Gnumeric MINIFS, including paired criteria, no-result errors and …
- MINUTEExtract minute-of-hour components in Gnumeric with MINUTE, full timestamps and the distinction from elapsed minutes.
- MINVERSEFind and verify Gnumeric matrix inverses with MINVERSE, solve a small linear system and distinguish singularity, shape errors …
- MIRRCalculate a periodic cash-flow MIRR in Gnumeric. Separate financing and reinvestment rates, preserve zero periods, and audit …
- MMULTMultiply compatible Gnumeric matrices with MMULT, lay out array results, verify row-column products and keep input coercion …
- MODCalculate Gnumeric remainders with MOD, understand the divisor-sign convention and distinguish negative-input cases.
- MODELearn the MODE function in Gnumeric: Returns the most common value in a sample.
- MODE.MULTReturn every tied numeric mode in Gnumeric, enter the vertical array and distinguish repeated values, ignored text and …
- MONTHExtract month numbers from Gnumeric date serials, preserve calendar-year context and avoid confusing formatting with stored …
- MPSEUDOINVERSECompute numerical matrix pseudoinverses in Gnumeric with MPSEUDOINVERSE, rectangular array output, relative thresholds and …
- MROUNDLearn the MROUND function in Gnumeric: Returns a number rounded to a specified multiple.
- MULTINOMIALLearn the MULTINOMIAL function in Gnumeric: Returns the multinomial coefficient of a set of numbers.
- MUNITCreate identity matrices with Gnumeric MUNIT, enter the full array result and check fractional dimensions, size guards and …
N
- NLearn the N function in Gnumeric: Converts a value to a number.
- NALearn the NA function in Gnumeric: Not available. Returns the error value #N/A.
- NEGBINOMDISTNEGBINOMDIST gives the probability of exactly f failures before the t-th success.
- NETWORKDAYSUse NETWORKDAYS in Gnumeric. Count inclusive workdays, with holidays and Gnumeric’s optional Sunday-first weekend array. …
- NETWORKDAYS.INTLCount weekdays inclusively between two dates using a custom weekend schedule and optional holidays.
- NOMINALFind the nominal yearly interest rate equivalent to a known effective annual yield in Gnumeric, with checked examples.
- NORMDISTNORMDIST evaluates a normal-distribution density or cumulative probability.
- NORMINVNORMINV returns the normal-model value whose cumulative probability is p.
- NORMSDISTNORMSDIST returns the cumulative probability to the left of a z-score in the standard normal distribution.
- NORMSINVNORMSINV returns a standard-normal z-score from a cumulative probability.
- NOTNegate logical values in Gnumeric with NOT, numeric truth conversion, blank/text behavior and validation-rule examples.
- NOWUse NOW in Gnumeric to return a live date-and-time value, useful for elapsed-time monitoring. Two original examples, expected …
- NPERCalculate the number of payment periods in Gnumeric using a constant rate, fixed payments and consistent cash-flow signs.
- NPVDiscount equally spaced future cash flows in Gnumeric and add the initial investment separately to calculate project NPV.
- NT_DCount positive divisors in Gnumeric with NT_D, using factorization examples, perfect-square checks and exact native domain …
- NT_MUUse NT_MU in Gnumeric to calculate the Möbius function, identify square-free integers and check divisor sums, with native …
- NT_OMEGALearn Gnumeric NT_OMEGA for counting distinct prime factors, with square-free divisor examples, native results and …
- NT_PHICalculate Euler’s totient with Gnumeric NT_PHI, including coprime counts, prime-power formulas, multiplicative checks and …
- NT_PICount primes up to a limit with NT_PI in Gnumeric. See inclusive endpoints, interval counts, native examples and the …
- NT_RADICALUse NT_RADICAL in Gnumeric to multiply distinct prime factors. Includes square-free parts, native examples, practical …
- NT_SIGMASum positive divisors with Gnumeric NT_SIGMA, using perfect-number examples, factorization formulas and an explicit …
- NUMBERVALUEParse numeric text with NUMBERVALUE in Gnumeric. Compare the two-argument 1.12.57 syntax with newer separators, decimal …
O
- OCT2BINConvert octal text with Gnumeric OCT2BIN, including native binary examples, padding, signed-width hazards and a …
- OCT2DECDecode octal text with Gnumeric OCT2DEC, including numeric output, ten-digit signed values, native boundary tests and …
- OCT2HEXUse Gnumeric OCT2HEX for octal-to-hexadecimal text conversion, with padded examples, signed complements, exact roundtrips and …
- ODDRound to odd integers away from zero in Gnumeric with ODD, negative values, zero and practical integer-allocation checks.
- ODDFPRICEPrice an odd-first-coupon security in Gnumeric with ODDFPRICE, required day-count basis and independently reconciled cash …
- ODDFYIELDCalculate an odd-first-period yield in Gnumeric with explicit coupon dates, price-per-100 units, day-count basis and solver …
- ODDLPRICELearn the ODDLPRICE function in Gnumeric: Returns the price per $100 face value of a security with an odd last period.
- ODDLYIELDCalculate odd-last-period bond yield in Gnumeric with ODDLYIELD, required day-count basis, accrued interest and a …
- ODF.SUMPRODUCTUse Gnumeric ODF.SUMPRODUCT for matching-array products that include Boolean flags, with complete weighted totals, shape and …
- ODF.TIMEBuild Gnumeric time fractions without discarding full days, including negative and fractional components and elapsed-time …
- OFFCAPCalculate offered traffic in Erlangs with Gnumeric OFFCAP for a circuit count and Erlang-B blocking-probability target.
- OFFSETUse OFFSET in Gnumeric. Return a shifted reference, inheriting the starting range’s dimensions unless you override them. …
- OFFTRAFEstimate offered traffic from carried traffic and circuit capacity in Gnumeric OFFTRAF, with a one-circuit check and a …
- OPT_2_ASSET_CORRELATIONModel a two-asset conditional option in Gnumeric with OPT_2_ASSET_CORRELATION, asset roles, correlation and an independently …
- OPT_AMER_EXCHANGECalculate Gnumeric American asset-exchange option values with explicit quantities, carries, correlation and approximation …
- OPT_BAW_AMERCalculate the scoped Gnumeric OPT_BAW_AMER American-option approximation with verified argument order, time units and a …
- OPT_BINOMIALValue American or European calls and puts in Gnumeric with OPT_BINOMIAL, explicit carry, bounded tree steps and exercise …
- OPT_BJER_STENSUse Gnumeric Bjerksund-Stensland American-option approximation with explicit carry, year-fraction time and verified argument …
- OPT_BSCalculate a generalized European option value in Gnumeric OPT_BS, with explicit carry, annual units and tested call/put …
- OPT_BS_CARRYCOSTMeasure Gnumeric option sensitivity to cost of carry with OPT_BS_CARRYCOST, including derivative units and corrected …
- OPT_BS_DELTACalculate European-option spot sensitivity in Gnumeric with OPT_BS_DELTA, carry defaults, call/put signs and independent …
- OPT_BS_GAMMACalculate option gamma in Gnumeric with explicit cost of carry, sensitivity units, native examples and domain limits.
- OPT_BS_RHOInterpret Gnumeric OPT_BS_RHO interest-rate sensitivity, including the zero-carry branch, derivative assumptions and shock …
- OPT_BS_THETACalculate annual European-option time sensitivity in Gnumeric with OPT_BS_THETA, carry defaults and clearly scoped daily …
- OPT_BS_VEGACalculate Gnumeric option vega and convert its volatility sensitivity to a one-percentage-point change, with native examples.
- OPT_COMPLEX_CHOOSERValue a complex chooser option in Gnumeric with OPT_COMPLEX_CHOOSER, distinct strikes and maturities, native examples and a …
- OPT_EURO_EXCHANGEPrice a European asset-exchange option in Gnumeric using quantities, carry rates, correlation and a verified example.
- OPT_EXECUse Gnumeric OPT_EXEC to apply an executive-option forfeiture factor, with annual intensity, time-unit cautions and tested …
- OPT_FIXED_STRK_LKBKPrice fixed-strike lookback examples in Gnumeric with observed extrema, call/put branches and a disclosed nonzero-carry …
- OPT_FLOAT_STRK_LKBKUse Gnumeric OPT_FLOAT_STRK_LKBK with historical extrema, nonzero carry and a tested floating-strike lookback call example.
- OPT_FORWARD_STARTValue a forward-start option in Gnumeric with OPT_FORWARD_START, proportional future strike, consistent time units and …
- OPT_FRENCHUse Gnumeric OPT_FRENCH with the verified trading-time and calendar-time argument order, decimal rates and native examples.
- OPT_GARMAN_KOHLHAGENCalculate a European currency-option control with Gnumeric OPT_GARMAN_KOHLHAGEN, domestic/foreign rates and verified time …
- OPT_JUMP_DIFFPrice a jump-diffusion option in Gnumeric with OPT_JUMP_DIFF, variance allocation, Poisson truncation and bounded numerical …
- OPT_MILTERSEN_SCHWARTZUse Gnumeric Miltersen-Schwartz commodity-futures option pricing with fourteen explicit inputs, discount-factor units and …
- OPT_ON_OPTIONSUnderstand Gnumeric OPT_ON_OPTIONS strike order, compound-option flags, bounded test evidence and the observed numerical …
- OPT_SIMPLE_CHOOSERPrice a simple chooser option in Gnumeric with seven numeric arguments, choice and expiry times, and verified examples.
- OPT_SPREAD_APPROXCalculate a synthetic spread-option control with Gnumeric OPT_SPREAD_APPROX, including correlation, effective volatility and …
- OPT_TIME_SWITCHValue discrete time-switch payoffs in Gnumeric with OPT_TIME_SWITCH, payment scaling, observation dates and existing …
- ORLearn the OR function in Gnumeric: Returns TRUE if an argument is TRUE.
- OWENTCalculate Owen’s T in Gnumeric with OWENT. Learn the two arguments, normal-wedge interpretation, sign identities and …
P
- PARETOUse Gnumeric PARETO for Type I Pareto densities. See shape and minimum arguments, support, tail probabilities, native …
- PARTITIONSCount unordered integer partitions in Gnumeric with practical small-input examples and caveats.
- PEARSONLearn the PEARSON function in Gnumeric: Returns the Pearson product moment correlation coefficient.
- PENTECOSTSUNDAYUse Gnumeric PENTECOSTSUNDAY with worked Gregorian dates, the 49-day Easter difference and an explicit rolling-date boundary.
- PERCENTILELearn the PERCENTILE function in Gnumeric: Returns the alpha percentile of a sample.
- PERCENTILE.EXCUse Gnumeric PERCENTILE.EXC with its n+1 interpolation rule. See valid probability bounds, small samples, native examples and …
- PERCENTOFReturn the ratio of numeric subset totals to the complete numeric dataset.
- PERCENTRANKRank a value in Gnumeric with PERCENTRANK. Learn n−1 interpolation, duplicate handling, decimal truncation and native …
- PERCENTRANK.EXCUse Gnumeric PERCENTRANK.EXC for n+1 ranks. See ties, interpolation, truncated decimals, singleton behavior and native …
- PERIODOGRAMInspect Gnumeric PERIODOGRAM frequency-bin magnitudes, window options and zero padding without mistaking outputs for a …
- PERMUTUse PERMUT in Gnumeric for ordered selections without replacement. Includes native examples, the zero-case help discrepancy …
- PERMUTATIONACalculate ordered selections with repetition using PERMUTATIONA in Gnumeric, with native examples, zero conventions and …
- PFACTORFind a number’s smallest prime factor with Gnumeric PFACTOR, including prime inputs, fractional flooring and distinct VALUE …
- PHICalculate the standard-normal probability density at a z-score.
- PILearn the PI function in Gnumeric: Returns the value of the number Pi.
- PMTLearn the PMT function in Gnumeric: Regular payments. Returns the periodic payment of an annuity, based on regular payments …
- POCHHAMMERUse Gnumeric POCHHAMMER for rising factorials and gamma ratios, with fractional increments, product checks and explicit …
- POISSONPOISSON returns the probability of an event count under a Poisson model.
- POWERRaise values to powers in Gnumeric with POWER, its optional integer-root argument, negative-base domains and reproducible …
- PPMTCalculate the principal component of a regular loan payment in Gnumeric and reconcile it with total payments and interest.
- PRICELearn the PRICE function in Gnumeric: Returns the price per 100 currency units face value of a security that pays periodic …
- PRICEDISCUse Gnumeric PRICEDISC to calculate a discounted security price. Rebuild its linear discount equation and check rate, …
- PRICEMATCalculate Gnumeric’s per-100 maturity-interest price using its source formula, with accrued-interest, yield and day-count …
- PROBSum discrete probabilities with Gnumeric PROB. Check paired data, strict positive masses, interval bounds, sum tolerance and …
- PROBBLOCKCalculate Erlang-B call-blocking probability in Gnumeric with PROBBLOCK, offered traffic, integer circuit capacity and …
- PRODUCTMultiply numeric values in Gnumeric with PRODUCT, mixed-range type handling, empty-range behavior and compound growth …
- PROPERApply mechanical word capitalization with Gnumeric PROPER, including lowercasing remaining letters and limitations for names …
- PVLearn the PV function in Gnumeric: Present value. Calculates the present value of an investment.
Q
- QUARTILELearn the QUARTILE function in Gnumeric: Returns the quartile of a sample.
- QUARTILE.EXCFind exclusive quartiles in Gnumeric with QUARTILE.EXC. See n+1 interpolation, fractional selectors, small-sample limits and …
- QUOTIENTLearn the QUOTIENT function in Gnumeric: Returns the integer portion of a division.
R
- R.DBETAUse R.DBETA in Gnumeric for beta density and log-density. Check both shape parameters, endpoint behavior and verified …
- R.DBINOMFind exact binomial-count probabilities with Gnumeric R.DBINOM. Compare integer checks, zero-trial cases, direct log mass and …
- R.DCAUCHYEvaluate Cauchy density with Gnumeric R.DCAUCHY. Use required location and scale, checked log-density examples and clear …
- R.DCHISQCalculate chi-square density and log-density with Gnumeric R.DCHISQ. See fractional degrees of freedom, the zero boundary and …
- R.DEXPUse Gnumeric R.DEXP for exponential density and log density. Check its scale parameter, negative support, underflow and …
- R.DFCalculate F-distribution density with Gnumeric R.DF. See degree ordering, the zero-cutoff branches, direct log density and …
- R.DGAMMAUse Gnumeric R.DGAMMA for gamma density and log-density. Specify shape and scale correctly and check zero-cutoff and …
- R.DGEOMCalculate geometric probability masses in Gnumeric R.DGEOM. Count failures before the first success, use log masses and …
- R.DGUMBELEvaluate Gumbel density with Gnumeric R.DGUMBEL. Interpret location and scale, reproduce standardization and use log density …
- R.DHYPERCalculate hypergeometric masses in Gnumeric R.DHYPER. Separate both population counts, sample without replacement and check …
- R.DLNORMCalculate lognormal density with Gnumeric R.DLNORM. Interpret log-scale parameters, verify the normal-density transformation …
- R.DNBINOMCalculate negative-binomial masses with Gnumeric R.DNBINOM. Count failures before successes, use noninteger shapes and verify …
- R.DNORMCalculate normal density and log density with Gnumeric R.DNORM, using native examples, required mean and spread, and explicit …
- R.DPOISCalculate Poisson event-count probabilities with Gnumeric R.DPOIS. Check zero mean, fractional-count handling, natural-log …
- R.DRAYLEIGHEvaluate Rayleigh density with Gnumeric R.DRAYLEIGH. Verify the scale convention, Weibull relationship, zero boundary and …
- R.DSNORMEvaluate skew-normal density with Gnumeric R.DSNORM. Understand shape/location/scale and the verified nonzero-location …
- R.DSTCalculate skew-t density with Gnumeric R.DST. Check degrees of freedom, signed skew, log density and the distinction from the …
- R.DTCalculate Student t density and log-density with Gnumeric R.DT. Check fractional degrees of freedom, symmetry, large …
- R.DWEIBULLCalculate Weibull density with Gnumeric R.DWEIBULL. Distinguish shape and scale, reconcile zero-boundary cases and inspect a …
- R.PBETACalculate beta cumulative and upper-tail probabilities with Gnumeric R.PBETA. See log probabilities and the tested …
- R.PBINOMCalculate binomial cumulative or upper-tail probabilities with Gnumeric R.PBINOM. Check fractional cutoffs, trial validation, …
- R.PCAUCHYCalculate Cauchy lower, upper and log probabilities with Gnumeric R.PCAUCHY, including location-scale examples and a direct …
- R.PCHISQUse Gnumeric R.PCHISQ for lower or upper chi-square probabilities. Check log output, real-valued degrees of freedom and zero …
- R.PEXPCalculate exponential tail and log probabilities with Gnumeric R.PEXP, using scale rather than rate and checked support and …
- R.PFEvaluate F-distribution probabilities in Gnumeric with R.PF. Choose the correct tail and degree order, use natural logs, and …
- R.PGAMMACalculate gamma cumulative and upper-tail probabilities with Gnumeric R.PGAMMA. Use shape and scale, log output and explicit …
- R.PGEOMCalculate geometric cumulative and survival probabilities with Gnumeric R.PGEOM. Check failure-count cutoffs, strict upper …
- R.PGUMBELCalculate Gumbel lower and upper probabilities with Gnumeric R.PGUMBEL. Verify location/scale meaning, log tails and an …
- R.PHYPERCalculate hypergeometric cumulative probabilities in Gnumeric R.PHYPER. Check sampling support, strict upper tails and the …
- R.PLNORMUse Gnumeric R.PLNORM for lognormal probabilities. Verify lower, upper and log tails and handle the documented …
- R.PNBINOMEvaluate negative-binomial cumulative probabilities with Gnumeric R.PNBINOM. Check failures before successes, fractional …
- R.PNORMFind normal lower and upper tails with Gnumeric R.PNORM. Use direct tail flags, log probabilities and native examples without …
- R.PPOISUse Gnumeric R.PPOIS for cumulative and upper-tail Poisson probabilities. Understand inclusive thresholds, fractional …
- R.PRAYLEIGHCalculate Rayleigh probabilities with Gnumeric R.PRAYLEIGH. Verify scale, survival and log-tail inputs, support boundaries …
- R.PSNORMCalculate skew-normal probabilities with Gnumeric R.PSNORM. Check tail/log modes and the verified large-shape complement …
- R.PSTUse Gnumeric R.PST with explicit version limits: a fixed-in-source log-probability defect, fractional-df restrictions and the …
- R.PTUse Gnumeric R.PT for Student t cumulative and upper-tail probabilities. Check signed cutoffs, fractional degrees of freedom, …
- R.PTUKEYUse Gnumeric R.PTUKEY for Studentized-range probabilities, with upper tails, multiple ranges, native examples and the …
- R.PWEIBULLCalculate Weibull probabilities with Gnumeric R.PWEIBULL. Verify survival and log tails, shape/scale units, zero support …
- R.QBETAFind beta quantiles with Gnumeric R.QBETA. Compare lower and upper tails, log-probability input, valid endpoints and …
- R.QBINOMFind binomial count thresholds with Gnumeric R.QBINOM. Understand discrete inverse jumps, upper-tail conversion, strict …
- R.QCAUCHYFind Cauchy quantiles with Gnumeric R.QCAUCHY, using explicit lower and upper tails, log probabilities, location-scale …
- R.QCHISQFind chi-square cutoffs with Gnumeric R.QCHISQ. Select lower or upper probability, use log input and distinguish finite from …
- R.QEXPInvert exponential probabilities with Gnumeric R.QEXP, including scale, direct upper tails, log inputs and checked finite and …
- R.QFUse Gnumeric R.QF for lower or upper F quantiles. Check degree order, reciprocal critical values, log probability and finite …
- R.QGAMMAFind gamma quantiles with Gnumeric R.QGAMMA. Use lower or upper tails and log probability, and guard the tested zero or …
- R.QGEOMFind geometric waiting-count quantiles with Gnumeric R.QGEOM. Translate failures to attempts, check tail conventions and …
- R.QGUMBELFind Gumbel cutoffs with Gnumeric R.QGUMBEL. Reconstruct lower, upper and log probabilities, distinguish the location from …
- R.QHYPERFind hypergeometric count thresholds with Gnumeric R.QHYPER. Validate integer populations, interpret tail probabilities and …
- R.QLNORMFind lognormal cutoffs with Gnumeric R.QLNORM. Check tail and log-probability inputs, normal-scale parameters, endpoint …
- R.QNBINOMFind negative-binomial failure-count quantiles with Gnumeric R.QNBINOM. Check tail conventions, generalized shapes and …
- R.QNORMInvert normal probabilities with Gnumeric R.QNORM. See lower-tail, upper-tail and log-probability inputs, required parameters …
- R.QPOISFind Poisson count thresholds with Gnumeric R.QPOIS. Use lower or upper tails, log probabilities, discrete jump checks and …
- R.QRAYLEIGHFind Rayleigh percentiles with Gnumeric R.QRAYLEIGH. Check scale, upper-tail and log probabilities, finite endpoints and a …
- R.QSNORMFind skew-normal cutoffs with Gnumeric R.QSNORM. Verify shape/location/scale, log probabilities and inverse checks while …
- R.QSTFind skew-t cutoffs with Gnumeric R.QST while checking its tested log-input failure, fractional-df limitation and large-df …
- R.QTFind signed Student t critical values with Gnumeric R.QT. Use lower or upper probability, fractional degrees of freedom and …
- R.QTUKEYFind Gnumeric Studentized-range cutoffs with R.QTUKEY. See native tail examples, Tukey scaling, invalid-parameter traps and …
- R.QWEIBULLFind Weibull percentiles with Gnumeric R.QWEIBULL. Verify scale and shape, upper/log probability modes, finite endpoint rules …
- RADIANSLearn the RADIANS function in Gnumeric: Converts degrees to radians.
- RANDGenerate changing uniform draws with Gnumeric RAND, using its zero-argument syntax and distinguishing samples from …
- RANDBETARANDBETA(a,b) requires two positive shape parameters. It forms a ratio of gamma variates; b is not a scale or an upper limit.
- RANDCAUCHYRANDCAUCHY(a) uses a nonnegative scale and zero location. For positive scale the ideal Cauchy distribution has a median, but …
- RANDCHISQRANDCHISQ(df) accepts nonnegative degrees of freedom, including nonintegers. For positive df, the ideal chi-square mean is df …
- RANDDISCRETEDraw a numeric outcome from a finite distribution in Gnumeric using equal or explicit probabilities, with deterministic …
- RANDEXPRANDEXP(b) uses the exponential scale, equal to the ideal mean, rather than a rate. Its source does not reject a zero unit …
- RANDEXPPOWGenerate symmetric exponential-power variates in Gnumeric with RANDEXPPOW, scale/exponent roles, normal and Laplace cases and …
- RANDFDISTRANDFDIST(df 1,df 2) uses positive numerator and denominator degrees of freedom. The order matters: the ideal mean depends on …
- RANDGAMMARANDGAMMA(a,b) uses shape first, scale second. The worksheet wrapper requires shape>0 even though the shared gamma helper …
- RANDGEOMRANDGEOM(p) counts failures before the first success, so its ideal support starts at 0. The helper requires 0<p≤1, even …
- RANDGUMBELGenerate Gnumeric extreme-value variates with RANDGUMBEL, using the implemented type 1 and type 2 parameterizations rather …
- RANDHYPERGRANDHYPERG(n 1,n 2,t) counts type 1 objects in a sample drawn without replacement. Its three numeric arguments are floored …
- RANDLANDAUGenerate a random variate from Gnumeric's standard Landau distribution, with no-argument syntax, heavy-tail cautions, and …
- RANDLAPLACERANDLAPLACE(a) generates a zero-centered, two-sided exponential variate. Its parameter is a scale, with ideal standard …
- RANDLEVYGenerate alpha-stable variates in Gnumeric with RANDLEVY, stability/skewness parameters, normal and Cauchy cases and …
- RANDLOGRANDLOG(p) generates a positive integer from the logarithmic-series distribution. It is not a logarithm function, and the …
- RANDLOGISTICRANDLOGISTIC(a) generates a zero-centered logistic variate. Its argument is a scale; ideal standard deviation is …
- RANDLOGNORMRANDLOGNORM(zeta,sigma) exponentiates a normal variate. Its arguments describe the natural logarithm of the output, so zeta …
- RANDNEGBINOMSimulate failures before a target number of successes with Gnumeric RANDNEGBINOM, clarifying its help-text parameter …
- RANDNORMGenerate Gnumeric normal-model draws with an explicit mean and standard deviation, using deterministic scale controls and …
- RANDNORMTAILDraw from the upper tail of a zero-mean normal distribution in Gnumeric using a lower cutoff and standard deviation, with …
- RANDPARETORANDPARETO(a,b) uses positive shape a and nonnegative minimum/scale b. For positive b, the ideal mean exists only when a>1 …
- RANDPOISSONRANDPOISSON(lambda) generates a nonnegative integer count. Lambda is the expected count for the chosen interval, may be …
- RANDRAYLEIGHRANDRAYLEIGH(sigma) uses a nonnegative scale. With scale 3, the ideal mean is about 3.75994, not 3; its positive-scale output …
- RANDRAYLEIGHTAILRANDRAYLEIGHTAIL(a,sigma) generates a Rayleigh tail variate using a lower bound and scale. For the ordinary interpretation …
- RANDSNORMGenerate skew-normal variates in Gnumeric with RANDSNORM, optional shape/location/scale parameters and the distinction …
- RANDSTDISTGenerate skew-t draws with Gnumeric RANDSTDIST, supplying both required arguments and distinguishing shape from output …
- RANDTDISTRANDTDIST(df) generates a Student t variate with positive degrees of freedom. Fractional df is allowed; the ideal variance is …
- RANDUNIFORMUse Gnumeric RANDUNIFORM for bounded simulation, distinguish variable draws from deterministic mapping controls and account …
- RANDWEIBULLRANDWEIBULL(a,b) uses scale first, shape second. For scale 100 and shape 2, the ideal median is about83.2555; an individual …
- RANKLearn the RANK function in Gnumeric: Returns the ranking of a value in a sample.
- RANK.AVGLearn the RANK.AVG function in Gnumeric: Returns the ranking of a value in a sample; if more than one value has the same …
- RATELearn the RATE function in Gnumeric: Calculates the constant interest rate of an investment with regular payments.
- RAYLEIGHCalculate Gnumeric Rayleigh densities with RAYLEIGH. See positive scale, magnitude models, tail probabilities, native …
- RAYLEIGHTAILUse Gnumeric RAYLEIGHTAIL for a threshold-conditioned Rayleigh density, with normalization, native examples and the unchecked …
- RECEIVEDFind Gnumeric RECEIVED’s maturity amount using its discount-denominator formula. Check zero and negative denominators, dates …
- REDUCEPIReduce angles accurately with Gnumeric REDUCEPI. Learn scale and quotient bits, reconstruct a worked angle and understand …
- REGEXEXTRACTExtract matching text and optionally return all matches or capturing groups. Learn exact arguments, reproducible examples and …
- REGEXREPLACEReplace regex matches, choose occurrences, and reuse captured groups. Learn exact arguments, reproducible examples and common …
- REGEXTESTCheck whether text contains a regular-expression match. Learn exact arguments, reproducible examples and common errors.
- REPLACEReplace text by character position with Gnumeric REPLACE, using an identifier example and distinguishing position-based edits …
- REPLACEBReplace UTF-8 byte spans with REPLACEB in Gnumeric. Learn whole-character boundaries, insertions, and the changed overflow …
- REPTRepeat text in Gnumeric with REPT, repetition counts, empty results and a simple worksheet progress-bar example.
- RIGHTLearn the RIGHT function in Gnumeric: Returns the last character or characters of a text.
- RIGHTBUse RIGHTB in Gnumeric for a UTF-8 byte-limited suffix. See character-boundary trimming, optional counts, multibyte examples …
- ROMANFormat integers as Roman numerals in Gnumeric with ROMAN, classical and simplified forms, zero and range checks.
- ROUNDLearn the ROUND function in Gnumeric: Rounds a number to a predefined accuracy.
- ROUNDDOWNRound toward zero with Gnumeric ROUNDDOWN, including negative numbers, decimal-place arguments and tens or hundreds rounding.
- ROUNDUPRound away from zero in Gnumeric with ROUNDUP, optional decimal digits, negative positions and positive/negative examples.
- ROWReturn worksheet row numbers with Gnumeric ROW, including omitted references, absolute references and vertical range vectors.
- ROWSLearn the ROWS function in Gnumeric: Returns the number of rows in a reference or array.
- RRIUse RRI in Gnumeric to calculate the constant per-period growth rate between two values. Check endpoint signs, zero guards …
- RSQLearn the RSQ function in Gnumeric: Returns the square of the Pearson product moment correlation coefficient.
S
- SEARCHLocate text in Gnumeric with SEARCH, case-insensitive positions, optional start offsets and identifier extraction examples.
- SEARCHBSearch UTF-8 byte positions with SEARCHB in Gnumeric. Use case-insensitive wildcard patterns, escaped symbols and carefully …
- SECLearn the SEC function in Gnumeric: Return the secant of an angle. SEC(x)=1/COS(x).
- SECHLearn the SECH function in Gnumeric: Return the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x).
- SECONDExtract seconds-of-minute in Gnumeric with SECOND, full timestamps, normalized time inputs and elapsed-duration distinctions.
- SERIESSUMEvaluate power series with Gnumeric SERIESSUM. See coefficient ordering, fractional exponents, blank-cell compaction and the …
- SFTESTRun the Shapiro-Francia normality test in Gnumeric and interpret its approximate p-value, test statistic, and usable …
- SHEETSCount sheets in a Gnumeric workbook or reference span with SHEETS, including the no-argument workbook count and the …
- SIGNLearn the SIGN function in Gnumeric: Returns the algebraic sign of a number.
- SIMTABLEDefine scenario values in Gnumeric with SIMTABLE, inactive first-value behavior, simulation rounds and aligned decision …
- SINCalculate sine in Gnumeric using radians, convert degree inputs and recognize floating-point residue at mathematical zeros.
- SINHLearn the SINH function in Gnumeric: Returns the hyperbolic sine of a number.
- SINPICalculate the sine of a multiple of pi in Gnumeric with SINPI. See syntax, a numeric example, expected results and common …
- SKEWUse Gnumeric SKEW for adjusted sample skewness. Follow typed-data examples, native checks, small-sample errors and …
- SKEWPLearn Gnumeric SKEWP for population skewness, including checked datasets, the sample adjustment, empty-set errors and current …
- SLNCalculate straight-line depreciation with SLN in Gnumeric. Build an asset schedule, keep period units consistent, and …
- SLOPELearn the SLOPE function in Gnumeric: Returns the slope of the linear regression line.
- SMALLFind ranked low values in Gnumeric with SMALL, duplicate ranks, ignored text/booleans and error propagation.
- SNORM.DIST.RANGECalculate standard-normal interval mass in Gnumeric, preserve reversed-limit signs and compare central, narrow and tail …
- SORTSort Gnumeric numeric values into a vertical list, with descending default order, ignored types, duplicate retention and safe …
- SQRTCalculate the principal nonnegative square root with Gnumeric SQRT, using a reproducible length example and negative-domain …
- SQRTPILearn the SQRTPI function in Gnumeric: Returns the square root of a number which has been multiplied by pi.
- SSMEDIANEstimate a grouped-data median with Gnumeric SSMEDIAN, specify midpoint observations and interval width, and verify …
- STANDARDIZELearn the STANDARDIZE function in Gnumeric: Converts a random variable to a normalized value.
- STDEVLearn the STDEV function in Gnumeric: Calculates the standard deviation based on a sample.
- STDEVALearn the STDEVA function in Gnumeric: Returns the standard deviation based on a sample. Text is evaluated as zero.
- STDEVPLearn the STDEVP function in Gnumeric: Calculates the standard deviation based on the entire population.
- STDEVPALearn the STDEVPA function in Gnumeric: Returns the standard deviation based on the entire population. Text is evaluated as …
- STEYXLearn the STEYX function in Gnumeric: Returns the standard error of the linear regression.
- SUBSTITUTELearn the SUBSTITUTE function in Gnumeric: Substitutes new text for old text in a string.
- SUBTOTALUse SUBTOTAL in Gnumeric. Summarize a range with a numbered calculation and avoid counting nested SUBTOTAL cells twice. …
- SUMSum numeric inputs with Gnumeric SUM, inspecting mixed ranges and distinguishing ignored text or logical cells from valid …
- SUMAAdd numbers and logical values with Gnumeric SUMA. See TRUE/FALSE handling, ignored text values, range examples and the …
- SUMIFLearn the SUMIF function in Gnumeric: Totals the arguments that meet the condition.
- SUMIFSSum aligned matching amounts with Gnumeric SUMIFS, including sum-range-first syntax, multiple criteria and no-match results.
- SUMPRODUCTLearn the SUMPRODUCT function in Gnumeric: (Inner products) Returns the sum of the products of array arguments.
- SUMSQSum squared numeric inputs with Gnumeric SUMSQ, using residual examples and distinguishing the sum of squares from a squared …
- SUMX2MY2Learn the SUMX2MY2 function in Gnumeric: Returns the sum of the difference of squares of two arrays.
- SUMX2PY2Learn the SUMX2PY2 function in Gnumeric: Returns the total of the square sum of two arrays.
- SUMXMY2Learn the SUMXMY2 function in Gnumeric: Returns the sum of squares of differences of two arrays.
- SWITCHUse SWITCH in Gnumeric to map a code to a label without a chain of nested IF formulas. Two original examples, expected …
- SYDUse SYD in Gnumeric for sum-of-years depreciation. Reproduce a five-period asset schedule and check period bounds that the …
T
- TLearn the T function in Gnumeric: Returns a value if it is text, otherwise an empty value.
- TANLearn the TAN function in Gnumeric: Returns the tangent of a number.
- TANHUse Gnumeric TANH for bounded nonlinear transformations, sign symmetry and a practical zero-to-100 score mapping.
- TANPICalculate tangent at multiples of pi with the Gnumeric TANPI function. Learn the syntax and try a worked example.
- TBILLEQConvert a discount rate with TBILLEQ in Gnumeric. Audit its 365/360 formula, distinguish companion bill yields and understand …
- TBILLPRICECalculate Gnumeric TBILLPRICE per 100 face value. Reproduce a 180-day discount bill, distinguish price from yield, and check …
- TBILLYIELDCalculate TBILLYIELD in Gnumeric from price and dates. Reconcile a discount bill, use the fixed 360-day annualization, and …
- TDISTCalculate one-tail and two-tail Student t probabilities in Gnumeric, with negative-statistic handling and fractional degrees …
- TEXTUse TEXT in Gnumeric to produce a formatted text label from a number without changing the original numeric cell. Two original …
- TEXTAFTERTEXTAFTER in Gnumeric: delimiter extraction, occurrence and case options, with the 1.12.62 numeric-fallback limitation …
- TEXTBEFORETEXTBEFORE in Gnumeric: delimiter extraction, occurrence and case options, with the 1.12.62 numeric-fallback limitation …
- TEXTJOINUse Gnumeric TEXTJOIN with a delimiter and explicit blank policy, including empty formulas, whitespace, errors and stable …
- TEXTSPLITSplit text into Gnumeric arrays by row and column delimiters with padding and empty handling.
- TIMEConstruct Gnumeric time-of-day serials from components, understand rollover and fractional inputs, and check negative-input …
- TIMEVALUELearn the TIMEVALUE function in Gnumeric: Returns a sequential number for a text shown in a possible time entry format.
- TINVFind Gnumeric two-tail Student t critical values, with confidence-interval examples, fractional degrees of freedom and …
- TODAYUse TODAY in Gnumeric to insert the current calendar date without typing it again. Two original examples, expected results, …
- TRANSPOSETranspose rows and columns in Gnumeric by selecting the exact output range and committing an array formula with …
- TRENDLearn the TREND function in Gnumeric: Calculates points along a regression line.
- TRIMNormalize ordinary spaces with Gnumeric TRIM, preserving original text and recognizing that not every whitespace character is …
- TRIMMEANCalculate a trimmed mean in Gnumeric with TRIMMEAN. Learn even-count trimming, small-sample steps, reproducible examples and …
- TRUELearn the TRUE function in Gnumeric: Returns the logical value TRUE.
- TRUNCLearn the TRUNC function in Gnumeric: Truncates the decimal places of a number.
- TTESTCompare means in Gnumeric with TTEST, paired, pooled or Welch designs, required tail/type choices and independently checked …
- TYPELearn the TYPE function in Gnumeric: Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 16 = error …
U
V
- VALUELearn the VALUE function in Gnumeric: Converts text to a number.
- VARLearn the VAR function in Gnumeric: Calculates the variance based on a sample.
- VARALearn the VARA function in Gnumeric: Returns the variance based on a sample. Text is evaluated as zero.
- VARPLearn the VARP function in Gnumeric: Calculates variance based on the entire population.
- VARPALearn the VARPA function in Gnumeric: Returns the variance based on the entire population. Text is evaluated as zero.
- VDBCalculate interval depreciation with Gnumeric VDB, including declining balance, the optional straight-line switch and salvage …
- VLOOKUPSearch vertical tables in Gnumeric with VLOOKUP, exact keys, ascending thresholds, relative column offsets and the optional …
W
- WEEKDAYNumber weekdays in Gnumeric with explicit Sunday- or Monday-based methods, rotated week starts and verified invalid-method …
- WEEKNUMUse WEEKNUM in Gnumeric. Choose the week-numbering method explicitly, especially for dates around New Year. Includes native …
- WEIBULLWEIBULL evaluates a Weibull lifetime distribution.
- WORKDAYLearn the WORKDAY function in Gnumeric: Returns the serial number of the date before or after a specified number of workdays.
- WORKDAY.INTLMove a date forward or backward by working days using configurable weekends and optional holidays.
X
- XIRRLearn the XIRR function in Gnumeric: Returns the internal rate of return for a non-periodic schedule of payments.
- XLOOKUPLook up a value in one Gnumeric column or row and return the corresponding item from another range.
- XMATCHFind a 1-based position in a Gnumeric range using exact, approximate, wildcard or reverse lookup.
- XNPVLearn the XNPV function in Gnumeric: Returns the net present value for a non-periodic schedule of payments.
- XORLearn the XOR function in Gnumeric: Returns TRUE if an odd number of arguments evaluates to TRUE.
Y
- YEARExtract calendar years in Gnumeric with YEAR, leap dates, year-end timestamps and reliable year-based grouping.
- YEARFRACLearn the YEARFRAC function in Gnumeric: Returns the number of years (including fractional part) between two dates.
- YIELDLearn the YIELD function in Gnumeric: Returns the yield on a security that pays periodic interest.
- YIELDDISCCalculate Gnumeric YIELDDISC’s annualized purchase-price return for a discounted security. Compare discount quotes, year …
- YIELDMATCalculate the annual yield of interest-at-maturity securities in Gnumeric with YIELDMAT, dated cash flows, optional day-count …
Z
No functions match your filters. Try a different name or category.