| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Result | Function | Check Error | #N/A | #DIV/0! | #REF! | |
2 | #N/A | =NA() | ISNA | TRUE | FALSE | FALSE | |
3 | #DIV/0! | =1/0 | ISERROR | TRUE | TRUE | TRUE | |
4 | #REF! | =VLOOKUP("ISNA",D1:E4,6,0) | ISERR | FALSE | TRUE | TRUE | |
5 | Error! | =IFERROR(A3,"Error!") | IFNA | TRUE | #DIV/0! | #REF! | |
6 | 7 | =ERROR.TYPE(A2) | IFERROR | TRUE | TRUE | TRUE | |
7 | |||||||
8 | Sheet Cheat Sheets |