␡
- Formula Basics
- Summarizing Data Quickly
- Elements of Formulas
- Entering Formulas
- Determining the Order of Operations
- Understanding Cell References
- Using Cell References
- Understanding Comparison Operators
- Using Comparison Operators
- Understanding Functions
- Using Functions
- Copying and Moving Formulas
- Handling Errors
< Back
Page 13 of 13
This chapter is from the book
Handling Errors
When a formula cell contains an error, Numbers displays a red triangle in the middle of the cell. Double-tap the cell to see the error message and fix the formula . Some common errors are:
- Invalid cell references.
- Syntax errors: Including unpaired parentheses, misplacing operators (2xx2), or including too many or too few function arguments (count the commas).
- Math errors: Dividing by zero, taking the square root of a negative number, or taking the log of a nonpositive number.
- Domain errors: Comparing values with incompatible data types (2 < FALSE) or doing arithmetic on non-numbers (2 + “text”).
- Circular references: Creating a formula that depends, indirectly or directly, on its own value.
- Overflows: Calculating numbers that are too big for Numbers to handle (9999^9999).
< Back
Page 13 of 13