FORMULA Function in Zoho Sheet: Examples and Syntax
FORMULA in Zoho Sheet: audit a worksheet by showing a cell formula using practical sample data, clear expected results, pitfalls and the official function documentation.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Quick answer: Audit a worksheet by showing a cell formula. You inherit a spreadsheet and want to know whether an amount is calculated or manually entered. FORMULA exposes the expression stored in the selected cell as text.
This page covers the Zoho Sheet implementation specifically. Its example values and expected results are original educational data, not screenshots or claims of a live application test.
Syntax and argument order
=FORMULA(cell)
The argument order above follows the official Zoho Sheet documentation. Use the function name shown here, and replace placeholder arguments with ranges, cell references or criteria from your workbook.
Worked example with sample data
| Cell | Entered content |
|---|---|
| B2 | 25 |
| B3 | 40 |
| B4 | =SUM(B2:B3) |
Enter this formula in a free result cell (outside the input range):
=FORMULA(B4)
Expected result: =SUM(B2:B3).
Why this result is correct: The result is the literal formula string, not the calculated total of 65. This makes it useful for an audit or a documentation column.
A second example or variation
=SUM(B2:B3)
Expected result: 65.
The second expression is shown only for comparison: the formula itself calculates the amount, while FORMULA displays its underlying text.
Common mistakes and troubleshooting
Zoho documents an #N/A! response if the selected cell does not contain a formula. Test the function on a known formula cell before processing a whole sheet.
Also check that the version of Zoho Sheet you use supports this function. A formula pasted from another application can fail because of different syntax, date interpretation, array behavior or regional separators. If the result differs, first compare the small dataset above with the expected answer before substituting your real data.
Where this function helps
You inherit a spreadsheet and want to know whether an amount is calculated or manually entered. FORMULA exposes the expression stored in the selected cell as text. Replacing the sample cells with your own ranges lets you reuse the same reasoning. On important spreadsheets, test with a few known rows, verify the final cell formatting and keep a separate copy of the source data.
Practical checks before reusing this formula
A formula-inspection function is useful for auditing a workbook, but it is not a substitute for recalculating and verifying the underlying computation.
When you share a sheet, review whether formula text exposes internal file names, business rules or other information you did not intend to publish.
To compare this function with other spreadsheet programs, use our eight-software function comparison. A missing guide does not mean a function is unsupported in another product; check its official documentation.
Official reference and verification
- Official Zoho Sheet — FORMULA reference
- Verification status: Official documentation checked; example outcome independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.
- No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.