FORMULATEXT in Apple Numbers: Display and Audit Cell Formulas
Display the formula entered in an Apple Numbers cell as text and build a transparent formula-audit column, with reproducible examples and platform cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked
Quick answer: FORMULATEXT displays the formula in a referenced cell as a text string, instead of its calculated result. Apple’s official example =FORMULATEXT(B2) returns the text =SUM(A2:A7) when cell B2 contains that formula. It is useful for auditing a Numbers workbook, building training examples and documenting how a result was produced. Apple’s FORMULATEXT reference, checked 2026-10-12, explicitly says it returns what appears in the formula bar for the referenced cell.
Exact Apple Numbers syntax
=FORMULATEXT(reference)
| Argument | Required? | Official type | Purpose |
|---|---|---|---|
reference |
Yes | A cell or range of cells | Identifies the formula whose text should be returned. |
Apple’s 15.4 reference documents one argument and does not document a default when it is omitted. The documentation accepts a cell or range, but does not explicitly say how a multi-cell range is reduced to a single string or whether it produces multiple results in every context. Use a single cell for reproducible auditing until tested in Numbers. This tutorial does not import Excel’s different documented range behaviour or error codes as evidence about Numbers.
Reproducible workbook: formula-audit table
Create a Numbers table with one header row, where A is labelled Value, B Calculation, and C Formula text. Enter these numeric values in A2:A7: 56, 74, 24, 87, 42, 17.
| Row | A: Value | Formula in B | Independently calculated B value | Audit formula in C |
|---|---|---|---|---|
| 2 | 56 | =SUM(A2:A7) |
300 | =FORMULATEXT(B2) |
| 3 | 74 | =AVERAGE(A2:A7) |
50 | =FORMULATEXT(B3) |
| 4 | 24 | =MIN(A2:A7) |
17 | =FORMULATEXT(B4) |
| 5 | 87 | =MAX(A2:A7) |
87 | =FORMULATEXT(B5) |
| 6 | 42 | =MEDIAN(A2:A7) |
49 | =FORMULATEXT(B6) |
| 7 | 17 | =COUNT(A2:A7) |
6 | =FORMULATEXT(B7) |
Apple’s own worked example uses this table and these formulas. Its published outputs establish that C2 shows the text =SUM(A2:A7) and C6 shows =MEDIAN(A2:A7), including the leading equals sign; see the official FORMULATEXT examples.
The B-column results are also independently arithmetically checked: sum 56+74+24+87+42+17=300, average 300/6=50, and sorted values 17,24,42,56,74,87 have median (42+56)/2=49. They are expected mathematical values, not evidence of running the workbook in Numbers. The exact textual representation can change if Numbers rewrites a reference (for example when a cell becomes a qualified table reference), because Apple says it returns the formula-bar text.
Advanced uses: transparent calculations and audits
1. Keep the inputs and calculation visible together
The C column makes formula logic reviewable without selecting B2, B3, etc. This helps catch cases such as an accidental range A2:A6 rather than A2:A7. FORMULATEXT does not validate correctness; it only reports the formula text. Compare the formula with the intended input range before trusting a result.
2. Show the formula string in a sentence
If B2 contains the SUM formula in the example, a formula such as:
="Calculation used: "&FORMULATEXT(B2)
has independently reasoned expected text Calculation used: =SUM(A2:A7) for the exact example representation Apple publishes. This combines the Numbers text concatenation operator with FORMULATEXT; the combined formula was not executed in Numbers.
3. Look for a leading equals sign in an audit
With Apple’s B2 sample, =LEFT(FORMULATEXT(B2),1) is expected to return = and =LEN(FORMULATEXT(B2)) is expected to return 11, because the documented text =SUM(A2:A7) has 11 characters. These checks are conditional on the formula-bar representation and do not establish a guaranteed character length after Numbers autoformats a formula reference. Apple’s function catalogue lists LEFT and LEN.
4. Avoid treating a formula as its value
B2 contains the numeric result 300; FORMULATEXT(B2) returns formula text. Do not add FORMULATEXT output to numeric totals. If your aim is to evaluate a formula, reference B2 directly; if your aim is to inspect it, reference FORMULATEXT(B2).
Troubleshooting and unverified behaviours
| Symptom or question | Reliable guidance |
|---|---|
| The audit shows a formula you did not expect | Inspect B2’s formula bar and the intended range. FORMULATEXT reports the formula’s text; it cannot tell you the formula is logically correct. |
| The audit output differs in table names or capitalization | Apple says the result matches the formula bar, so preserve the actual formula-bar form instead of requiring exact keystrokes. |
| Reference points to a different table | Apple’s reference documentation uses Table 2::B2 and, where needed, Sheet 2::Table 2::B2. |
| Referenced cell contains only a literal number or text | Apple does not specify the exact Numbers error/output on the inspected page. Record this as native-test-pending, not #N/A by assumption. |
| Entire range or column supplied | Although Apple’s argument definition accepts a range, its behaviour with multiple formula cells was not independently verified. Use single-cell references for production guides. |
| A user wants to edit the formula shown as text | The text result is for inspection, not a linked editable replacement for the original formula. Edit the referenced formula cell itself. |
| The formula shows a different delimiter in another region | English examples use comma separators; comma-decimal locales use semicolons between function arguments, as Apple documents. FORMULATEXT itself accepts just one reference argument. |
No exact Apple Numbers errors, character limits, multi-cell-range behaviour or protected-sheet behaviour are asserted without an actual native test. Do not transfer Excel’s 8,192-character error limit into Apple Numbers.
Excel versus Numbers
Both vendors document the same general signature: Apple uses FORMULATEXT(reference) and Microsoft Excel likewise uses FORMULATEXT(reference). But Microsoft’s support page additionally specifies upper-left cell selection for multi-cell ranges and a particular #N/A result for nonformula cells. Apple’s inspected page does not specify either behaviour, so they are Excel-only documented facts here. Do not use Excel behaviour to validate an Apple Numbers error table. Neither application was executed for these examples.
Platform, locale and links
The checked vendor material is Apple’s Formulas and Functions Help, 15.4 edition, as accessed 2026-10-12. It confirms FORMULATEXT is in the function catalogue, but not its exact first supported Numbers release across Mac, iPhone/iPad or iCloud. Check the local function browser on older versions. Apple also describes multi-cell spilling introduced in Numbers 14.4, but that does not establish FORMULATEXT’s range-output behaviour in older releases.
In an ordinary Numbers table, B2 refers to a cell in that same table. When referencing another table, follow Apple’s cell-reference syntax. Apple’s Functions overview explains the switch from comma to semicolon as the argument separator when comma is the decimal separator. The single-argument FORMULATEXT signature has no internal separator.
Official FORMULATEXT, Apple catalogue, Apple reference rules, and Microsoft FORMULATEXT were checked on 2026-10-12.
Verification status: Official documentation checked. Sample SUM/median results independently arithmetically verified; formula texts for C2 and C6 are Apple-published expected outputs. Not executed in Apple Numbers; no native application screenshots were captured.