Check before you calculate

Intermediate← PreviousSkip →
Exercise 8 of 11 Premium

Work out Training's variance %, (Actual − Budget) ÷ Budget, but show "No data" if its Actual cell is blank.

Checking your plan…

team-budget.xlsx

ABCD
1CategoryBudgetActualUnits
2
3
4
5
6
7
8

About error handling in Excel

#DIV/0!, #N/A and #VALUE! make reports look broken. Learn when each error appears and how to replace it with a clean result using IFERROR, IFNA and ISBLANK.

GuideHow to Use the IF Function in Excel→

Functions you can use here

  • IFERROR(value, value_if_error)
  • IFNA(value, value_if_na)
  • ISBLANK(value)
  • SUMPRODUCT(array1, [array2], …)

More error handling exercises

  1. 1.Avoid #DIV/0!
  2. 2.Missing lookups
  3. 3.Check for a numberPremium
  4. 4.Count empty cellsPremium
  5. 5.Budget variancePremium
  6. 6.IFERROR with a messagePremium
  7. 7.Blank or notPremium
  8. 8.Check before you calculatePremium
  9. 9.IFNA with MATCHPremium
  10. 10.How many went over?Premium
  11. 11.Add up with a conditionPremium
See the whole topic →