- Select the cell
- Press F2 and go into editing mode
- Select part of the formula
- Press F9 to the see the result of that much part
Entering a formula and receiving an error in return isn’t uncommon. One possibility is that the formula you entered is the cause of the error. Another possibility is that the formula refers to a cell that has an error value. The latter scenario is known as the ripple effect — a single error value can make its way to lots of other cells that contain formulas that depend on the cell. The tools in the Formulas➜Formula Auditing group can help you trace the source of formula errors. Table below lists the types of error values that may appear in a cell that has a formula.
Error Value Explanation