Once a formula in your spreadsheet computes the number you want, you tell Numio which result block should display it. This is called assigning a cell to a result block.
How to assign
- Select the result block in the editor — for example a Result, Chart, or Logic result block.
- In its settings panel, open the Formula group.
- Click the cell-assignment box (it reads No cell assigned until something is bound).
- The Formula spreadsheet slides open on the right side of the editor.
- Click the cell you want the block to read.
- Click Assign [cell ref] at the top — for example, Assign D12 — to confirm.
The Assign button stays disabled until you've selected a cell. When you confirm, the panel closes and the settings box shows the cell reference you picked.
If a cell was already assigned, it is selected automatically when the panel opens, so you can see what's currently wired up.
Single cells and ranges
You can assign a single cell (D12) or a range (D5:D10). A result that shows one number expects a single cell. A chart that plots a series expects a range — one cell per data point.
Changing or removing an assignment
To change what a block points at, click the box again (it now reads Change) and pick a different cell. While you're choosing, the box reads Pick a cell….
What gets displayed
The result block shows the computed value of the assigned cell — if the cell holds a formula, the formula's result is what appears, formatted according to the block's number-format settings. Inputs and result cells both live on the first tab; if you assign a cell on a reference tab it won't update with reader input.
If a referenced cell can't produce a number — for example it's empty, or its formula hit an error — the result resolves to 0 rather than showing an error code. See Formula verification and errors for how invalid formulas behave.
Where to go next
- Formula tab overview — spreadsheet basics
- Assigning input blocks to cells — the input side of the wiring
- Formula functions reference — the math you can write