Error codes, explained
When a calculation has no valid answer, Maps for Math shows a standard code instead of a blank or a crash. Most are the same codes spreadsheets use, so you’ll recognize them anywhere.
| Code | Meaning | Spreadsheet |
|---|---|---|
#REF! | Broken reference | Same as #REF! in spreadsheets. |
#CYCLE! (site) | Circular reference | Like a spreadsheet’s circular-reference warning. |
#VALUE! | Wrong kind of input | Same as #VALUE! in spreadsheets. |
#DIV/0! | Division by zero | Same as #DIV/0! in Excel, Google Sheets, and Numbers. |
#NUM! | No valid real-number result | Same as #NUM! in spreadsheets. |
#RANGE! (site) | Outside what is physically possible | No spreadsheet equivalent; a spreadsheet would usually say #NUM!. |
#CONFLICT! (site) | Inputs disagree | No spreadsheet equivalent. |
#N/A | Not available yet | Same as #N/A in spreadsheets. |
When several problems happen at once, the most basic one is shown first, in the order above.