Formulas
Use formulas to calculate and transform your data.
Writing a formula
Select a cell and type = followed by your formula. Press Enter to confirm. Formulas update automatically when referenced data changes.
For example, if you type =A1+B1 in cell C1, it will always show the sum of cells A1 and B1, even if you change those values later.
Cells with formulas are marked with a small blue triangle in the top-right corner. Click a formula cell and look at the formula bar to see the full formula.
The formula bar
The formula bar sits between the toolbar and the grid. On the left, it shows the active cell's reference (like A1 or D7). On the right, it shows that cell's content — whether it's text, a number, or a formula.
You can click directly into the formula bar to edit the cell's content. This is especially handy for long formulas that don't fit in the cell itself, or when you're working on mobile.
Common functions
cDox uses HyperFormula as its calculation engine, which means hundreds of functions are available. Here are the ones you'll use most often:
| Function | What it does | Example |
|---|---|---|
| SUM | Adds up values | =SUM(A1:A10) |
| AVERAGE | Calculates the average | =AVERAGE(B1:B5) |
| COUNT | Counts cells with numbers | =COUNT(A1:A20) |
| MIN / MAX | Smallest or largest value | =MAX(C1:C10) |
| IF | Conditional logic | =IF(A1>0, "Yes", "No") |
| ROUND | Rounds a number | =ROUND(A1, 2) |
| CONCATENATE | Joins text together | =CONCATENATE(A1, " ", B1) |
| TODAY | Today's date | =TODAY() |
For the full list of available functions, see the HyperFormula documentation. Everything listed there works in cDox.
Cell references
Cell references use the column-letter + row-number format: A1, B5, C10. You can reference a range of cells with a colon, like A1:A10 for all cells from A1 through A10.
You can combine references in formulas. For example, =A1*B1 multiplies two cells, and =SUM(A1:A5, C1:C5) adds up two different ranges.
Cross-tab formulas
If your sheet has multiple tabs, you can reference cells from another tab by using the tab name followed by an exclamation mark. For example:
=Sheet2!A1— gets the value from A1 in Sheet2=SUM(Sheet2!A1:A10)— sums a range from another tab
This is really useful for creating a summary tab that pulls data from several other tabs.
If your tab name contains spaces, wrap it in single quotes in the formula: ='My Tab'!A1.