Classify real errors without misreading text
Enter one formula in G5. For all twelve values in B2:B13, return a twelve-row, two-column report. The first column is Missing for genuine #N/A, Error for the other six classic Excel errors, and Value for every other value. The second column is the documented error code 1 through 7 for a genuine error and numeric zero otherwise. Keep literal error-looking text, Boolean values and blanks in the Value category. Do not add headings.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. For all twelve values in B2:B13, return a twelve-row, two-column report. The first column is Missing for genuine #N/A, Error for the other six classic Excel errors, and Value for every other value. The second column is the documented error code 1 through 7 for a genuine error and numeric zero otherwise. Keep literal error-looking text, Boolean values and blanks in the Value category. Do not add headings.
No account. No upload. Just try it.