About Docs Blog Contact

Try now

IronCalc Documentation

General information

IronCalc is in it's infancy, although we aim at supporting many of common spreadsheet features you might find some important features missing in your normal workflow.

If the lack of a particular feature is stopping you from using IronCalc please let us know and we will try to prioritize that over others.

With those caveats IronCalc is perfectly usable and if your workflow doesn't require non supported features, you can use it right away!

IronCalc intends to be Excel compatible, if a formula is evaluated differently in Excel than in IronCalc it is most likely a bug

List of supported functions

We support a wealth of functions already, you can track the development in IronCalc Functions.

Database
0/12

GitHub issue

At the moment IronCalc does not support any function in this section. All are planned.

DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
Date and time
8/25

GitHub issue

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
Engineering
54/54

GitHub issue

BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
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
Financial
28/55

GitHub issue

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
Information
15/21

GitHub issue

CELL
ERROR.TYPE
INFO
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOMITTED
ISREF
ISTEXT
N
NA
SHEET
SHEETS
TYPE
Logical
11/19

GitHub issue

AND
BYCOL
BYROW
FALSE
IF
IFERROR
IFNA
IFS
LAMBDA
LET
MAKEARRAY
MAP
NOT
OR
REDUCE
SCAN
SWITCH
TRUE
XOR
Lookup and reference
12/37

GitHub issue

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
Math and trigonometry
25/82

GitHub issue

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
Statistical
13/111

GitHub issue

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
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
19/44

GitHub issue

ASC
ARRAYTOTEXT
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DBCS
DOLLAR
EXACT
FIND
FINDB
FIXED
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
NUMBERVALUE
PHONETIC
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTAFTER
TEXTBEFORE
TEXTJOIN
TEXTSPLIT
TRIM
UNICHAR
UNICODE
UPPER
VALUE
VALUETOTEXT

Formatting Values

You can format numbers in scientific notation, as currencies, percentages or dates.

Using Styles

You can choose background colors, text colors, borders, font styles (bold, italics, underlined). You can also align text horizontally and vertically.

Widths of rows and heights of columns can also be changed

Keyboard shortcuts

From within your keyboard you can navigate and interact with the spreadsheet. This is a fairly interesting feature for power users.

Important unsupported Features

Although IronCalc is ready for you to use it is important for you to understand its limitations. Here we want to list what we feel are the most important missing features of a modern spreadsheet engine. If you can live without those features for now, IronCalc might be the product you are looking for.

Arrays and array formulas

Planned

We don't implement arrays or array formulas. Those are planned and coming very soon. This is the highest priority on the engine side.

Name manager

Planned

Although IronCalc supports importing and exporting defined names we cannot create/delete/update them in the UI right now. This is expected to be implemented shortly.

Only English supported

The MVP only supports the English language, but we plan to support three languages (English, German and Spanish) for version 1.0

No autocomplete

Spreadsheet users know that given a few cell entries like 1, 2, 3 the engine will autocomplete with 4, 5, 6 in the next cells when extending. This is not yet ready on IronCalc but it is on the roadmap.

Charts

Not planned for v1

Any serious spreadsheet program should support charts and this will be one of the highest priorities right after version 1.0