Gnumeric — Function Directory
Browse 538 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Gnumeric.
538 functions
Browse by category
A
- ABSLearn the ABS function in Gnumeric: Absolute value of a number.
- ACCRINTMCalculate Gnumeric accrued interest paid at maturity, with optional par, basis-specific day counts and source-checked …
- ACOSLearn the ACOS function in Gnumeric: Returns the arccosine of a number.
- 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.
- AGMCalculate the arithmetic-geometric mean with Gnumeric AGM. Includes syntax, a worked example and numerical guidance.
- ANDLearn the AND function in Gnumeric: Returns TRUE if all arguments are TRUE.
- ARABICLearn the ARABIC function in Gnumeric: Calculates the value of a Roman numeral.
- ARRAYConstruct a vertical Gnumeric ARRAY from ordered arguments and ranges, preserve types, and verify nested lists 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 …
- ASINLearn the ASIN function in Gnumeric: Returns the arcsine of a number.
- ASINHLearn the ASINH function in Gnumeric: Returns the inverse hyperbolic sine of a number.
- ATANLearn the ATAN function in Gnumeric: Returns the arctangent of a number.
- ATAN2Learn the ATAN2 function in Gnumeric: Returns the arctangent for the specified coordinates.
- ATANHLearn the ATANH function in Gnumeric: Returns the inverse hyperbolic tangent of a number.
- 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 …
- AVERAGEIFLearn the AVERAGEIF function in Gnumeric: Averages the arguments that meet the conditions.
- 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)|.
- BIN2DECLearn the BIN2DEC function in Gnumeric: Converts a binary number to a decimal number.
- 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.
- CEILINGLearn the CEILING function in Gnumeric: Rounds a number up to the nearest multiple of significance.
- 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.
- CHOOSELearn the CHOOSE function in Gnumeric: Selects a value from a list of up to 30 value arguments.
- CLEANLearn the CLEAN function in Gnumeric: Removes character codes below32 from text in Gnumeric 1.12.62.
- CODELearn the CODE function in Gnumeric: Returns a numeric code for the first character in a text string.
- COLUMNLearn the COLUMN function in Gnumeric: Returns the internal column number of a reference.
- 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.
- COMBINLearn the COMBIN function in Gnumeric: Calculates the number of combinations for elements without repetition.
- COMBINALearn the COMBINA function in Gnumeric: Calculates the number of combinations of elements including repetition.
- 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 …
- CORRELLearn the CORREL function in Gnumeric: Returns the correlation coefficient.
- COSLearn the COS function in Gnumeric: Returns the cosine of a number.
- COSHLearn the COSH function in Gnumeric: Returns the hyperbolic cosine of a number.
- 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 …
- COUNTLearn the COUNT function in Gnumeric: Counts how many numbers are in the list of arguments.
- COUNTALearn the COUNTA function in Gnumeric: Counts how many values are in the list of arguments.
- COUNTBLANKLearn the COUNTBLANK function in Gnumeric: Counts the blank cells in a specified range.
- COUNTIFLearn the COUNTIF function in Gnumeric: Counts the arguments which meet the set conditions.
- COUNTIFSLearn the COUNTIFS function in Gnumeric: Counts the cells that meet multiple criteria in multiple ranges.
- 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.
- 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.
D
- DATELearn the DATE function in Gnumeric: Provides an internal number for the date given.
- 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 …
- DAYLearn the DAY function in Gnumeric: Returns the sequential date of the month as an integer (1-31) in relation to the date …
- 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 …
- DEC2BINLearn the DEC2BIN function in Gnumeric: Converts a decimal number to a binary number.
- 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 …
- 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, …
- 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 …
- 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 …
- 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.
- EXPLearn the EXP function in Gnumeric: Calculates the exponent for basis e.
- 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 …
F
- FACTLearn the FACT function in Gnumeric: Calculates the factorial of a number.
- 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.
- FLIPReverse rows or columns with Gnumeric FLIP while preserving matrix dimensions and values; verify direction, changed inputs …
- FLOORLearn the FLOOR function in Gnumeric: Rounds number down to the nearest multiple of significance.
- 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.
- FREQUENCYBuild Gnumeric frequency arrays with sorted upper cutoffs, an overflow bucket and explicit treatment of duplicate bins, …
- 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.
- GCDLearn the GCD function in Gnumeric: Greatest Common Divisor.
- 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 the GESTEP function in Gnumeric: Tests whether a number is greater than a threshold value.
- 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 …
H
- HARMEANLearn the HARMEAN function in Gnumeric: Returns the harmonic mean of a sample.
- HDATE_JULIANCalculate a Julian day number from explicit Gregorian components in Gnumeric and distinguish optional current-date defaults …
- 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 …
- HLOOKUPLearn the HLOOKUP function in Gnumeric: Horizontal search and reference to the cells located below.
- HOURLearn the HOUR function in Gnumeric: Determines the sequential number of the hour of the day (0-23) for the time value.
- 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.
- IFERRORLearn the IFERROR function in Gnumeric: Returns value if not an error value, else alternative.
- 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.
- 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 to turn a text address into a live cell reference. Two original examples, expected results, cautions …
- 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.
- 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.
- ISEVENLearn the ISEVEN function in Gnumeric: Returns TRUE if the value truncated to integer is even.
- 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.
- ISNUMBERLearn the ISNUMBER function in Gnumeric: Returns TRUE if value is a number.
- 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.
- ISTEXTLearn the ISTEXT function in Gnumeric: Returns TRUE if value is text.
- ITHPRIMEFind indexed prime numbers with Gnumeric ITHPRIME, using one-based indices, native examples and explicit source limits for …
K
L
- LAMBERTWSolve w·exp(w)=x with Gnumeric LAMBERTW. Choose the principal or lower real branch and check domain endpoints and equation …
- 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.
- LCMLearn the LCM function in Gnumeric: Lowest common multiple.
- LEFTLearn the LEFT function in Gnumeric: Returns the first character or characters of a text.
- LEFTBUse LEFTB in Gnumeric to keep a UTF-8 byte-limited prefix. Learn whole-character truncation, optional byte counts, empty …
- LENLearn the LEN function in Gnumeric: Calculates length of a text string.
- LENBCount UTF-8 bytes with LENB in Gnumeric. Compare characters and byte lengths, inspect combining accents, and reproduce …
- 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.
- LOGLearn the LOG function in Gnumeric: Calculates the logarithm to any specified base.
- LOG10Learn the LOG10 function in Gnumeric: Calculates the base-10 logarithm of a number.
- LOG2Calculate base-two logarithms in Gnumeric with native power-of-two examples, fractional inputs, roundtrip checks and explicit …
- 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 …
- LOOKUPUse LOOKUP in Gnumeric to find an approximate match in a sorted key column and return a corresponding category. Two original …
- LOWERLearn the LOWER function in Gnumeric: Converts text to lowercase.
M
- MATCHLearn the MATCH function in Gnumeric: Defines a position in an array after comparing values.
- MAXLearn the MAX function in Gnumeric: Returns the maximum value in a list of arguments.
- 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.
- MIDLearn the MID function in Gnumeric: Returns a partial text string of a text.
- MIDBExtract UTF-8 substrings with MIDB in Gnumeric. See its three required arguments, byte-boundary errors, partial-end trimming …
- MINLearn the MIN function in Gnumeric: Returns the minimum value in a list of arguments.
- 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 …
- MINUTELearn the MINUTE function in Gnumeric: Determines the sequential number for the minute of the hour (0-59) for the time value.
- 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 …
- MODLearn the MOD function in Gnumeric: Calculates the remainder of a division.
- 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 …
- MONTHLearn the MONTH function in Gnumeric: Determines the sequential number of a month of the year (1-12) for the date value.
- 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 to count workdays in a date interval without manually excluding weekends. Two original examples, …
- 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.
- NOTLearn the NOT function in Gnumeric: Reverses the value of the argument.
- 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 …
- ODDLearn the ODD function in Gnumeric: Rounds a positive number up and negative number down to the nearest odd integer.
- 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 …
- OFFSETUse OFFSET in Gnumeric to return a cell or rectangular range shifted from a starting cell. Two original examples, expected …
- 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 …
- 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.
- POWERLearn the POWER function in Gnumeric: Returns a^b, base a raised to the power of exponent b.
- PPMTCalculate the principal component of a regular loan payment in Gnumeric and reconcile it with total payments and interest.
- 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 …
- PRODUCTLearn the PRODUCT function in Gnumeric: Multiplies the arguments.
- PROPERLearn the PROPER function in Gnumeric: Capitalizes the first letter in all words.
- 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.
- 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 …
- RANDEXPRANDEXP(b) uses the exponential scale, equal to the ideal mean, rather than a rate. Its source does not reject a zero unit …
- 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 …
- RANDHYPERGRANDHYPERG(n 1,n 2,t) counts type 1 objects in a sample drawn without replacement. Its three numeric arguments are floored …
- RANDLAPLACERANDLAPLACE(a) generates a zero-centered, two-sided exponential variate. Its parameter is a scale, with ideal standard …
- 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 …
- RANDNORMGenerate Gnumeric normal-model draws with an explicit mean and standard deviation, using deterministic scale controls and …
- 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 …
- 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.
- REPLACELearn the REPLACE function in Gnumeric: Replaces characters within a text string with a different text string.
- REPLACEBReplace UTF-8 byte spans with REPLACEB in Gnumeric. Learn whole-character boundaries, insertions, and the changed overflow …
- REPTLearn the REPT function in Gnumeric: Repeats text a given number of times.
- 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 …
- ROMANLearn the ROMAN function in Gnumeric: Converts a number to a Roman numeral.
- ROUNDLearn the ROUND function in Gnumeric: Rounds a number to a predefined accuracy.
- ROUNDDOWNLearn the ROUNDDOWN function in Gnumeric: Rounds a number down to a predefined accuracy.
- ROUNDUPLearn the ROUNDUP function in Gnumeric: Rounds a number up to the predefined accuracy.
- ROWLearn the ROW function in Gnumeric: Defines the internal row number of a reference.
- 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
- SEARCHLearn the SEARCH function in Gnumeric: Looks for one text value within another (not case-sensitive).
- 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).
- SECONDLearn the SECOND function in Gnumeric: Determines the sequential number of the second of a minute (0-59) for the time value.
- SERIESSUMEvaluate power series with Gnumeric SERIESSUM. See coefficient ordering, fractional exponents, blank-cell compaction and the …
- SIGNLearn the SIGN function in Gnumeric: Returns the algebraic sign of a number.
- SINLearn the SIN function in Gnumeric: Returns the sine of a number.
- 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.
- SMALLLearn the SMALL function in Gnumeric: Returns the k-th smallest value of a sample.
- 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 …
- SQRTLearn the SQRT function in Gnumeric: Returns the square root of a number.
- 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 to summarize a filtered list while controlling treatment of hidden rows. Two original examples, …
- SUMLearn the SUM function in Gnumeric: Returns the sum of all arguments.
- 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.
- SUMIFSLearn the SUMIFS function in Gnumeric: Totals the values of cells in a range that meet multiple criteria in multiple ranges.
- SUMPRODUCTLearn the SUMPRODUCT function in Gnumeric: (Inner products) Returns the sum of the products of array arguments.
- SUMSQLearn the SUMSQ function in Gnumeric: Returns the sum of the squares of the arguments.
- 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.
- TANHLearn the TANH function in Gnumeric: Returns the hyperbolic tangent of a number.
- 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 …
- TEXTAFTERExtract text after a chosen delimiter in Gnumeric using occurrence, case and fallback options.
- TEXTBEFOREGet the part of a string before a delimiter, including last-occurrence and fallback examples.
- 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.
- TIMELearn the TIME function in Gnumeric: Determines a time value from the details for hour, minute and second.
- 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, …
- TRANSPOSEUse TRANSPOSE in Gnumeric to rotate a rectangular dataset so rows become columns and columns become rows. Two original …
- TRIMLearn the TRIM function in Gnumeric: Removes extra spaces from text.
- 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.
- 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.
- VLOOKUPLearn the VLOOKUP function in Gnumeric: Vertical search and reference to indicated cells.
W
- WEEKDAYLearn the WEEKDAY function in Gnumeric: Returns the day of the week for the date value as an integer.
- WEEKNUMUse WEEKNUM in Gnumeric to calculate a calendar week number for reports without confusing it with ISO week numbering. Two …
- WEIBULLWEIBULL evaluates a Weibull lifetime distribution.
- 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
- YEARLearn the YEAR function in Gnumeric: Returns the year of a date value as an integer.
- YEARFRACLearn the YEARFRAC function in Gnumeric: Returns the number of years (including fractional part) between two dates.
- YIELDDISCCalculate Gnumeric YIELDDISC’s annualized purchase-price return for a discounted security. Compare discount quotes, year …
No functions match your filters. Try a different name or category.