1 | Result | Formula | |
|---|---|---|---|
2 | 1 | =ERROR.TYPE(#NULL!) | |
3 | 2 | =ERROR.TYPE(#DIV/0!) | |
4 | 3 | =ERROR.TYPE(#VALUE!) | |
5 | 4 | =ERROR.TYPE(#REF!) | |
6 | 5 | =ERROR.TYPE(#NAME?) | |
7 | 6 | =ERROR.TYPE(#NUM!) | |
8 | 7 | =ERROR.TYPE(#N/A) | |
9 | 8 | =ERROR.TYPE(#ERROR!) | |
10 |
1 | Cost | Quantity | Unit Price | Formula | ||
|---|---|---|---|---|---|---|
2 | $199.00 | 8 | $24.875 | =A2/B2 | ||
3 | $77.00 | #DIV/0! | =A3/B3 | |||
4 | $120.00 | L | #VALUE! | =A4/B4 | ||
5 | ||||||
6 | ||||||
7 | Cost | Quantity | Unit Price | Formula | ||
8 | $199.00 | 8 | $24.875 | =IF(ISERROR(A8/B8), IF(ERROR.TYPE(A8/B8)=2, "Missing a Quantity", "Check numbers"), A8/B8) | ||
9 | $77.00 | Missing a Quantity | =IF(ISERROR(A8/B8), IF(ERROR.TYPE(A8/B8)=2, "Missing a Quantity", "Check numbers"), A8/B8) | |||
10 | $120.00 | L | Check numbers | =IF(ISERROR(A8/B8), IF(ERROR.TYPE(A8/B8)=2, "Missing a Quantity", "Check numbers"), A8/B8) | ||
11 | ||||||
1 | Student ID | Grade | ||||
|---|---|---|---|---|---|---|
2 | N333 | 100 | ||||
3 | N222 | 85 | ||||
4 | N111 | 80 | ||||
5 | ||||||
6 | ||||||
7 | Student ID | Name | Grade | Error? | Formula | |
8 | N111 | Bob | 80 | No errors | =IF(ISERROR(C8), IF(ERROR.TYPE(C8)=7, "Student ID wasn't found", "Error: Check your formula"), "No errors") | |
9 | N22 | David | #N/A | Student ID wasn't found | =IF(ISERROR(C9), IF(ERROR.TYPE(C9)=7, "Student ID wasn't found", "Error: Check your formula"), "No errors") | |
10 | N333 | John | 100 | No errors | =IF(ISERROR(C10), IF(ERROR.TYPE(C10)=7, "Student ID wasn't found", "Error: Check your formula"), "No errors") | |
11 |