Syntax

IFERROR(value, [value_if_error])

Arguments

The printed syntax lists 2 argument(s), in order:

  • value
  • alue_if_erro optional

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“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.”

Google’s help article for IFERROR →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 156 of 516, data fetched 28 September 2026. Data month: September 2026.