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.