Function Explorer

Browse every Instacalc function with a live, runnable example of each.

Instacalc has hundreds of built-in functions — math, statistics, finance, dates, text, and more. This is the complete, browsable index.

Search or scroll the list, pick a function, and the example on the right actually runs — edit its inputs and watch the result update. Every entry is generated from the engine’s own function table, so the list is always complete.

277 of 277 functions

cbrt

Basic Arithmetic also cuberoot, roots & powers
cbrt(

Roots & Powers

Computing…

Full function list

Every function in one place — searchable with your browser’s Find (⌘/Ctrl-F) and linkable by anchor.

Basic Arithmetic

cbrt also cuberoot, roots & powers

Roots & Powers

cbrt(27)
modulo also modulus

Modulo

modulo(17, 5)
sqrt also roots & powers

Roots & Powers

sqrt(9)

Variables & Rows

avg also average, mean, row references

Row References

avg([10, 20, 30])
max also row references

Row References

max(r1:r3)
min also row references

Row References

min(r1:r3)
sum also add, total, subtotal, row references

Row References

sum(r1:r3)

Formatting

time also display formats

Display Formats

time(2)

Units & Conversions

c also combination, combinations, combin, comb, ncr

SI Units

c(2)
conversion also convert units

Convert Units

conversion(2)
convert also convert units

Convert Units

convert(2)
len also length, length

Length

len([4, 5, 6])
stock also stock lookup

Stock Lookup

stock(2)

Scientific

acos also arccos, arccosine, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

acos(0.5)
acosh also inverse hyperbolic

Inverse Hyperbolic

acosh(1)
acot also arccot, arccotangent, inverse trig, return degrees by default

Inverse Trig — return degrees by default

acot(1)
acoth also inverse hyperbolic

Inverse Hyperbolic

acoth(2)
acsc also arccsc, arccosecant, inverse trig, return degrees by default

Inverse Trig — return degrees by default

acsc(2)
acsch also inverse hyperbolic

Inverse Hyperbolic

acsch(1)
angle also complex numbers

Complex Numbers

angle(2)
asec also arcsec, arcsecant, inverse trig, return degrees by default

Inverse Trig — return degrees by default

asec(2)
asech also inverse hyperbolic

Inverse Hyperbolic

asech(0.5)
asin also arcsin, arcsine, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

asin(0.5)
asinh also inverse hyperbolic

Inverse Hyperbolic

asinh(1)
atan also arctan, arctangent, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

atan(1)
atan2 also inverse trig, return degrees by default

Inverse Trig — return degrees by default

atan2(1, 1)
atanh also inverse hyperbolic

Inverse Hyperbolic

atanh(0.5)
conj also conjugate, complex numbers

Complex Numbers

conj(3+4i)
cos also cosine, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

cos(2)
cosh also trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

cosh(1)
cot also cotangent, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

cot(2)
coth also hyperbolic trig

Hyperbolic Trig

coth(1)
csc also cosecant, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

csc(2)
csch also hyperbolic trig

Hyperbolic Trig

csch(1)
exp also exponents and logs

Exponents and Logs

exp(2)
ln also logarithm, exponents and logs

Exponents and Logs

ln(2)
log also exponents and logs

Exponents and Logs

log(2)
log10 also exponents and logs

Exponents and Logs

log10(1000)
sec also secant, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

sec(2)
sech also hyperbolic trig

Hyperbolic Trig

sech(1)
sin also sine, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

sin(30)
sinh also trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

sinh(1)
tan also tangent, trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

tan(2)
tanh also trig functions, degrees by default, use 'rad' for radians

Trig Functions — degrees by default, use 'rad' for radians

tanh(1)

Other Math

abs also absolute value

Absolute Value

abs(-2)
bias also shaping & blending

Shaping & Blending

bias(0.5, 0.7)
ceil also ceiling, roundup, rounding

Rounding

ceil(3.2)
clamp

Clamp

clamp(15, 0, 10)
cube also cubic, power & roots

Power & Roots

cube(3)
deg also degrees / radians, convert angles

Degrees / Radians — convert angles

deg(2)
divide also quotient, arithmetic helpers, functional aliases for operators

Arithmetic Helpers — functional aliases for operators

divide(10, 4)
erf also error function

Error Function

erf(1)
erfinverse also error function

Error Function

erfinverse(0.8427)
fac also factorial, factorial

Factorial

fac(2)
fbm also noise & terrain

Noise & Terrain

fbm(2)
fib also fibonacci, fibonacci

Fibonacci

fib(10)
floor also rounddown, rounding

Rounding

floor(3.7)
gain also shaping & blending

Shaping & Blending

gain(0.7, 0.8)
gcd also gcd / lcm

GCD / LCM

gcd(12, 18)
hypot also power & roots

Power & Roots

hypot(3, 4)
int also truncate, trunc, integer, rounding

Rounding

int(2)
invert also inverse, arithmetic helpers, functional aliases for operators

Arithmetic Helpers — functional aliases for operators

invert(4)
lcm also gcd / lcm

GCD / LCM

lcm(4, 6)
lerp also shaping & blending

Shaping & Blending

lerp(2)
log1p also log variants

Log Variants

log1p(1)
log2 also log variants

Log Variants

log2(8)
mix also shaping & blending

Shaping & Blending

mix(10, 20, 0.3)
noise also noise & terrain

Noise & Terrain

noise(x, y, 7)
pow also power, power & roots

Power & Roots

pow(2, 10)
rad also degrees / radians, convert angles

Degrees / Radians — convert angles

rad(180)
rand also random, random numbers

Random Numbers

rand(2)
remap also shaping & blending

Shaping & Blending

remap(0, -1, 1, 0, 100)
ridge also noise & terrain

Noise & Terrain

ridge(2)
roots also equation roots

Equation Roots

roots(x^2 - 4)
round also rounding

Rounding

round(3.51)
sigfig also sigfigs, rounding

Rounding

sigfig(123.456, 2)
sign

Sign

sign(-5)
smoothstep also shaping & blending

Shaping & Blending

smoothstep(0, 1, 0.25)
square also power & roots

Power & Roots

square(5)
sub also arithmetic helpers, functional aliases for operators

Arithmetic Helpers — functional aliases for operators

sub(10, 3)
subtract also arithmetic helpers, functional aliases for operators

Arithmetic Helpers — functional aliases for operators

subtract(10, 3)
turbulence also noise & terrain

Noise & Terrain

turbulence(2)
voronoi also noise & terrain

Noise & Terrain

voronoi(2)
worley also noise & terrain

Noise & Terrain

worley(2)

Base Conversion

bin also to decimal

To Decimal

bin(2)
dec also to decimal

To Decimal

dec(2)
frombin also parse binary / octal, string input

Parse Binary / Octal — string input

frombin("1010")
fromoct also parse binary / octal, string input

Parse Binary / Octal — string input

fromoct("17")
hex also to decimal

To Decimal

hex(2)
oct also to decimal

To Decimal

oct(2)

Programming

if also conditionals, if/else

Conditionals — if/else

if (3 > 2) { "bigger" } else { "smaller or equal" }

Arrays & Objects

filter also array transforms, use x => expr arrow syntax for lambdas

Array Transforms — use x => expr arrow syntax for lambdas

filter([1,2,3,4,5], x
find also array access

Array Access

find([1,2,3], x
first also array access

Array Access

first([10,20,30])
function also functions

Functions

function(2)
last also array access

Array Access

last([10,20,30])
map also array transforms, use x => expr arrow syntax for lambdas

Array Transforms — use x => expr arrow syntax for lambdas

map([1,2,3], x
reduce also array transforms, use x => expr arrow syntax for lambdas

Array Transforms — use x => expr arrow syntax for lambdas

reduce([1,2,3,4], (acc,x)
reverse also array transforms, use x => expr arrow syntax for lambdas

Array Transforms — use x => expr arrow syntax for lambdas

reverse([1,2,3])
seq also sequence, sequence, seq(count, [start=1], [step=1])

Sequence — seq(count, [start=1], [step=1])

seq(5)
sort also array transforms, use x => expr arrow syntax for lambdas

Array Transforms — use x => expr arrow syntax for lambdas

sort([3,1,2])

Excel Financial

fv also future value

Future Value

FV(0.05/12, 120, -100)
ipmt also interest payment

Interest Payment

IPMT(0.05/12, 1, 360, -250000)
irr also internal rate of return

Internal Rate of Return

irr([-100, 60, 60])
ispmt also interest (specific period)

Interest (Specific Period)

ISPMT(0.05/12, 1, 360, 250000)
nper also number of periods

Number of Periods

NPER(0.05/12, -500, 10000)
npv also net present value

Net Present Value

NPV(rate, r1:r5)
pduration also duration

Duration

PDURATION(0.05, 1000, 2000)
pmt also loan payment

Loan Payment

PMT(0.05/12, 360, -250000)
ppmt also principal payment

Principal Payment

PPMT(0.05/12, 1, 360, -250000)
pv also present value

Present Value

PV(0.05/12, 120, 100)
rate also interest rate

Interest Rate

rate(2)
rri also rate of return

Rate of Return

rri(2)

Excel Statistical

cagr

CAGR

cagr(1000, 2000, 5)
correl also correlation, correlation

Correlation

correl(r1:r3, r4:r6)
count also counta

Count

count(r1:r3)
covar also covariance, covar.s, covariance.s, covariance

Covariance

covar(r1:r3, r4:r6)
covar.p also covariance.p, covariance

Covariance

covar.p(r1:r3, r4:r6)
forecast also regression

Regression

forecast(5, [10,20,30,40], [1,2,3,4])
geomean also geometric mean

Geometric Mean

geomean([2, 8, 32])
intercept also regression

Regression

intercept([10,20,30], [1,2,3])
kurt also kurtosis, kurtosis

Kurtosis

kurt([1,2,3,4,5])
linest also regression

Regression

linest([10,20,30], [1,2,3])
median also mean/median/mode

Mean/Median/Mode

median(r1:r3)
mode also mean/median/mode

Mean/Median/Mode

mode(r1:r3)
p also permutation, permutations, permut, perm, npr

Covariance

p(2)
percentile

Percentile

percentile(r1:r3, p)
percentrank also percent rank

Percent Rank

percentrank([1,2,3,4,5], 3)
prod also product, multiply, product

Product

prod(2)
range

Range

range(r1:r3)
skew also skewness, skewness

Skewness

skew([1,2,3,4,5])
slope also regression

Regression

slope([10,20,30], [1,2,3])
std also stddev, stdev, stdev.s, stddev.s, standard deviation

Standard Deviation

std(2)
stdev.p also stddev.p, std dev (population)

Std Dev (Population)

stdev.p([1,2,3,4,5])
var also variance, var.s, variance

Variance

var(r1:r3)
var.p also variance (population)

Variance (Population)

var.p([1,2,3,4,5])

Statistical Distributions

betadist also beta.dist, beta

Beta

betadist(0.5, 2, 3, false)
binomdist also binom.dist, binomial

Binomial

binomdist(2, 10, 0.5, false)
chisqdist also chisq.dist, chi-squared

Chi-Squared

chisqdist(3, 2)
chisqdistrt also chisq.dist.rt, chi-squared

Chi-Squared

chisqdistrt(3, 2)
chisqinv also chisq.inv, chi-squared

Chi-Squared

chisqinv(0.5, 2)
chisqinvrt also chisq.inv.rt, chi-squared

Chi-Squared

chisqinvrt(0.5, 2)
confidence also confidence interval

Confidence Interval

confidence(0.05, 2, 50)
fdist also f.dist, f distribution

F Distribution

fdist(2, 5, 10)
fdistrt also f.dist.rt, f distribution

F Distribution

fdistrt(2, 5, 10)
finv also f.inv, f distribution

F Distribution

finv(0.5, 5, 10)
finvrt also f.inv.rt, f distribution

F Distribution

finvrt(0.5, 5, 10)
gamma

Gamma

gamma(5)
gammadist also gamma.dist, gamma

Gamma

gammadist(2, 3, 1, false)
hypgeomdist also hypgeom.dist, hypergeometric

Hypergeometric

hypgeomdist(2, 5, 10, 20)
lognormdist also lognorm.dist, log-normal

Log-Normal

lognormdist(1, 0, 1, false)
lognorminv also lognorm.inv, log-normal

Log-Normal

lognorminv(0.5, 0, 1)
negbinomdist also negbinom.dist, binomial

Binomial

negbinomdist(2, 5, 0.5)
normdist also norm.dist, normal

Normal

normdist(1, 0, 1, false)
norminv also norm.inv, normal

Normal

norminv(0.8413, 0, 1)
normsdist also norm.s.dist, normal (standard)

Normal (Standard)

normsdist(1)
normsinv also norm.s.inv, normal (standard)

Normal (Standard)

normsinv(0.8413)
poissondist also poisson.dist, poisson

Poisson

poissondist(2, 3, false)
tdist also t.dist, t distribution

T Distribution

tdist(2, 10)
tdist2t also t.dist.2t, t distribution

T Distribution

tdist2t(2, 10)
tdistrt also t.dist.rt, t distribution

T Distribution

tdistrt(2, 10)
tinv also t.inv, t distribution

T Distribution

tinv(0.05, 10)
tinvt2t also t.inv.2t, t distribution

T Distribution

tinvt2t(0.05, 10)
ttest also t.test, t-test

T-Test

ttest(array1, array2, tails, type)
weibulldist also weibull.dist, weibull

Weibull

weibulldist(2, 1, 2, false)
ztest also z.test, z-test

Z-Test

ztest([1,2,3,4,5], 2)

Import & Sync

calc also import calc

Import Calc

calc("https://instacalc.com/12345")
import also import json

Import JSON

import(2)

String Functions

append also build & combine

Build & Combine

append([1,2], 3)
charat also extract & slice

Extract & Slice

charat("hello", 1)
combine also build & combine

Build & Combine

combine([1,2],[3,4])
concat also concatenate, build & combine

Build & Combine

concat(2)
contains also search & test

Search & Test

contains(2)
endswith also search & test

Search & Test

endswith(2)
fromhex also hex parsing

Hex Parsing

fromhex(2)
indexof also search & test

Search & Test

indexof(2)
join also build & combine

Build & Combine

join([1,2,3], "-")
lower also tolowercase, case & whitespace

Case & Whitespace

lower(2)
padend also pad & replace

Pad & Replace

padend("5", 3, "0")
padstart also pad & replace

Pad & Replace

padstart("5", 3, "0")
replace also substitute, pad & replace

Pad & Replace

replace(2)
rept also repeat, build & combine

Build & Combine

rept(2)
split also textsplit, extract & slice

Extract & Slice

split(2)
startswith also search & test

Search & Test

startswith(2)
substr also extract & slice

Extract & Slice

substr("hello world", 6)
substring also extract & slice

Extract & Slice

substring("hello world", 0, 5)
trim also case & whitespace

Case & Whitespace

trim(2)
upper also touppercase, case & whitespace

Case & Whitespace

upper(2)

Linear Algebra

cross also vectors

Vectors

cross([1,0,0],[0,1,0])
det also determinant, matrices

Matrices

det([[1,2],[3,4]])
dot also vectors

Vectors

dot([1,2,3],[4,5,6])
eig also eigenvalues, eigenvalues

Eigenvalues

eig([[2,0],[0,3]])
eigenvectors also eigenvalues

Eigenvalues

eigenvectors([[2,0],[0,3]])
eye also identity, special matrices & vectors

Special Matrices & Vectors

eye(3)
inv also inverse_matrix, minverse, matrices

Matrices

inv([[1,2],[3,4]])
mag also magnitude, vectors

Vectors

mag([3,4])
mmult also matmul, matrices

Matrices

mmult([[1,2],[3,4]],[[5,6],[7,8]])
norm also vectors

Vectors

norm(2)
proj also project, vectors

Vectors

proj([1,1],[1,0])
quat also quaternion, quaternions & rotation

Quaternions & Rotation

quat(1,2,3,4)
rank also matrices

Matrices

rank([[1,2],[2,4]])
rotate also quaternions & rotation

Quaternions & Rotation

rotate([1,0,0], [0,0,1], 90)
trace also matrices

Matrices

trace([[1,2],[3,4]])
transpose also matrices

Matrices

transpose([[1,2],[3,4]])
unitvec also normalize, unitvector, vectors

Vectors

unitvec([3,4])
vec also vectors

Vectors

vec(1,2,3)
zeros also special matrices & vectors

Special Matrices & Vectors

zeros(3)

Calculus & Transforms

convergencetest also sums, products & series

Sums, Products & Series

convergencetest("1/k^2", "k", "1")
convolvefor also integral transforms

Integral Transforms

convolvefor(2)
curlfor also vector field operators

Vector Field Operators

curlfor(2)
defintegralfor also derivatives & integrals

Derivatives & Integrals

defintegralfor("x^2", "0", "1")
diff also derive, derivative, differentiate, deriv, derivatives & integrals

Derivatives & Integrals

diff(x^2, 3)
divfor also vector field operators

Vector Field Operators

divfor(2)
doubleintegralfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

doubleintegralfor("x*y", "x", "y", 0, 1, 0, 1)
fluxfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

fluxfor("[x,y]", "[cos(t),sin(t)]", 0, 6.283)
fourierfor also integral transforms

Integral Transforms

fourierfor(2)
gradfor also vector field operators

Vector Field Operators

gradfor(x^2+y^2)
integral also integrate, antideriv, antiderivative, derivatives & integrals

Derivatives & Integrals

integral(x^2, 0, 1)
invlaplacefor also integral transforms

Integral Transforms

invlaplacefor("1/(s-2)", "s", "t")
laplacefor also integral transforms

Integral Transforms

laplacefor("sin(2*t)", "t", "s")
laplacianfor also vector field operators

Vector Field Operators

laplacianfor(x^2+y^2)
limitfor also sums, products & series

Sums, Products & Series

limitfor("sin(x)/x", "x", "0", "both")
lineintegralfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

lineintegralfor("[y,-x]", "[cos(t),sin(t)]", 0, 6.283)
odesolve2for also odes

ODEs

odesolve2for("-y", "x", "y", "v", 0, 1, 0, 1)
odesolvefor also odes

ODEs

odesolvefor("y", "x", "y", 0, 1, 1)
productfor also sums, products & series

Sums, Products & Series

productfor("k", "k", "1", "5")
scalarlineintegralfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

scalarlineintegralfor("x+y", "[t,t]", 0, 1)
seriesfor also sums, products & series

Sums, Products & Series

seriesfor("sin(x)", "x", 5, "0")
sumfor also sums, products & series

Sums, Products & Series

sumfor("k^2", "k", "1", "5")
surfacefluxfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

surfacefluxfor("[0,0,1]", "[u,v,0]", 0, 1, 0, 1)
tripleintegralfor also line, flux & multiple integrals

Line, Flux & Multiple Integrals

tripleintegralfor("x*y*z", "x","y","z", 0,1, 0,1, 0,1)
ztransformfor also integral transforms

Integral Transforms

ztransformfor("2^n", "n", "z")

Regression & Curve Fitting

expfit also exponential, log & power fit

Exponential, Log & Power Fit

expfit(2)
expfitcoeffs also exponential, log & power fit

Exponential, Log & Power Fit

expfitcoeffs([1,2,3],[2,4,8])
interp also interpolation

Interpolation

interp(1.5, [0,1,2], [0,1,4])
linreg also linear regression

Linear Regression

linreg([1,2,3],[2,4,6])
linregcoeffs also linear regression

Linear Regression

linregcoeffs([1,2,3],[2,4,6])
logfit also exponential, log & power fit

Exponential, Log & Power Fit

logfit(2)
logfitcoeffs also exponential, log & power fit

Exponential, Log & Power Fit

logfitcoeffs([1,2,3],[0,0.69,1.1])
polyfit also polynomial fit

Polynomial Fit

polyfit([1,2,3],[1,4,9],2)
polyfitcoeffs also polynomial fit

Polynomial Fit

polyfitcoeffs([1,2,3],[1,4,9],2)
powfit also exponential, log & power fit

Exponential, Log & Power Fit

powfit(2)
powfitcoeffs also exponential, log & power fit

Exponential, Log & Power Fit

powfitcoeffs([1,2,3],[1,4,9])
rsq also linear regression

Linear Regression

rsq([1,2,3],[2,4,6],1)
rsquared also linear regression

Linear Regression

rsquared(2)
spline also interpolation

Interpolation

spline([0,1,2],[0,1,4])

Symbolic Algebra

divisors also number theory

Number Theory

divisors(12)
expand also expand, factor & simplify

Expand, Factor & Simplify

expand (x+1)^2
factor also factorize, factorise, expand, factor & simplify

Expand, Factor & Simplify

factor(2)
hermite also curve construction

Curve Construction

hermite(0,0,0,1,1,0)
isprime also number theory

Number Theory

isprime(17)
lagrange also curve construction

Curve Construction

lagrange([0,1,2],[0,1,4])
linsolve also solve equations

Solve Equations

linsolve([[1,1],[1,-1]],[10,2])
powmod also modpow, number theory

Number Theory

powmod(3, 4, 5)
root also curve construction

Curve Construction

root(9)
simplify also expand, factor & simplify

Expand, Factor & Simplify

simplify(2)
solvefor also solve equations

Solve Equations

solvefor("x^2
solveinequalityfor also solve equations

Solve Equations

solveinequalityfor("x^2", ">", "4", "x")
totient also eulerphi, number theory

Number Theory

totient(9)

Other

charcode

charcode() — see docs

charcode(2)
else_if

else_if() — see docs

else_if(2)
fromcharcode

fromcharcode() — see docs

fromcharcode(2)
getrowvalue

getrowvalue() — see docs

getrowvalue(2)
getrowvalues

getrowvalues() — see docs

getrowvalues(2)
ifs

ifs() — see docs

ifs(2)
large

large() — see docs

large(2)
left

left() — see docs

left(2)
mid

mid() — see docs

mid(2)
nchoosek

nchoosek() — see docs

nchoosek(2)
parsenumber

parsenumber() — see docs

parsenumber(2)
print

print() — see docs

print(2)
proper

proper() — see docs

proper(2)
right

right() — see docs

right(2)
small

small() — see docs

small(2)
solvesystemfor

solvesystemfor() — see docs

solvesystemfor(2)
textjoin

textjoin() — see docs

textjoin(2)

See also