Google Sheets IfError

If error looks at a formula, and if it it produces an error an error does a second thing.  That second thing could be displaying a message, or using a different formula.  If there is no error, it will display the results of the formula

So

=Iferror(ErrorCheck This Formula,  Action – Do this if you find an error)

The process looks like this

• Step 1: ErrorCheck Does this formula have an error?
  • No?  Cool. Just Display the results of the Formula in Step1
  • Yes! CRAP! Do the action in STEP2!
• Step 2: Action – Do this if you find an error in step 1

You can also nest multiple errors together

=Iferror(ErrorCheck this formula,  iferror(ErrorCheck2 this formula, Action – Do this if you find an error)

The process looks like this

• Step 1: ErrorCheck1 Does this formula have an error?
  • No?  Cool. Just Display the results of the Formula in Step1
  • Yes! CRAP! Do the action in STEP2!
• Step 2: ErrorCheck2 Does this formula have an error?
  • No?  Cool. Just Display the results of the Formula in Step2
  • Yes! CRAP! Do the action in STEP3!
• Step 3: Action – Do this if you find an error