# deepcalc function reference

556 spreadsheet functions across 14 categories, generated from the engine's own catalog.

## categories

- [array](https://deepcalc.com/functions/array-functions.md) (30) — work on whole ranges at once and return multiple values.
- [database](https://deepcalc.com/functions/database-functions.md) (14) — group, aggregate and query tabular ranges.
- [datetime](https://deepcalc.com/functions/datetime-functions.md) (25) — build, read and do arithmetic on dates and times.
- [engineering](https://deepcalc.com/functions/engineering-functions.md) (55) — unit conversion, bases, complex numbers and bitwise operations.
- [financial](https://deepcalc.com/functions/financial-functions.md) (55) — interest, cash flow, depreciation and valuation.
- [information](https://deepcalc.com/functions/information-functions.md) (21) — ask what a cell holds — type, emptiness, errors.
- [logical](https://deepcalc.com/functions/logical-functions.md) (11) — branch and combine conditions.
- [lookup](https://deepcalc.com/functions/lookup-functions.md) (13) — find a value in a range and return a related one.
- [math](https://deepcalc.com/functions/math-functions.md) (84) — arithmetic, rounding, trigonometry and aggregation.
- [options](https://deepcalc.com/functions/options-functions.md) (20) — option pricing and the greeks — deepcalc originals, no excel equivalent.
- [stats](https://deepcalc.com/functions/stats-functions.md) (146) — distributions, averages, spread and regression.
- [text](https://deepcalc.com/functions/text-functions.md) (59) — join, split, clean, search and format strings.
- [utility](https://deepcalc.com/functions/utility-functions.md) (20) — helpers that do not belong to one calculation domain.
- [web](https://deepcalc.com/functions/web-functions.md) (3) — fetch and parse data from outside the sheet.

## functions

556 have a reference page (signature, arguments, examples); the rest are listed here with their description while the engine catalog fills in.

- [ABS](https://deepcalc.com/functions/abs.md) — returns absolute value of a number
- [ACCRINT](https://deepcalc.com/functions/accrint.md) — accrued interest for a security paying periodic interest
- [ACCRINTM](https://deepcalc.com/functions/accrintm.md) — accrued interest for a security paying at maturity
- [ACOS](https://deepcalc.com/functions/acos.md) — returns arccosine of a number
- [ACOSH](https://deepcalc.com/functions/acosh.md) — returns inverse hyperbolic cosine
- [ACOT](https://deepcalc.com/functions/acot.md) — returns the arccotangent of a number
- [ACOTH](https://deepcalc.com/functions/acoth.md) — returns the inverse hyperbolic cotangent
- [ADDRESS](https://deepcalc.com/functions/address.md) — returns a cell address as text from row and column numbers
- [AMORDEGRC](https://deepcalc.com/functions/amordegrc.md) — depreciation per period, French accounting, degressive
- [AMORLINC](https://deepcalc.com/functions/amorlinc.md) — depreciation per period, French accounting, linear
- [AND](https://deepcalc.com/functions/and.md) — returns TRUE if all arguments are true
- [ARABIC](https://deepcalc.com/functions/arabic.md) — converts roman numeral to arabic number
- [AREAS](https://deepcalc.com/functions/areas.md) — returns the number of areas in a reference
- [ARRAYFORMULA](https://deepcalc.com/functions/arrayformula.md) — evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility)
- [ARRAYTOTEXT](https://deepcalc.com/functions/arraytotext.md) — converts array to text representation
- [ASC](https://deepcalc.com/functions/asc.md) — converts full-width characters to half-width
- [ASIAN.CALL](https://deepcalc.com/functions/asian-call.md) — Asian call on the geometric average of n_avg observations (exact closed form; approximates the arithmetic Asian)
- [ASIN](https://deepcalc.com/functions/asin.md) — returns arcsine of a number
- [ASINH](https://deepcalc.com/functions/asinh.md) — returns inverse hyperbolic sine
- [ATAN](https://deepcalc.com/functions/atan.md) — returns arctangent of a number
- [ATAN2](https://deepcalc.com/functions/atan2.md) — returns arctangent from x and y coordinates
- [ATANH](https://deepcalc.com/functions/atanh.md) — returns inverse hyperbolic tangent
- [AVEDEV](https://deepcalc.com/functions/avedev.md) — average of absolute deviations from the mean
- [AVERAGE](https://deepcalc.com/functions/average.md) — calculates arithmetic mean
- [AVERAGEA](https://deepcalc.com/functions/averagea.md) — averages values including text and logicals
- [AVERAGEIF](https://deepcalc.com/functions/averageif.md) — averages cells that match a condition
- [AVERAGEIFS](https://deepcalc.com/functions/averageifs.md) — averages cells matching multiple conditions
- [BARRIER.CALL](https://deepcalc.com/functions/barrier-call.md) — barrier call option: type 1=down-and-out, 2=down-and-in, 3=up-and-out, 4=up-and-in (Hull ch. 26 formulas)
- [BASE](https://deepcalc.com/functions/base.md) — converts number to text in given base
- [BESSELI](https://deepcalc.com/functions/besseli.md) — returns modified Bessel function In(x)
- [BESSELJ](https://deepcalc.com/functions/besselj.md) — returns Bessel function Jn(x)
- [BESSELK](https://deepcalc.com/functions/besselk.md) — returns modified Bessel function Kn(x)
- [BESSELY](https://deepcalc.com/functions/bessely.md) — returns Bessel function Yn(x)
- [BETA.DIST](https://deepcalc.com/functions/beta-dist.md) — beta distribution
- [BETA.INV](https://deepcalc.com/functions/beta-inv.md) — inverse of the beta distribution
- [BETADIST](https://deepcalc.com/functions/betadist.md) — legacy form of BETA.DIST (cumulative)
- [BETAINV](https://deepcalc.com/functions/betainv.md) — legacy form of BETA.INV
- [BIN2DEC](https://deepcalc.com/functions/bin2dec.md) — converts binary number to decimal
- [BIN2HEX](https://deepcalc.com/functions/bin2hex.md) — converts binary number to hexadecimal
- [BIN2OCT](https://deepcalc.com/functions/bin2oct.md) — converts binary number to octal
- [BINOM.DIST](https://deepcalc.com/functions/binom-dist.md) — binomial distribution probability
- [BINOM.DIST.RANGE](https://deepcalc.com/functions/binom-dist-range.md) — probability of a trial result range
- [BINOM.INV](https://deepcalc.com/functions/binom-inv.md) — smallest value with cumulative binomial at or above a criterion
- [BINOMDIST](https://deepcalc.com/functions/binomdist.md) — legacy form of BINOM.DIST
- [BINOMIAL.AMERICAN.PUT](https://deepcalc.com/functions/binomial-american-put.md) — binomial tree American put option price
- [BINOMIAL.CALL](https://deepcalc.com/functions/binomial-call.md) — binomial tree call option price
- [BINOMIAL.PUT](https://deepcalc.com/functions/binomial-put.md) — binomial tree put option price
- [BITAND](https://deepcalc.com/functions/bitand.md) — returns bitwise AND of two numbers
- [BITLSHIFT](https://deepcalc.com/functions/bitlshift.md) — returns number shifted left by bits
- [BITOR](https://deepcalc.com/functions/bitor.md) — returns bitwise OR of two numbers
- [BITRSHIFT](https://deepcalc.com/functions/bitrshift.md) — returns number shifted right by bits
- [BITXOR](https://deepcalc.com/functions/bitxor.md) — returns bitwise XOR of two numbers
- [BS.CALL](https://deepcalc.com/functions/bs-call.md) — Black-Scholes call option price
- [BS.CALL.DIVIDEND](https://deepcalc.com/functions/bs-call-dividend.md) — Black-Scholes call option with dividend yield
- [BS.IMPLIED_VOL.CALL](https://deepcalc.com/functions/bs-implied-vol-call.md) — implied volatility from call option price
- [BS.IMPLIED_VOL.PUT](https://deepcalc.com/functions/bs-implied-vol-put.md) — implied volatility from put option price
- [BS.PUT](https://deepcalc.com/functions/bs-put.md) — Black-Scholes put option price
- [BS.PUT.DIVIDEND](https://deepcalc.com/functions/bs-put-dividend.md) — Black-Scholes put option with dividend yield
- [BYCOL](https://deepcalc.com/functions/bycol.md) — applies lambda to each column of array
- [BYROW](https://deepcalc.com/functions/byrow.md) — applies lambda to each row of array
- [CEILING](https://deepcalc.com/functions/ceiling.md) — rounds up to the nearest multiple of significance
- [CEILING.MATH](https://deepcalc.com/functions/ceiling-math.md) — rounds up with optional significance and mode
- [CEILING.PRECISE](https://deepcalc.com/functions/ceiling-precise.md) — rounds up to the nearest multiple, sign-independent
- [CELL](https://deepcalc.com/functions/cell.md) — information about a cell's formatting, location or contents
- [CHAR](https://deepcalc.com/functions/char.md) — returns the character for a character-set code
- [CHIDIST](https://deepcalc.com/functions/chidist.md) — legacy form of CHISQ.DIST.RT
- [CHIINV](https://deepcalc.com/functions/chiinv.md) — legacy form of CHISQ.INV.RT
- [CHISQ.DIST](https://deepcalc.com/functions/chisq-dist.md) — returns the chi-squared distribution
- [CHISQ.DIST.RT](https://deepcalc.com/functions/chisq-dist-rt.md) — returns the right-tailed chi-squared distribution
- [CHISQ.INV](https://deepcalc.com/functions/chisq-inv.md) — returns the inverse of the chi-squared distribution
- [CHISQ.INV.RT](https://deepcalc.com/functions/chisq-inv-rt.md) — returns the inverse of the right-tailed chi-squared distribution
- [CHISQ.TEST](https://deepcalc.com/functions/chisq-test.md) — chi-squared test for independence
- [CHITEST](https://deepcalc.com/functions/chitest.md) — legacy form of CHISQ.TEST
- [CHOOSE](https://deepcalc.com/functions/choose.md) — chooses a value from a list by index
- [CHOOSECOLS](https://deepcalc.com/functions/choosecols.md) — returns the specified columns from an array
- [CHOOSEROWS](https://deepcalc.com/functions/chooserows.md) — returns the specified rows from an array
- [CLEAN](https://deepcalc.com/functions/clean.md) — removes non-printable characters
- [CODE](https://deepcalc.com/functions/code.md) — numeric code of the first character
- [COLUMN](https://deepcalc.com/functions/column.md) — returns column number of a reference
- [COLUMNS](https://deepcalc.com/functions/columns.md) — returns number of columns in a reference
- [COMBIN](https://deepcalc.com/functions/combin.md) — number of combinations of n items taken k at a time
- [COMBINA](https://deepcalc.com/functions/combina.md) — combinations with repetitions
- [COMPLEX](https://deepcalc.com/functions/complex.md) — converts real and imaginary to complex
- [CONCAT](https://deepcalc.com/functions/concat.md) — joins multiple text strings into one
- [CONCATENATE](https://deepcalc.com/functions/concatenate.md) — joins several text strings into one
- [CONFIDENCE](https://deepcalc.com/functions/confidence.md) — legacy form of CONFIDENCE.NORM
- [CONFIDENCE.NORM](https://deepcalc.com/functions/confidence-norm.md) — confidence interval for a population mean, normal
- [CONFIDENCE.T](https://deepcalc.com/functions/confidence-t.md) — confidence interval for a population mean, Student's t
- [CONTAINS](https://deepcalc.com/functions/contains.md) — checks if text contains substring
- [CONVERT](https://deepcalc.com/functions/convert.md) — converts number between measurement units
- [CORREL](https://deepcalc.com/functions/correl.md) — correlation coefficient between two data sets
- [COS](https://deepcalc.com/functions/cos.md) — returns cosine of an angle
- [COSH](https://deepcalc.com/functions/cosh.md) — returns hyperbolic cosine
- [COT](https://deepcalc.com/functions/cot.md) — returns cotangent of an angle
- [COTH](https://deepcalc.com/functions/coth.md) — returns hyperbolic cotangent
- [COUNT](https://deepcalc.com/functions/count.md) — counts cells containing numbers
- [COUNTA](https://deepcalc.com/functions/counta.md) — counts non-empty cells in a range
- [COUNTBLANK](https://deepcalc.com/functions/countblank.md) — counts empty cells in a range
- [COUNTIF](https://deepcalc.com/functions/countif.md) — counts cells that match a condition
- [COUNTIFS](https://deepcalc.com/functions/countifs.md) — counts cells matching multiple conditions
- [COUPDAYBS](https://deepcalc.com/functions/coupdaybs.md) — days from coupon period start to settlement
- [COUPDAYS](https://deepcalc.com/functions/coupdays.md) — days in the coupon period containing settlement
- [COUPDAYSNC](https://deepcalc.com/functions/coupdaysnc.md) — days from settlement to the next coupon date
- [COUPNCD](https://deepcalc.com/functions/coupncd.md) — next coupon date after settlement
- [COUPNUM](https://deepcalc.com/functions/coupnum.md) — number of coupons between settlement and maturity
- [COUPPCD](https://deepcalc.com/functions/couppcd.md) — previous coupon date before settlement
- [COVAR](https://deepcalc.com/functions/covar.md) — legacy form of COVARIANCE.P: population covariance
- [COVARIANCE.P](https://deepcalc.com/functions/covariance-p.md) — population covariance
- [COVARIANCE.S](https://deepcalc.com/functions/covariance-s.md) — sample covariance
- [CRITBINOM](https://deepcalc.com/functions/critbinom.md) — legacy form of BINOM.INV
- [CSC](https://deepcalc.com/functions/csc.md) — returns cosecant of an angle
- [CSCH](https://deepcalc.com/functions/csch.md) — returns hyperbolic cosecant
- [CUMIPMT](https://deepcalc.com/functions/cumipmt.md) — returns cumulative interest paid on loan
- [CUMPRINC](https://deepcalc.com/functions/cumprinc.md) — returns cumulative principal paid on loan
- [DATE](https://deepcalc.com/functions/date.md) — creates date from year, month, day
- [DATEDIF](https://deepcalc.com/functions/datedif.md) — calculates difference between two dates
- [DATEVALUE](https://deepcalc.com/functions/datevalue.md) — converts date text to serial number
- [DAVERAGE](https://deepcalc.com/functions/daverage.md) — average of database values matching criteria
- [DAY](https://deepcalc.com/functions/day.md) — returns day of month from date
- [DAYS](https://deepcalc.com/functions/days.md) — returns number of days between two dates
- [DAYS360](https://deepcalc.com/functions/days360.md) — returns days between dates on 360-day year
- [DB](https://deepcalc.com/functions/db.md) — returns fixed-declining balance depreciation
- [DCOUNT](https://deepcalc.com/functions/dcount.md) — counts numeric database values matching criteria
- [DCOUNTA](https://deepcalc.com/functions/dcounta.md) — counts non-empty database values matching criteria
- [DDB](https://deepcalc.com/functions/ddb.md) — returns double-declining balance depreciation
- [DEC2BIN](https://deepcalc.com/functions/dec2bin.md) — converts decimal number to binary
- [DEC2HEX](https://deepcalc.com/functions/dec2hex.md) — converts decimal number to hexadecimal
- [DEC2OCT](https://deepcalc.com/functions/dec2oct.md) — converts decimal number to octal
- [DECIMAL](https://deepcalc.com/functions/decimal.md) — converts text in given base to number
- [DECODEURL](https://deepcalc.com/functions/decodeurl.md) — decodes URL-encoded text
- [DEGREES](https://deepcalc.com/functions/degrees.md) — converts radians to degrees
- [DELTA](https://deepcalc.com/functions/delta.md) — tests if two values are equal
- [DELTA.CALL](https://deepcalc.com/functions/delta-call.md) — delta of call option (rate of change with respect to underlying price)
- [DELTA.PUT](https://deepcalc.com/functions/delta-put.md) — delta of put option
- [DEVSQ](https://deepcalc.com/functions/devsq.md) — sum of squared deviations from the mean
- [DGET](https://deepcalc.com/functions/dget.md) — the single database value matching criteria
- [DIGITAL.CALL](https://deepcalc.com/functions/digital-call.md) — digital (binary) call option that pays fixed amount
- [DISC](https://deepcalc.com/functions/disc.md) — discount rate of a security
- [DMAX](https://deepcalc.com/functions/dmax.md) — largest database value matching criteria
- [DMIN](https://deepcalc.com/functions/dmin.md) — smallest database value matching criteria
- [DOLLAR](https://deepcalc.com/functions/dollar.md) — formats a number as currency text
- [DOLLARDE](https://deepcalc.com/functions/dollarde.md) — converts fractional dollar to decimal
- [DOLLARFR](https://deepcalc.com/functions/dollarfr.md) — converts decimal dollar to fractional
- [DPRODUCT](https://deepcalc.com/functions/dproduct.md) — product of database values matching criteria
- [DROP](https://deepcalc.com/functions/drop.md) — removes rows or columns from the start or end of an array
- [DSTDEV](https://deepcalc.com/functions/dstdev.md) — sample standard deviation of matching database values
- [DSTDEVP](https://deepcalc.com/functions/dstdevp.md) — population standard deviation of matching database values
- [DSUM](https://deepcalc.com/functions/dsum.md) — sum of database values matching criteria
- [DURATION](https://deepcalc.com/functions/duration.md) — returns the Macaulay duration of a security
- [DVAR](https://deepcalc.com/functions/dvar.md) — sample variance of matching database values
- [DVARP](https://deepcalc.com/functions/dvarp.md) — population variance of matching database values
- [EDATE](https://deepcalc.com/functions/edate.md) — returns date shifted by given months
- [EFFECT](https://deepcalc.com/functions/effect.md) — returns effective annual interest rate
- [ENCODEURL](https://deepcalc.com/functions/encodeurl.md) — encodes text for use in URLs using percent encoding
- [ENDSWITH](https://deepcalc.com/functions/endswith.md) — checks if text ends with suffix
- [EOMONTH](https://deepcalc.com/functions/eomonth.md) — returns last day of month after offset
- [ERF](https://deepcalc.com/functions/erf.md) — returns the error function
- [ERF.PRECISE](https://deepcalc.com/functions/erf-precise.md) — returns the error function integrated from 0
- [ERFC](https://deepcalc.com/functions/erfc.md) — returns complementary error function
- [ERFC.PRECISE](https://deepcalc.com/functions/erfc-precise.md) — returns complementary error function from x
- [ERROR.TYPE](https://deepcalc.com/functions/error-type.md) — returns number corresponding to an error type
- [EVEN](https://deepcalc.com/functions/even.md) — rounds up to the nearest even integer
- [EXACT](https://deepcalc.com/functions/exact.md) — checks if two text strings are identical
- [EXP](https://deepcalc.com/functions/exp.md) — e raised to the power of a number
- [EXPAND](https://deepcalc.com/functions/expand.md) — pads an array to a given size with a fill value
- [EXPON.DIST](https://deepcalc.com/functions/expon-dist.md) — exponential distribution
- [EXPONDIST](https://deepcalc.com/functions/expondist.md) — legacy form of EXPON.DIST
- [F.DIST](https://deepcalc.com/functions/f-dist.md) — F probability distribution
- [F.DIST.RT](https://deepcalc.com/functions/f-dist-rt.md) — right-tailed F probability distribution
- [F.INV](https://deepcalc.com/functions/f-inv.md) — inverse of the F distribution
- [F.INV.RT](https://deepcalc.com/functions/f-inv-rt.md) — inverse of the right-tailed F distribution
- [F.TEST](https://deepcalc.com/functions/f-test.md) — F-test for equality of variances
- [FACT](https://deepcalc.com/functions/fact.md) — factorial of a number
- [FACTDOUBLE](https://deepcalc.com/functions/factdouble.md) — returns double factorial of a number
- [FALSE](https://deepcalc.com/functions/false.md) — returns the logical value FALSE
- [FDIST](https://deepcalc.com/functions/fdist.md) — legacy form of F.DIST.RT
- [FILTER](https://deepcalc.com/functions/filter.md) — returns the rows or columns of a range that meet a condition
- [FIND](https://deepcalc.com/functions/find.md) — finds text within another text, case-sensitive
- [FINDB](https://deepcalc.com/functions/findb.md) — finds text within text by bytes, case-sensitive
- [FINV](https://deepcalc.com/functions/finv.md) — legacy form of F.INV.RT
- [FISHER](https://deepcalc.com/functions/fisher.md) — returns the Fisher transformation
- [FISHERINV](https://deepcalc.com/functions/fisherinv.md) — inverse of the Fisher transformation
- [FIXED](https://deepcalc.com/functions/fixed.md) — formats a number as text with a fixed number of decimals
- [FLOOR](https://deepcalc.com/functions/floor.md) — rounds down to the nearest multiple of significance
- [FLOOR.MATH](https://deepcalc.com/functions/floor-math.md) — rounds down with optional significance and mode
- [FLOOR.PRECISE](https://deepcalc.com/functions/floor-precise.md) — rounds down to the nearest multiple, sign-independent
- [FORECAST](https://deepcalc.com/functions/forecast.md) — predicts a value along a linear trend
- [FORECAST.ETS](https://deepcalc.com/functions/forecast-ets.md) — forecasts a value using exponential smoothing
- [FORECAST.ETS.CONFINT](https://deepcalc.com/functions/forecast-ets-confint.md) — confidence interval for an ETS forecast
- [FORECAST.ETS.SEASONALITY](https://deepcalc.com/functions/forecast-ets-seasonality.md) — season length detected by ETS
- [FORECAST.ETS.STAT](https://deepcalc.com/functions/forecast-ets-stat.md) — statistic from the ETS model
- [FORECAST.LINEAR](https://deepcalc.com/functions/forecast-linear.md) — predicts a value on the linear regression line
- [FORMULATEXT](https://deepcalc.com/functions/formulatext.md) — returns formula as a text string
- [FREQUENCY](https://deepcalc.com/functions/frequency.md) — counts values falling into bins, spilled as a column
- [FROMBYTES](https://deepcalc.com/functions/frombytes.md) — converts byte array to integer
- [FTEST](https://deepcalc.com/functions/ftest.md) — legacy form of F.TEST
- [FV](https://deepcalc.com/functions/fv.md) — returns future value of an investment
- [FVSCHEDULE](https://deepcalc.com/functions/fvschedule.md) — future value under a schedule of compound rates
- [GAMMA](https://deepcalc.com/functions/gamma.md) — returns the gamma function value
- [GAMMA.DIST](https://deepcalc.com/functions/gamma-dist.md) — gamma distribution
- [GAMMA.INV](https://deepcalc.com/functions/gamma-inv.md) — inverse of the gamma distribution
- [GAMMADIST](https://deepcalc.com/functions/gammadist.md) — legacy form of GAMMA.DIST
- [GAMMAINV](https://deepcalc.com/functions/gammainv.md) — legacy form of GAMMA.INV
- [GAMMALN](https://deepcalc.com/functions/gammaln.md) — natural logarithm of the gamma function
- [GAMMALN.PRECISE](https://deepcalc.com/functions/gammaln-precise.md) — natural logarithm of the gamma function
- [GAUSS](https://deepcalc.com/functions/gauss.md) — probability a standard normal member falls between the mean and z
- [GCD](https://deepcalc.com/functions/gcd.md) — greatest common divisor
- [GENERATEID](https://deepcalc.com/functions/generateid.md) — generates unique ID with prefix and random suffix
- [GEOMEAN](https://deepcalc.com/functions/geomean.md) — returns geometric mean of positive values
- [GESTEP](https://deepcalc.com/functions/gestep.md) — tests if number is greater than threshold
- [GROUPBY](https://deepcalc.com/functions/groupby.md) — groups rows by a label column and aggregates a value column
- [GROWTH](https://deepcalc.com/functions/growth.md) — values along an exponential trend
- [HARMEAN](https://deepcalc.com/functions/harmean.md) — returns the harmonic mean
- [HASH](https://deepcalc.com/functions/hash.md) — hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- [HEX2BIN](https://deepcalc.com/functions/hex2bin.md) — converts hexadecimal number to binary
- [HEX2DEC](https://deepcalc.com/functions/hex2dec.md) — converts hexadecimal number to decimal
- [HEX2OCT](https://deepcalc.com/functions/hex2oct.md) — converts hexadecimal number to octal
- [HLOOKUP](https://deepcalc.com/functions/hlookup.md) — searches first row and returns matching value
- [HOUR](https://deepcalc.com/functions/hour.md) — returns hour component of a time
- [HSTACK](https://deepcalc.com/functions/hstack.md) — joins arrays side by side into one array
- [HYPGEOM.DIST](https://deepcalc.com/functions/hypgeom-dist.md) — hypergeometric distribution
- [HYPGEOMDIST](https://deepcalc.com/functions/hypgeomdist.md) — legacy form of HYPGEOM.DIST
- [IF](https://deepcalc.com/functions/if.md) — returns one value if condition is true, another if false
- [IFERROR](https://deepcalc.com/functions/iferror.md) — returns value if no error, otherwise alternate
- [IFNA](https://deepcalc.com/functions/ifna.md) — returns value if not #N/A, otherwise alternate
- [IFS](https://deepcalc.com/functions/ifs.md) — checks multiple conditions, returns first match
- [IMABS](https://deepcalc.com/functions/imabs.md) — returns absolute value of complex number
- [IMAGINARY](https://deepcalc.com/functions/imaginary.md) — returns imaginary coefficient of complex number
- [IMARGUMENT](https://deepcalc.com/functions/imargument.md) — returns argument theta of complex number
- [IMCONJUGATE](https://deepcalc.com/functions/imconjugate.md) — returns complex conjugate of complex number
- [IMCOS](https://deepcalc.com/functions/imcos.md) — returns cosine of a complex number
- [IMCOSH](https://deepcalc.com/functions/imcosh.md) — returns hyperbolic cosine of complex number
- [IMCOT](https://deepcalc.com/functions/imcot.md) — returns cotangent of a complex number
- [IMCSC](https://deepcalc.com/functions/imcsc.md) — returns cosecant of a complex number
- [IMCSCH](https://deepcalc.com/functions/imcsch.md) — returns hyperbolic cosecant of complex number
- [IMDIV](https://deepcalc.com/functions/imdiv.md) — returns quotient of two complex numbers
- [IMEXP](https://deepcalc.com/functions/imexp.md) — returns exponential of a complex number
- [IMLN](https://deepcalc.com/functions/imln.md) — returns natural logarithm of complex number
- [IMLOG10](https://deepcalc.com/functions/imlog10.md) — returns base-10 logarithm of complex number
- [IMLOG2](https://deepcalc.com/functions/imlog2.md) — returns base-2 logarithm of complex number
- [IMPOWER](https://deepcalc.com/functions/impower.md) — returns complex number raised to power
- [IMPRODUCT](https://deepcalc.com/functions/improduct.md) — returns product of complex numbers
- [IMREAL](https://deepcalc.com/functions/imreal.md) — returns real coefficient of complex number
- [IMSEC](https://deepcalc.com/functions/imsec.md) — returns secant of a complex number
- [IMSECH](https://deepcalc.com/functions/imsech.md) — returns hyperbolic secant of complex number
- [IMSIN](https://deepcalc.com/functions/imsin.md) — returns sine of a complex number
- [IMSINH](https://deepcalc.com/functions/imsinh.md) — returns hyperbolic sine of complex number
- [IMSQRT](https://deepcalc.com/functions/imsqrt.md) — returns square root of complex number
- [IMSUB](https://deepcalc.com/functions/imsub.md) — returns difference of two complex numbers
- [IMSUM](https://deepcalc.com/functions/imsum.md) — returns sum of complex numbers
- [IMTAN](https://deepcalc.com/functions/imtan.md) — returns tangent of a complex number
- [INDEX](https://deepcalc.com/functions/index.md) — returns value at row and column in range
- [INDIRECT](https://deepcalc.com/functions/indirect.md) — returns reference specified by text string
- [INFO](https://deepcalc.com/functions/info.md) — information about the operating environment
- [INT](https://deepcalc.com/functions/int.md) — rounds down to the nearest integer
- [INTERCEPT](https://deepcalc.com/functions/intercept.md) — y-intercept of the linear regression line
- [INTRATE](https://deepcalc.com/functions/intrate.md) — interest rate of a fully invested security
- [IPMT](https://deepcalc.com/functions/ipmt.md) — returns interest payment for a period
- [IRR](https://deepcalc.com/functions/irr.md) — calculates internal rate of return
- [ISBLANK](https://deepcalc.com/functions/isblank.md) — returns TRUE if value is blank
- [ISERR](https://deepcalc.com/functions/iserr.md) — returns TRUE if value is any error except #N/A
- [ISERROR](https://deepcalc.com/functions/iserror.md) — returns TRUE if value is any error
- [ISEVEN](https://deepcalc.com/functions/iseven.md) — returns TRUE if number is even
- [ISFORMULA](https://deepcalc.com/functions/isformula.md) — returns TRUE if cell contains a formula
- [ISIN](https://deepcalc.com/functions/isin.md) — checks if value is in a range or comma-separated list
- [ISLOGICAL](https://deepcalc.com/functions/islogical.md) — returns TRUE if value is logical
- [ISNA](https://deepcalc.com/functions/isna.md) — returns TRUE if value is #N/A error
- [ISNONTEXT](https://deepcalc.com/functions/isnontext.md) — returns TRUE if value is not text
- [ISNUMBER](https://deepcalc.com/functions/isnumber.md) — returns TRUE if value is a number
- [ISO.CEILING](https://deepcalc.com/functions/iso-ceiling.md) — rounds up to the nearest multiple, sign-independent
- [ISODD](https://deepcalc.com/functions/isodd.md) — returns TRUE if number is odd
- [ISOMITTED](https://deepcalc.com/functions/isomitted.md) — checks if lambda argument is omitted
- [ISOWEEKNUM](https://deepcalc.com/functions/isoweeknum.md) — returns ISO week number of a date
- [ISPMT](https://deepcalc.com/functions/ispmt.md) — returns interest for even-principal payment
- [ISREF](https://deepcalc.com/functions/isref.md) — returns TRUE if value is a reference
- [ISTEXT](https://deepcalc.com/functions/istext.md) — returns TRUE if value is text
- [JOIN](https://deepcalc.com/functions/join.md) — joins values with delimiter
- [KURT](https://deepcalc.com/functions/kurt.md) — returns the kurtosis of a data set
- [LAMBDA](https://deepcalc.com/functions/lambda.md) — creates a custom reusable function
- [LARGE](https://deepcalc.com/functions/large.md) — returns the k-th largest value in a data set
- [LCM](https://deepcalc.com/functions/lcm.md) — least common multiple
- [LEFT](https://deepcalc.com/functions/left.md) — returns leftmost characters from text
- [LEFTB](https://deepcalc.com/functions/leftb.md) — returns leftmost bytes from text
- [LEN](https://deepcalc.com/functions/len.md) — returns number of characters in text
- [LENB](https://deepcalc.com/functions/lenb.md) — returns number of bytes in text
- [LET](https://deepcalc.com/functions/let.md) — assigns names to values in a formula
- [LINEST](https://deepcalc.com/functions/linest.md) — parameters of the least-squares linear fit
- [LN](https://deepcalc.com/functions/ln.md) — natural logarithm of a number
- [LOG](https://deepcalc.com/functions/log.md) — logarithm to a given base
- [LOG10](https://deepcalc.com/functions/log10.md) — base-10 logarithm of a number
- [LOGEST](https://deepcalc.com/functions/logest.md) — parameters of the exponential curve fit
- [LOGINV](https://deepcalc.com/functions/loginv.md) — legacy form of LOGNORM.INV
- [LOGNORM.DIST](https://deepcalc.com/functions/lognorm-dist.md) — lognormal distribution
- [LOGNORM.INV](https://deepcalc.com/functions/lognorm-inv.md) — inverse of the lognormal distribution
- [LOGNORMDIST](https://deepcalc.com/functions/lognormdist.md) — legacy form of LOGNORM.DIST (cumulative)
- [LOOKUP](https://deepcalc.com/functions/lookup.md) — looks up value in one-row or one-column range
- [LOWER](https://deepcalc.com/functions/lower.md) — converts text to lowercase
- [MAKEARRAY](https://deepcalc.com/functions/makearray.md) — creates array from lambda over indices
- [MAP](https://deepcalc.com/functions/map.md) — maps lambda over array values
- [MATCH](https://deepcalc.com/functions/match.md) — returns position of value in a range
- [MAX](https://deepcalc.com/functions/max.md) — returns the largest value in a set
- [MAXA](https://deepcalc.com/functions/maxa.md) — returns the largest value, counting text and logicals
- [MAXIFS](https://deepcalc.com/functions/maxifs.md) — returns largest value matching conditions
- [MDETERM](https://deepcalc.com/functions/mdeterm.md) — returns matrix determinant of an array
- [MDURATION](https://deepcalc.com/functions/mduration.md) — modified Macauley duration
- [MEDIAN](https://deepcalc.com/functions/median.md) — returns the median of a set of numbers
- [MID](https://deepcalc.com/functions/mid.md) — returns characters from middle of text
- [MIDB](https://deepcalc.com/functions/midb.md) — returns bytes from middle of text
- [MIN](https://deepcalc.com/functions/min.md) — returns the smallest value in a set
- [MINA](https://deepcalc.com/functions/mina.md) — returns the smallest value, counting text and logicals
- [MINIFS](https://deepcalc.com/functions/minifs.md) — returns smallest value matching conditions
- [MINUTE](https://deepcalc.com/functions/minute.md) — returns minute component of a time
- [MINVERSE](https://deepcalc.com/functions/minverse.md) — returns matrix inverse of an array
- [MIRR](https://deepcalc.com/functions/mirr.md) — returns modified internal rate of return
- [MMULT](https://deepcalc.com/functions/mmult.md) — returns the matrix product of two arrays
- [MOD](https://deepcalc.com/functions/mod.md) — remainder after division
- [MODE](https://deepcalc.com/functions/mode.md) — legacy form of MODE.SNGL: most frequent value in a data set
- [MODE.MULT](https://deepcalc.com/functions/mode-mult.md) — returns an array of the most frequently occurring values
- [MODE.SNGL](https://deepcalc.com/functions/mode-sngl.md) — returns the most frequently occurring value
- [MONTH](https://deepcalc.com/functions/month.md) — returns month component of a date
- [MROUND](https://deepcalc.com/functions/mround.md) — rounds to the nearest multiple
- [MULTINOMIAL](https://deepcalc.com/functions/multinomial.md) — returns the multinomial coefficient of a set of numbers
- [MUNIT](https://deepcalc.com/functions/munit.md) — returns identity matrix of given size
- [N](https://deepcalc.com/functions/n.md) — converts a value to a number
- [NA](https://deepcalc.com/functions/na.md) — returns the error value #N/A
- [NEGBINOM.DIST](https://deepcalc.com/functions/negbinom-dist.md) — negative binomial distribution
- [NEGBINOMDIST](https://deepcalc.com/functions/negbinomdist.md) — legacy form of NEGBINOM.DIST
- [NETWORKDAYS](https://deepcalc.com/functions/networkdays.md) — returns business days between two dates
- [NETWORKDAYS.INTL](https://deepcalc.com/functions/networkdays-intl.md) — counts business days with custom weekend
- [NOMINAL](https://deepcalc.com/functions/nominal.md) — returns annual nominal interest rate
- [NORM.DIST](https://deepcalc.com/functions/norm-dist.md) — normal distribution
- [NORM.INV](https://deepcalc.com/functions/norm-inv.md) — inverse of the normal distribution
- [NORM.S.DIST](https://deepcalc.com/functions/norm-s-dist.md) — standard normal distribution
- [NORM.S.INV](https://deepcalc.com/functions/norm-s-inv.md) — inverse of the standard normal distribution
- [NORMDIST](https://deepcalc.com/functions/normdist.md) — legacy form of NORM.DIST
- [NORMINV](https://deepcalc.com/functions/norminv.md) — legacy form of NORM.INV
- [NORMSDIST](https://deepcalc.com/functions/normsdist.md) — legacy form of NORM.S.DIST (cumulative)
- [NORMSINV](https://deepcalc.com/functions/normsinv.md) — legacy form of NORM.S.INV
- [NOT](https://deepcalc.com/functions/not.md) — reverses the logic of its argument
- [NOW](https://deepcalc.com/functions/now.md) — returns current date and time
- [NPER](https://deepcalc.com/functions/nper.md) — returns number of periods for investment
- [NPV](https://deepcalc.com/functions/npv.md) — calculates net present value of investment
- [NUMBERVALUE](https://deepcalc.com/functions/numbervalue.md) — converts text to a number, locale-independent
- [OCT2BIN](https://deepcalc.com/functions/oct2bin.md) — converts octal number to binary
- [OCT2DEC](https://deepcalc.com/functions/oct2dec.md) — converts octal number to decimal
- [OCT2HEX](https://deepcalc.com/functions/oct2hex.md) — converts octal number to hexadecimal
- [ODD](https://deepcalc.com/functions/odd.md) — rounds up to the nearest odd integer
- [ODDFPRICE](https://deepcalc.com/functions/oddfprice.md) — returns the price of a security with an odd first period
- [ODDFYIELD](https://deepcalc.com/functions/oddfyield.md) — yield of a security with an odd first period
- [ODDLPRICE](https://deepcalc.com/functions/oddlprice.md) — price of a security with an odd last period
- [ODDLYIELD](https://deepcalc.com/functions/oddlyield.md) — yield of a security with an odd last period
- [OFFSET](https://deepcalc.com/functions/offset.md) — returns reference offset from starting point
- [OPT.GAMMA](https://deepcalc.com/functions/opt-gamma.md) — gamma of option (rate of change of delta)
- [OPT.VEGA](https://deepcalc.com/functions/opt-vega.md) — vega of option (sensitivity to volatility)
- [OR](https://deepcalc.com/functions/or.md) — returns TRUE if any argument is true
- [PDURATION](https://deepcalc.com/functions/pduration.md) — returns periods to reach target value
- [PEARSON](https://deepcalc.com/functions/pearson.md) — Pearson product moment correlation coefficient
- [PERCENTILE](https://deepcalc.com/functions/percentile.md) — legacy form of PERCENTILE.INC: k-th percentile
- [PERCENTILE.EXC](https://deepcalc.com/functions/percentile-exc.md) — k-th percentile, exclusive
- [PERCENTILE.INC](https://deepcalc.com/functions/percentile-inc.md) — returns the k-th percentile, inclusive
- [PERCENTOF](https://deepcalc.com/functions/percentof.md) — share of a data subset within a whole
- [PERCENTRANK](https://deepcalc.com/functions/percentrank.md) — legacy form of PERCENTRANK.INC: rank as a percentage
- [PERCENTRANK.EXC](https://deepcalc.com/functions/percentrank-exc.md) — percentage rank, exclusive
- [PERCENTRANK.INC](https://deepcalc.com/functions/percentrank-inc.md) — percentage rank, inclusive
- [PERMUT](https://deepcalc.com/functions/permut.md) — returns the number of permutations of a set of objects
- [PERMUTATIONA](https://deepcalc.com/functions/permutationa.md) — returns the number of permutations with repetitions allowed
- [PHI](https://deepcalc.com/functions/phi.md) — density function value for the standard normal distribution
- [PI](https://deepcalc.com/functions/pi.md) — returns the value of pi
- [PMT](https://deepcalc.com/functions/pmt.md) — returns periodic payment for an annuity
- [POISSON](https://deepcalc.com/functions/poisson.md) — legacy form of POISSON.DIST
- [POISSON.DIST](https://deepcalc.com/functions/poisson-dist.md) — Poisson distribution
- [POWER](https://deepcalc.com/functions/power.md) — returns number raised to a power
- [PPMT](https://deepcalc.com/functions/ppmt.md) — returns principal payment for a period
- [PRICE](https://deepcalc.com/functions/price.md) — returns the price per $100 face value of a security paying periodic interest
- [PRICEDISC](https://deepcalc.com/functions/pricedisc.md) — price of a discounted security
- [PRICEMAT](https://deepcalc.com/functions/pricemat.md) — price of a security paying interest at maturity
- [PROB](https://deepcalc.com/functions/prob.md) — probability that values fall within limits
- [PRODUCT](https://deepcalc.com/functions/product.md) — multiplies all numbers given as arguments
- [PROPER](https://deepcalc.com/functions/proper.md) — capitalizes the first letter of each word
- [PV](https://deepcalc.com/functions/pv.md) — returns present value of an investment
- [QUARTILE](https://deepcalc.com/functions/quartile.md) — legacy form of QUARTILE.INC: quartile of a data set
- [QUARTILE.EXC](https://deepcalc.com/functions/quartile-exc.md) — returns a quartile, excluding the median
- [QUARTILE.INC](https://deepcalc.com/functions/quartile-inc.md) — returns a quartile, including the median
- [QUERY](https://deepcalc.com/functions/query.md) — runs SQL-like query on data range
- [QUOTIENT](https://deepcalc.com/functions/quotient.md) — integer portion of a division
- [RADIANS](https://deepcalc.com/functions/radians.md) — converts degrees to radians
- [RAND](https://deepcalc.com/functions/rand.md) — returns a random number between 0 and 1
- [RANDARRAY](https://deepcalc.com/functions/randarray.md) — returns an array of random numbers
- [RANDBETWEEN](https://deepcalc.com/functions/randbetween.md) — returns random integer between two values
- [RANDOMCHOICE](https://deepcalc.com/functions/randomchoice.md) — random pick from a range (with replacement); count > 1 spills a column
- [RANDOMINT.UNIQUE](https://deepcalc.com/functions/randomint-unique.md) — generates unique random integers in range
- [RANDOMNORMAL](https://deepcalc.com/functions/randomnormal.md) — generates random values from normal distribution
- [RANK](https://deepcalc.com/functions/rank.md) — legacy form of RANK.EQ: rank of a number in a list
- [RANK.AVG](https://deepcalc.com/functions/rank-avg.md) — rank of a number, average rank for ties
- [RANK.EQ](https://deepcalc.com/functions/rank-eq.md) — rank of a number, top rank for ties
- [RATE](https://deepcalc.com/functions/rate.md) — returns interest rate per period
- [RECEIVED](https://deepcalc.com/functions/received.md) — amount received at maturity for a fully invested security
- [REDUCE](https://deepcalc.com/functions/reduce.md) — reduces array to value with lambda
- [REGEXEXTRACT](https://deepcalc.com/functions/regexextract.md) — extracts the first regex match
- [REGEXREPLACE](https://deepcalc.com/functions/regexreplace.md) — replaces regex matches with new text
- [REGEXTEST](https://deepcalc.com/functions/regextest.md) — whether text matches a regular expression
- [REPLACE](https://deepcalc.com/functions/replace.md) — replaces characters by position
- [REPLACEB](https://deepcalc.com/functions/replaceb.md) — replaces characters by byte position
- [REPT](https://deepcalc.com/functions/rept.md) — repeats text a given number of times
- [RHO.CALL](https://deepcalc.com/functions/rho-call.md) — rho of call option (sensitivity to interest rate)
- [RHO.PUT](https://deepcalc.com/functions/rho-put.md) — rho of put option (sensitivity to interest rate)
- [RIGHT](https://deepcalc.com/functions/right.md) — returns rightmost characters from text
- [RIGHTB](https://deepcalc.com/functions/rightb.md) — returns rightmost bytes from text
- [ROMAN](https://deepcalc.com/functions/roman.md) — converts arabic number to roman numeral
- [ROUND](https://deepcalc.com/functions/round.md) — rounds a number to specified digits
- [ROUNDDOWN](https://deepcalc.com/functions/rounddown.md) — rounds a number down toward zero
- [ROUNDUP](https://deepcalc.com/functions/roundup.md) — rounds a number up away from zero
- [ROW](https://deepcalc.com/functions/row.md) — returns row number of a reference
- [ROWS](https://deepcalc.com/functions/rows.md) — returns number of rows in a reference
- [RRI](https://deepcalc.com/functions/rri.md) — returns equivalent interest rate for growth
- [RSQ](https://deepcalc.com/functions/rsq.md) — square of the Pearson correlation coefficient
- [SCAN](https://deepcalc.com/functions/scan.md) — scans array with lambda keeping intermediates
- [SEARCH](https://deepcalc.com/functions/search.md) — finds text within another text, case-insensitive
- [SEARCHB](https://deepcalc.com/functions/searchb.md) — finds text within text by bytes, case-insensitive
- [SEC](https://deepcalc.com/functions/sec.md) — returns secant of an angle
- [SECH](https://deepcalc.com/functions/sech.md) — returns hyperbolic secant
- [SECOND](https://deepcalc.com/functions/second.md) — returns second component of a time
- [SEQUENCE](https://deepcalc.com/functions/sequence.md) — generates a sequence of numbers as an array
- [SERIESSUM](https://deepcalc.com/functions/seriessum.md) — returns the sum of a power series
- [SHEET](https://deepcalc.com/functions/sheet.md) — returns sheet number of a reference
- [SHEETS](https://deepcalc.com/functions/sheets.md) — number of sheets in a reference
- [SIGN](https://deepcalc.com/functions/sign.md) — sign of a number as -1, 0 or 1
- [SIN](https://deepcalc.com/functions/sin.md) — returns sine of an angle
- [SINH](https://deepcalc.com/functions/sinh.md) — returns hyperbolic sine
- [SKEW](https://deepcalc.com/functions/skew.md) — returns the skewness of a distribution
- [SKEW.P](https://deepcalc.com/functions/skew-p.md) — skewness based on the entire population
- [SLN](https://deepcalc.com/functions/sln.md) — returns straight-line depreciation per period
- [SLOPE](https://deepcalc.com/functions/slope.md) — slope of the linear regression line
- [SMALL](https://deepcalc.com/functions/small.md) — returns the k-th smallest value in a data set
- [SORT](https://deepcalc.com/functions/sort.md) — sorts the contents of a range or array
- [SORTBY](https://deepcalc.com/functions/sortby.md) — sorts a range or array by values in a corresponding range
- [SPLIT](https://deepcalc.com/functions/split.md) — splits text by delimiter into multiple cells
- [SQRT](https://deepcalc.com/functions/sqrt.md) — returns square root of a number
- [SQRTPI](https://deepcalc.com/functions/sqrtpi.md) — returns square root of number times pi
- [STANDARDIZE](https://deepcalc.com/functions/standardize.md) — normalized value from a distribution
- [STARTSWITH](https://deepcalc.com/functions/startswith.md) — checks if text starts with prefix
- [STDEV](https://deepcalc.com/functions/stdev.md) — legacy form of STDEV.S: sample standard deviation
- [STDEV.P](https://deepcalc.com/functions/stdev-p.md) — population standard deviation
- [STDEV.S](https://deepcalc.com/functions/stdev-s.md) — sample standard deviation
- [STDEVA](https://deepcalc.com/functions/stdeva.md) — sample standard deviation, counting text and logicals
- [STDEVP](https://deepcalc.com/functions/stdevp.md) — legacy form of STDEV.P: population standard deviation
- [STDEVPA](https://deepcalc.com/functions/stdevpa.md) — population standard deviation, counting text and logicals
- [STEYX](https://deepcalc.com/functions/steyx.md) — standard error of the predicted y for each x
- [SUBSTITUTE](https://deepcalc.com/functions/substitute.md) — replaces old text with new text
- [SUBTOTAL](https://deepcalc.com/functions/subtotal.md) — returns subtotal using specified function
- [SUM](https://deepcalc.com/functions/sum.md) — adds numbers together
- [SUMIF](https://deepcalc.com/functions/sumif.md) — sums cells that match a condition
- [SUMIFS](https://deepcalc.com/functions/sumifs.md) — sums cells that match multiple conditions
- [SUMPRODUCT](https://deepcalc.com/functions/sumproduct.md) — returns sum of products of array components
- [SUMSQ](https://deepcalc.com/functions/sumsq.md) — sum of the squares of the arguments
- [SUMX2MY2](https://deepcalc.com/functions/sumx2my2.md) — sum of the difference of squares of two ranges
- [SUMX2PY2](https://deepcalc.com/functions/sumx2py2.md) — sum of the sum of squares of two ranges
- [SUMXMY2](https://deepcalc.com/functions/sumxmy2.md) — sum of squared differences of two ranges
- [SWITCH](https://deepcalc.com/functions/switch.md) — evaluates expression against list of values
- [SYD](https://deepcalc.com/functions/syd.md) — returns sum-of-years-digits depreciation
- [T](https://deepcalc.com/functions/t.md) — returns text if value is text, else empty
- [T.DIST](https://deepcalc.com/functions/t-dist.md) — Student's t-distribution
- [T.DIST.2T](https://deepcalc.com/functions/t-dist-2t.md) — two-tailed Student's t-distribution
- [T.DIST.RT](https://deepcalc.com/functions/t-dist-rt.md) — right-tailed Student's t-distribution
- [T.INV](https://deepcalc.com/functions/t-inv.md) — left-tailed inverse of the t-distribution
- [T.INV.2T](https://deepcalc.com/functions/t-inv-2t.md) — two-tailed inverse of the t-distribution
- [T.TEST](https://deepcalc.com/functions/t-test.md) — probability from Student's t-test
- [TABLEJOIN](https://deepcalc.com/functions/tablejoin.md) — inner-joins two ranges on a key column in each
- [TAKE](https://deepcalc.com/functions/take.md) — returns rows or columns from the start or end of an array
- [TAN](https://deepcalc.com/functions/tan.md) — returns tangent of an angle
- [TANH](https://deepcalc.com/functions/tanh.md) — returns hyperbolic tangent
- [TBILLEQ](https://deepcalc.com/functions/tbilleq.md) — returns bond-equivalent yield for treasury bill
- [TBILLPRICE](https://deepcalc.com/functions/tbillprice.md) — returns price per $100 for treasury bill
- [TBILLYIELD](https://deepcalc.com/functions/tbillyield.md) — returns yield for a treasury bill
- [TDIST](https://deepcalc.com/functions/tdist.md) — legacy form of T.DIST.RT / T.DIST.2T
- [TEXT](https://deepcalc.com/functions/text.md) — formats number as text with given format
- [TEXTAFTER](https://deepcalc.com/functions/textafter.md) — returns text after a delimiter
- [TEXTBEFORE](https://deepcalc.com/functions/textbefore.md) — returns text before a delimiter
- [TEXTCAPITALIZE](https://deepcalc.com/functions/textcapitalize.md) — capitalizes first letter of text
- [TEXTCENTER](https://deepcalc.com/functions/textcenter.md) — centers text with padding to reach specified length
- [TEXTCOMPARE](https://deepcalc.com/functions/textcompare.md) — compares two texts and returns -1, 0, or 1
- [TEXTCOUNT](https://deepcalc.com/functions/textcount.md) — counts occurrences of substring in text
- [TEXTINDENT](https://deepcalc.com/functions/textindent.md) — indents text with specified number of characters
- [TEXTJOIN](https://deepcalc.com/functions/textjoin.md) — joins text with delimiter, ignoring blanks
- [TEXTPADLEFT](https://deepcalc.com/functions/textpadleft.md) — pads text on the left with character to reach specified length
- [TEXTPADRIGHT](https://deepcalc.com/functions/textpadright.md) — pads text on the right with character to reach specified length
- [TEXTREVERSE](https://deepcalc.com/functions/textreverse.md) — reverses text
- [TEXTSPLIT](https://deepcalc.com/functions/textsplit.md) — splits text by delimiters into an array
- [TEXTSWAPCASE](https://deepcalc.com/functions/textswapcase.md) — swaps uppercase and lowercase letters
- [TEXTTITLE](https://deepcalc.com/functions/texttitle.md) — converts text to title case
- [TEXTWRAP](https://deepcalc.com/functions/textwrap.md) — wraps text at specified width
- [THETA.CALL](https://deepcalc.com/functions/theta-call.md) — theta of call option (time decay)
- [THETA.PUT](https://deepcalc.com/functions/theta-put.md) — theta of put option (time decay)
- [TIME](https://deepcalc.com/functions/time.md) — creates time from hour, minute, second
- [TIMESTAMP](https://deepcalc.com/functions/timestamp.md) — current timestamp in milliseconds since epoch
- [TIMEVALUE](https://deepcalc.com/functions/timevalue.md) — converts time text to serial number
- [TINV](https://deepcalc.com/functions/tinv.md) — legacy form of T.INV.2T
- [TOARRAY](https://deepcalc.com/functions/toarray.md) — materializes a range as a dynamic array (spills)
- [TOBOOL](https://deepcalc.com/functions/tobool.md) — converts value to boolean
- [TOCOL](https://deepcalc.com/functions/tocol.md) — returns an array as a single column
- [TODATE](https://deepcalc.com/functions/todate.md) — parses text (YYYY-M-D, YYYY/M/D, M/D/YYYY, D.M.YYYY) to a date serial
- [TODAY](https://deepcalc.com/functions/today.md) — returns current date
- [TONUMBER](https://deepcalc.com/functions/tonumber.md) — converts value to number; unparseable text returns default when given, else #VALUE!
- [TOROW](https://deepcalc.com/functions/torow.md) — returns an array as a single row
- [TOTEXT](https://deepcalc.com/functions/totext.md) — converts value to text representation
- [TOTIME](https://deepcalc.com/functions/totime.md) — parses \"HH:MM\" or \"HH:MM:SS\" text to a time fraction of day
- [TRANSPOSE](https://deepcalc.com/functions/transpose.md) — flips the orientation of a range or array
- [TREND](https://deepcalc.com/functions/trend.md) — values along a linear trend
- [TRIM](https://deepcalc.com/functions/trim.md) — removes extra spaces from text
- [TRIMMEAN](https://deepcalc.com/functions/trimmean.md) — mean of the interior of a data set
- [TRIMRANGE](https://deepcalc.com/functions/trimrange.md) — trims empty rows and columns from the edges of a range
- [TRUE](https://deepcalc.com/functions/true.md) — returns the logical value TRUE
- [TRUNC](https://deepcalc.com/functions/trunc.md) — truncates a number to a given precision
- [TTEST](https://deepcalc.com/functions/ttest.md) — legacy form of T.TEST
- [TYPE](https://deepcalc.com/functions/type.md) — returns type of a value as number
- [UNICHAR](https://deepcalc.com/functions/unichar.md) — returns the character for a unicode code point
- [UNICODE](https://deepcalc.com/functions/unicode.md) — returns unicode number of first character
- [UNIQUE](https://deepcalc.com/functions/unique.md) — returns the distinct values from a range or array
- [UPPER](https://deepcalc.com/functions/upper.md) — converts text to uppercase
- [UUID](https://deepcalc.com/functions/uuid.md) — generates UUID v4 string
- [VALIDATE.DATE](https://deepcalc.com/functions/validate-date.md) — validates date components form valid date
- [VALIDATE.EMAIL](https://deepcalc.com/functions/validate-email.md) — validates email address format
- [VALIDATE.PHONE](https://deepcalc.com/functions/validate-phone.md) — validates phone number format
- [VALIDATE.RANGE](https://deepcalc.com/functions/validate-range.md) — validates value is within min and max range
- [VALIDATE.URL](https://deepcalc.com/functions/validate-url.md) — validates URL format
- [VALUE](https://deepcalc.com/functions/value.md) — converts text string to a number
- [VALUETOTEXT](https://deepcalc.com/functions/valuetotext.md) — returns text from any value type
- [VAR](https://deepcalc.com/functions/var.md) — legacy form of VAR.S: sample variance
- [VAR.P](https://deepcalc.com/functions/var-p.md) — population variance
- [VAR.S](https://deepcalc.com/functions/var-s.md) — sample variance
- [VARA](https://deepcalc.com/functions/vara.md) — sample variance, counting text and logicals
- [VARP](https://deepcalc.com/functions/varp.md) — legacy form of VAR.P: population variance
- [VARPA](https://deepcalc.com/functions/varpa.md) — population variance, counting text and logicals
- [VDB](https://deepcalc.com/functions/vdb.md) — depreciation over a period, declining balance with switch
- [VLOOKUP](https://deepcalc.com/functions/vlookup.md) — looks up value in first column of range and returns value from specified column
- [VSTACK](https://deepcalc.com/functions/vstack.md) — stacks arrays on top of each other into one array
- [WEEKDAY](https://deepcalc.com/functions/weekday.md) — returns day of week as a number
- [WEEKNUM](https://deepcalc.com/functions/weeknum.md) — returns week number of a date
- [WEIBULL](https://deepcalc.com/functions/weibull.md) — legacy form of WEIBULL.DIST
- [WEIBULL.DIST](https://deepcalc.com/functions/weibull-dist.md) — Weibull distribution
- [WORKDAY](https://deepcalc.com/functions/workday.md) — returns date after given business days
- [WORKDAY.INTL](https://deepcalc.com/functions/workday-intl.md) — adds business days with custom weekend
- [WRAPCOLS](https://deepcalc.com/functions/wrapcols.md) — wraps a row or column into a 2-D array by columns
- [WRAPROWS](https://deepcalc.com/functions/wraprows.md) — wraps a row or column into a 2-D array by rows
- [XIRR](https://deepcalc.com/functions/xirr.md) — returns internal rate for irregular cash flows
- [XLOOKUP](https://deepcalc.com/functions/xlookup.md) — searches range and returns matching item
- [XMATCH](https://deepcalc.com/functions/xmatch.md) — returns the position of an item in a range or array
- [XNPV](https://deepcalc.com/functions/xnpv.md) — returns net present value for irregular cash flows
- [XOR](https://deepcalc.com/functions/xor.md) — returns exclusive or of all arguments
- [YEAR](https://deepcalc.com/functions/year.md) — returns year component of a date
- [YEARFRAC](https://deepcalc.com/functions/yearfrac.md) — returns fraction of year between dates
- [YIELD](https://deepcalc.com/functions/yield.md) — returns the yield of a security paying periodic interest
- [YIELDDISC](https://deepcalc.com/functions/yielddisc.md) — annual yield of a discounted security
- [YIELDMAT](https://deepcalc.com/functions/yieldmat.md) — annual yield of a security paying interest at maturity
- [Z.TEST](https://deepcalc.com/functions/z-test.md) — one-tailed p-value of a z-test
- [ZTEST](https://deepcalc.com/functions/ztest.md) — legacy form of Z.TEST

source: https://deepcalc.com/functions