Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.

How To Use in Sheets

IFERROR(value, [value_if_error])

External Links


Discover the IFERROR function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!

4Better Sheets Tutorials

Got a list of names, need to add new ones to main list.


4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.