IFERROR around a conversion
Turn imported text into numbers, and anything unreadable into a known default.
Task:
The survey tool exported the scores as text, and some respondents typed words instead of numbers. In C2:C7 convert each answer to a number, using 0 for anything that is not one.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of IFERROR
0/3The same formula in the other shapes it takes at work.
- IFERROR Function
Handle errors gracefully using IFERROR.
CoreIntermediate - IFERROR returning 0 so totals still add
A text fallback turns a number column into a mixed one; a zero keeps it numeric.
Intermediate - IFERROR around a conversion
Turn imported text into numbers, and anything unreadable into a known default.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Respondent | Score (text) | Score |
| 2 | R1 | 8 | |
| 3 | R2 | ten | |
| 4 | R3 | 6.5 | |
| 5 | R4 | n/a | |
| 6 | R5 | 9 | |
| 7 | R6 | 7 |
What this exercise teachesMay contain the answer
IFERROR is not only for division. Wrapping a conversion lets the clean rows convert and the bad rows land on a value you chose, instead of one #VALUE! stopping every calculation that touches the column.