You can find and correct errors in formulas.
Procedure
Open a spreadsheet.
Activate the Contents tab bar.
Click in the cell with the incorrect formula.
Click Formulas > Correct error(s). The Correct error(s) dialog opens. It displays the error description, the function containing the error,
and a suggested correction.
Specify the relevant settings and click OK.
You have corrected the error in the formula.