# deepcalc function reference

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

## categories

- [array](https://deepcalc.com/docs/functions/array-functions.md) (33): Work on whole ranges at once and return multiple values.
- [database](https://deepcalc.com/docs/functions/database-functions.md) (15): Group, aggregate and query tabular ranges.
- [datetime](https://deepcalc.com/docs/functions/datetime-functions.md) (26): Build, read and do arithmetic on dates and times.
- [engineering](https://deepcalc.com/docs/functions/engineering-functions.md) (58): Unit conversion, bases, complex numbers and bitwise operations.
- [financial](https://deepcalc.com/docs/functions/financial-functions.md) (56): Interest, cash flow, depreciation and valuation.
- [information](https://deepcalc.com/docs/functions/information-functions.md) (24): Ask what a cell holds: type, emptiness, errors.
- [logical](https://deepcalc.com/docs/functions/logical-functions.md) (18): Branch and combine conditions.
- [lookup](https://deepcalc.com/docs/functions/lookup-functions.md) (14): Find a value in a range and return a related one.
- [math](https://deepcalc.com/docs/functions/math-functions.md) (94): Arithmetic, rounding, trigonometry and aggregation.
- [options](https://deepcalc.com/docs/functions/options-functions.md) (20): Option pricing and the greeks. deepcalc originals, no Excel equivalent.
- [stats](https://deepcalc.com/docs/functions/stats-functions.md) (149): Distributions, averages, spread and regression.
- [text](https://deepcalc.com/docs/functions/text-functions.md) (63): Join, split, clean, search and format strings.
- [utility](https://deepcalc.com/docs/functions/utility-functions.md) (27): Helpers that do not belong to one calculation domain.
- [web](https://deepcalc.com/docs/functions/web-functions.md) (5): Fetch and parse data from outside the sheet.

## functions

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

source: https://deepcalc.com/docs/functions