Formulas

Formulas start with = and calculate a value from numbers, text, dates, booleans, cell references, ranges, and functions.

Examples

=B1-C1
=SUM(B1:B12)
=SUM('Budget 2026'!B2:B13)
=IF(D2>0, "Profit", "Loss")
=XLOOKUP(A2, Projects!A1:A20, Projects!B1:B20, "Missing")
=TEXTJOIN(", ", TRUE, A2:A5)

Use cell addresses like A1, B4, and AA10. Use ranges like A1:A10 and B2:D6. Reference another sheet with Sheet2!A1 or quote names with spaces, such as 'Budget 2026'!A1.

Formula Help

When you type a formula, MikroSheets can show function suggestions and signatures near the formula bar.

Common Patterns

• Use SUM for totals.
• Use SUMIF, COUNTIF, and AVERAGEIF for conditional summaries.
• Use AVERAGE, MIN, MAX, and MEDIAN for summaries.
• Use IF and IFERROR to make formulas easier to read.
• Use XLOOKUP to pull matching values from another table or sheet.
• Use UNIQUE, SORT, and FILTER for lightweight list analysis.
• Use text functions like CONCAT, TEXTJOIN, LEFT, RIGHT, and SUBSTITUTE to clean or combine labels.
• Use date functions like TODAY, DATE, YEAR, MONTH, and DAY for date-based work.

Errors

MikroSheets shows a formula error in the cell when a calculation cannot complete.

• #DIV/0! means the formula divided by zero.
• #CYCLE! means cells refer back to each other in a circular chain.
• Other parser or function messages usually point to an unsupported function, an invalid argument count, or a malformed formula.

When an error appears, check the referenced cells first. Empty cells, text where a number is expected, and accidental self-references are common causes.