Correct error(s) in formulas
You can find and correct errors in formulas.
Procedure. 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.