Skip to content

Spreadsheet formulas

Formula cells start with = and are evaluated by IronCalc through Rhizome’s sheet editor.

Rhizome adds vault-aware sheet references on top of the normal spreadsheet formula model. Everything else should be treated as IronCalc formula behavior. IronCalc aims for Excel-compatible formulas, but the upstream project is still evolving, so verify advanced formulas against the IronCalc docs when precision matters.

SyntaxMeaning
=B2+B3-B4Arithmetic over cells.
=SUM(B2:D2)Function call over a range.
=ROUND(E6, 2)Function call with arguments.
=IF(E6>0, "Up", "Down")Conditional expression.
=$B$2Absolute column and row reference.
=B$2Relative column, absolute row.
=$B2Absolute column, relative row.
=B2:D10A range in the current sheet note.
="Q" & 1Text concatenation.

Use parentheses when a model depends on precedence:

=(B2+B3-B4)/B5

Rhizome supports wikilink cell references for values that live in another sheet note:

=[[newsletter-revenue]].B5
=SUM(B2:D2)+[[sponsorship-pipeline]].E12
=ROUND([[business-plan]].$E$12, 2)

The target inside [[...]] resolves like a normal Rhizome wikilink. The cell address after the dot uses A1 notation.

Absolute markers follow spreadsheet copy behavior:

ReferenceCopy behavior
[[revenue]].B5row and column can shift
[[revenue]].$B$5row and column stay fixed
[[revenue]].B$5row fixed, column can shift
[[revenue]].$B5column fixed, row can shift

Cross-sheet references currently resolve single cells. Keep range formulas inside one sheet note until cross-note ranges are explicitly supported.

Rhizome’s formula autocomplete exposes the implemented function catalog from the bundled IronCalc engine. The current catalog has 195 functions.

The dropdown shows a small ranked set of matches while you type. Keep typing to narrow the result list. Function names with digits and dots, such as BIN2DEC and ERFC.PRECISE, are supported.

AND, FALSE, IF, IFERROR, IFNA, IFS, NOT, OR, SWITCH, TRUE, XOR

ABS, ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, COS, COSH, PI, POWER, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SIN, SINH, SQRT, SQRTPI, SUM, SUMIF, SUMIFS, TAN, TANH, SUBTOTAL

CHOOSE, COLUMN, COLUMNS, HLOOKUP, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, VLOOKUP, XLOOKUP

CONCAT, CONCATENATE, EXACT, FIND, LEFT, LEN, LOWER, MID, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TEXTAFTER, TEXTBEFORE, TEXTJOIN, TRIM, UNICODE, UPPER, VALUE, VALUETOTEXT

ERROR.TYPE, FORMULATEXT, ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, NA, SHEET, TYPE

AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, GEOMEAN, MAX, MAXIFS, MIN, MINIFS

DATE, DAY, EDATE, EOMONTH, MONTH, NOW, TODAY, YEAR

CUMIPMT, CUMPRINC, DB, DDB, DOLLARDE, DOLLARFR, EFFECT, FV, IPMT, IRR, ISPMT, MIRR, NOMINAL, NPER, NPV, PDURATION, PMT, PPMT, PV, RATE, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, XIRR, XNPV

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

=SUM(B2:D2)
=B2+B3-B4
=SUM(B2:D2)-SUM(B4:D4)
=(C5-B5)/B5
=IF(B5=0, 0, (C5-B5)/B5)
=ROUND((C5-B5)/B5, 4)

Format the result as a percentage with a cell num_fmt such as 0.00%.

=IF(E5>10000, "On track", "Review")
=IFS(E5>10000, "High", E5>5000, "Medium", TRUE, "Low")
=IFERROR(B5/B4, 0)
=TODAY()
=DATE(2026, 6, 15)
=YEAR(TODAY())
=MONTH(TODAY())
=CONCAT(A2, " - ", B2)
=UPPER(A2)
=TRIM(A2)
=TEXT(B2, "$#,##0.00")
=INDEX(B2:E10, 3, 2)
=MATCH("Revenue", A2:A20, 0)
=VLOOKUP("Revenue", A2:E20, 5, FALSE)
=XLOOKUP("Revenue", A2:A20, E2:E20)
=[[newsletter-revenue]].E5
=SUM(B2:D2)+[[sponsorship-pipeline]].E12
=IF([[business-plan]].$E$12>0, [[business-plan]].$E$12, 0)

IronCalc documents formulas by category. Use these upstream pages for detailed syntax and examples. The upstream documentation may include newer functions that are not yet present in Rhizome’s bundled IronCalc version.

FamilyLink
Lookup and referenceIronCalc lookup and reference
FinancialIronCalc financial
EngineeringIronCalc engineering
DatabaseIronCalc database
StatisticalIronCalc statistical
TextIronCalc text
Math and trigonometryIronCalc math and trigonometry
LogicalIronCalc logical
Date and timeIronCalc date and time
InformationIronCalc information

IronCalc also documents value types, error types, optional arguments, and formatting values.

For current upstream gaps, see IronCalc’s unsupported features.