Correct error(s) in formulas

You can find and correct errors in formulas.

Procedure

  1. Open a spreadsheet.
  2. Activate the Contents tab bar.
  3. Click in the cell with the incorrect formula.
  4. Click Formula Formulas > Correct error(s). The Correct error(s) dialog opens. It displays the error description, the function containing the error, and a suggested correction.
  5. Specify the relevant settings and click OK.

You have corrected the error in the formula.