Replace only missing-value errors
Your goal: Use one literal fallback for real #N/A while keeping other errors visible and preserving ordinary value types.
Full 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.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
Replace only genuine #N/A
Rules for this step
Choose exactly the missing-value errors. Preview the literal fallback from G2; other genuine errors and error-looking text must survive unchanged.
Tap values in the worksheet to include or remove them. Type labels distinguish stored numbers, text, logical values, genuine blanks and genuine errors.
| Cell | Source value | After this decision |
|---|---|---|
| B2 | #DIV/0!Error | #DIV/0!Error |
| B3 | #N/AError | #N/AError |
| B4 | #VALUE!Error | #VALUE!Error |
| B5 | #REF!Error | #REF!Error |
| B6 | 0Number | 0Number |
| B7 | -4Number | -4Number |
| B8 | 2.5Number | 2.5Number |
| B9 | "#N/A"Text | "#N/A"Text |
| B10 | "#DIV/0!"Text | "#DIV/0!"Text |
| B11 | TRUELogical | TRUELogical |
| B12 | (blank)Blank | (blank)Blank |
| B13 | ""Text | ""Text |