Task 1 of 2
In D2:D6, calculate the average sale (revenue / units sold). Where there were no sales, show 0 instead of an error.
Lesson theory
Dividing by zero gives #DIV/0!, and a value that is not found gives #N/A. Errors like these spoil a report and every formula that refers to them.
=IFERROR(B2/C2,0) — if the result is an error, show 0.The checking functions return TRUE or FALSE: ISBLANK (the cell is empty), ISNUMBER, ISTEXT and ISERROR.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page