Replace only missing-value errors
Enter one formula in G5. Return twelve rows from B2:B13 in their original order. Replace only genuine #N/A with the literal text in G2. Preserve every other real error with its original error type. Preserve numbers, Boolean values and literal text, including strings that look like errors. Normalize an empty source cell to empty text rather than numeric zero. Do not add a heading.
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. Return twelve rows from B2:B13 in their original order. Replace only genuine #N/A with the literal text in G2. Preserve every other real error with its original error type. Preserve numbers, Boolean values and literal text, including strings that look like errors. Normalize an empty source cell to empty text rather than numeric zero. Do not add a heading.
No account. No upload. Just try it.