FigureCheckSpreadsheet formulas
Calculate values with spreadsheet formulas
Create calculated values directly in the FigureCheck table with familiar cell references, arithmetic, ranges, and summary functions.
Hands-on example
Try this in FigureCheck
Add a calculated column and try formulas such as =AVERAGE(B1:B8) or =B1/C1.
Opens a small synthetic dataset with a step-by-step guide in a new editable session.Enter a formula
- Select a spreadsheet cell.
- Type a formula beginning with = in the cell or formula bar.
- Pause briefly while FigureCheck saves and calculates the table in the background.
- Open Figure when you are ready to refresh the graph. Selecting the cell again reveals its formula in the formula bar.
Cell references use column letters and row numbers. For example, A1 is the first visible cell and C4 is the third column on row four.
Common examples
- =A1+B1 adds two cells. The operators +, -, *, /, %, and ^ are supported.
- =AVERAGE(A1:A10) calculates the arithmetic mean of a range.
- =SUM(B1:B10) adds the numeric values in a range.
- =MIN(A1:A10), =MAX(A1:A10), and =MEDIAN(A1:A10) summarize a range.
- =COUNT(A1:A10) counts numeric cells and ignores blanks or text.
- =ABS(A1), =SQRT(A1), =POWER(A1, 2), and =ROUND(A1, 2) perform common calculations.
Formula safety and errors
FigureCheck accepts only the documented mathematical operations. Formulas cannot open files, run Python, access the internet, or call arbitrary functions.
If a formula divides by zero, refers outside the table, or contains a circular reference, FigureCheck keeps the current table and identifies the problem instead of applying partial results.
When a formula is copied or dragged to another cell, relative references move with it. Always inspect the resulting references before using the calculated values scientifically.