Skip to content

Main Navigation Blog App

Appearance

Sidebar Navigation

About IronCalc

Web Application

About the web application

Importing Files

Sharing Files

Features

Formatting Values

Using Styles

Keyboard Shortcuts

Error Types

Value Types

Optional arguments

Units

Implicit Intersection

Arrays and array formulas

Dynamic Arrays

Unsupported Features

Functions

Lookup and reference

ADDRESS

AREAS

CHOOSE

CHOOSECOLS

CHOOSEROWS

COLUMN

COLUMNS

DROP

EXPAND

FILTER

FORMULATEXT

GETPIVOTDATA

HLOOKUP

HSTACK

HYPERLINK

IMAGE

INDEX

INDIRECT

LOOKUP

MATCH

OFFSET

ROW

ROWS

RTD

SORT

SORTBY

TAKE

TOCOL

TOROW

TRANSPOSE

UNIQUE

VLOOKUP

VSTACK

WRAPCOLS

WRAPROWS

XLOOKUP

XMATCH

Cube

CUBEKPIMEMBER

CUBEMEMBER

CUBEMEMBERPROPERTY

CUBERANKEDMEMBER

CUBESET

CUBESETCOUNT

CUBEVALUE

Financial

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

CUMIPMT

CUMPRINC

DB

DDB

DISC

DOLLARDE

DOLLARFR

DURATION

EFFECT

FV

FVSCHEDULE

INTRATE

IPMT

IRR

ISPMT

MDURATION

MIRR

NOMINAL

NPER

NPV

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

PDURATION

PMT

PPMT

PRICE

PRICEDISC

PRICEMAT

PV

RATE

RECEIVED

RRI

SLN

SYD

TBILLEQ

TBILLPRICE

TBILLYIELD

VDB

XIRR

XNPV

YIELD

YIELDDISC

YIELDMAT

Engineering

BESSELI

BESSELJ

BESSELK

BESSELY

BIN2DEC

BIN2HEX

BIN2OCT

BITAND

BITLSHIFT

BITOR

BITRSHIFT

BITXOR

COMPLEX

CONVERT

DEC2BIN

DEC2HEX

DEC2OCT

DELTA

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

GESTEP

HEX2BIN

HEX2DEC

HEX2OCT

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMCOSH

IMCOT

IMCSC

IMCSCH

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

IMPOWER

IMPRODUCT

IMREAL

IMSEC

IMSECH

IMSIN

IMSINH

IMSQRT

IMSUB

IMSUM

IMTAN

OCT2BIN

OCT2DEC

OCT2HEX

Database

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

Statistical

AVEDEV

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

BETA.DIST

BETA.INV

BINOM.DIST

BINOM.DIST.RANGE

BINOM.INV

CHISQ.DIST

CHISQ.DIST.RT

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CONFIDENCE.NORM

CONFIDENCE.T

CORREL

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COVARIANCE.P

COVARIANCE.S

DEVSQ

EXPON.DIST

F.DIST

F.DIST.RT

F.INV

F.INV.RT

F.TEST

FISHER

FISHERINV

FORECAST

FORECAST.ETS

FORECAST.ETS.CONFINT

FORECAST.ETS.SEASONALITY

FORECAST.ETS.STAT

FORECAST.LINEAR

FREQUENCY

GAMMA

GAMMA.DIST

GAMMA.INV

GAMMALN

GAMMALN.PRECISE

GAUSS

GEOMEAN

GROWTH

HARMEAN

HYPGEOM.DIST

INTERCEPT

KURT

LARGE

LINEST

LOGEST

LOGNORM.DIST

LOGNORM.INV

MAX

MAXA

MAXIFS

MEDIAN

MIN

MINA

MINIFS

MODE.MULT

MODE.SNGL

NEGBINOM.DIST

NORM.DIST

NORM.INV

NORM.S.DIST

NORM.S.INV

PEARSON

PERCENTILE.EXC

PERCENTILE.INC

PERCENTRANK.EXC

PERCENTRANK.INC

PERMUT

PERMUTATIONA

PHI

POISSON.DIST

PROB

QUARTILE.EXC

QUARTILE.INC

RANK.AVG

RANK.EQ

RSQ

SKEW

SKEW.P

SLOPE

SMALL

STANDARDIZE

STDEV.P

STDEV.S

STDEVA

STDEVPA

STEYX

T.DIST

T.DIST.2T

T.DIST.RT

T.INV

T.INV.2T

T.TEST

TREND

TRIMMEAN

VAR.P

VAR.S

VARA

VARPA

WEIBULL.DIST

Z.TEST

Text

MID

MIDB

NUMBERVALUE

PHONETIC

PROPER

REPLACE

REPLACEBS

REPT

RIGHT

RIGHTB

SEARCH

SEARCHB

SUBSTITUTE

T

TEXT

TEXTAFTER

TEXTBEFORE

TEXTJOIN

TEXTSPLIT

TRIM

UNICHAR

UNICODE

UPPER

VALUE

VALUETOTEXT

Math and trigonometry

ABS

ACOS

ACOSH

ACOT

ACOTH

AGGREGATE

ARABIC

ASIN

ASINH

ATAN

ATAN2

ATANH

BASE

CEILING

CEILING.MATH

CEILING.PRECISE

COMBIN

COMBINA

COS

COSH

COT

COTH

CSC

CSCH

DECIMAL

DEGREES

EVEN

EXP

FACT

FACTDOUBLE

FLOOR

FLOOR.MATH

FLOOR.PRECISE

GCD

INT

ISO.CEILING

LCM

LET

LN

LOG

LOG10

MDETERM

MINVERSE

MMULT

MOD

MROUND

MULTINOMIAL

MUNIT

ODD

PI

POWER

PRODUCT

QUOTIENT

RADIANS

RAND

RANDARRAY

RANDBETWEEN

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

SEC

SECH

SERIESSUM

SEQUENCE

SIGN

SIN

SINH

SQRT

SQRTPI

SUBTOTAL

SUM

SUMIF

SUMIFS

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

TAN

TANH

TRUNC

Logical

AND

BYCOL

BYROW

FALSE

IF

IFERROR

IFNA

IFS

LAMBDA

LET

MAKEARRAY

MAP

NOT

OR

REDUCE

SCAN

SWITCH

TRUE

XOR

Date and time

DATE

DATEDIF

DATEVALUE

DAY

DAYS

DAYS360

EDATE

EOMONTH

HOUR

ISOWEEKNUM

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Information

CELL

ERROR.TYPE

INFO

ISBLANK

ISERR

ISERROR

ISEVEN

ISFORMULA

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISODD

ISOMITTED

ISREF

ISTEXT

N

NA

SHEET

SHEETS

TYPE

Uncategorized

REGEXTEST

REGEXEXTRACT

REGEXREPLACE

TRIMRANGE

Desktop App

About Desktop app

Tironcalc

About Tironcalc

Installing and basic usage

Programming

About

Rust

Python

JavaScript

Contributing

How to contribute

On this page

Dynamic Arrays

Note: This page is in construction 🚧

Note: This feature is not yet available on IronCalc 🚧

Pager

Previous pageArrays and array formulas

Next pageUnsupported Features