Embedded Files
What's Happening?
What's Happening?
You entered a formula and:
It’s not calculating.
You see an error message.
The result looks incorrect.
The formula is showing as text instead of calculating.
Most formula issues are small formatting or reference errors.
Step 1: Check for an Equals Sign
Step 1: Check for an Equals Sign
All formulas must begin with:
=
Example:
=SUM(A1:A10)
If the formula does not start with “=”, it will not calculate.
Step 2: Review Common Error Messages
Step 2: Review Common Error Messages
#REF! – A referenced cell was deleted.
#VALUE! – The wrong type of data is being used.
#DIV/0! – The formula is dividing by zero.
#NAME? – The function name may be misspelled.
Click the cell to see more details about the error.
Step 3: Check Cell References
Step 3: Check Cell References
Make sure:
The referenced cells still exist.
The range is correct (A1:A10 vs A1-A10).
You did not accidentally delete part of the formula.
📎 Need more detail?
📎 Need more detail?
View Google’s help article on formulas
Page updated
Report abuse