If a result shows 0, a stale number, or nothing at all, the cause is almost always in how the result is wired to your spreadsheet — not a bug in the engine. This article walks through the most common reasons a formula doesn't calculate and how to fix each one.
How calculation actually works
Numio runs a small spreadsheet engine in the background. Your input blocks write values into specific cells, the engine recomputes the sheet, and each result block reads back the cell you assigned to it. Two links have to be in place for a number to appear:
- The result block must have a cell assigned to it.
- The formula in that cell must produce a real value.
When either link is broken, the engine falls back to 0 rather than throwing an error — so a 0 is your most important diagnostic clue.
The result has no cell assigned
This is the most frequent cause. If a Numeric result was never pointed at a spreadsheet cell, it has nothing to read and will sit at its default.
- Select the result block.
- Open the Formula group in its settings.
- Look at the assign box. If it reads No cell assigned, click Assign, then click the output cell on the sheet.
- Once a cell reference (like
C2) appears in the box, the result is wired up.
See Assigning cells to results for the full walkthrough.
The formula uses a function Numio doesn't recognize
The engine supports the common spreadsheet functions: SUM, AVERAGE, MIN, MAX, COUNT, ROUND, ROUNDUP, ROUNDDOWN, ABS, SQRT, POWER, CEILING, FLOOR, IF, AND, OR, NOT, IFERROR, VLOOKUP, HLOOKUP, INDEX, and MATCH.
Any function outside this list evaluates to 0. If a result is stuck at 0 and your formula uses something like SUMIF, XLOOKUP, or a date function, rewrite it using a supported function. The full list lives in the formula functions reference.
The formula references the wrong sheet
Inputs and outputs always live on the first sheet of your workbook. A bare reference like =B2*B3 resolves against the sheet the formula lives on. If your output cell is on the first sheet but pulls from a value that only exists on another tab, write the cross-sheet reference explicitly:
=Rates!B2 * B3
='Married Filing Joint'!C4
A reference to a sheet or cell that doesn't exist resolves to 0, so a misspelled tab name silently zeroes out the result.
The formula refers back to itself (circular reference)
If a cell's formula ends up depending on itself — directly or through a chain of other cells — the engine breaks the loop by treating the looping reference as 0. The result won't error; it'll just compute a wrong or zero value. Trace the chain of references and remove the cell that points back to itself.
A divide-by-zero or invalid math result
Division by zero returns 0 rather than an error, and any result that isn't a finite number (for example, the square root of a negative input) is also coerced to 0. If a result drops to 0 only for certain inputs, check whether those inputs make a denominator zero or push a function out of range. Wrapping the expression in IFERROR(...) lets you supply a fallback value.
The formula was never verified
Results whose data type is formula or constant must be verified before they'll publish. An unverified formula shows a warning in the data table and in the Publish review step. Re-open the formula, confirm it, and make sure it resolves to a value.
Quick checklist
- Result shows No cell assigned → assign an output cell.
- Stuck at
0with an unusual function → that function isn't supported; rewrite it. - Wrong value from another tab → check the sheet name in the cross-sheet reference.
0only for some inputs → look for divide-by-zero or out-of-range math.- Won't publish → the formula is unverified; verify it.