Creating Complex Formulas

In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Challenge!

  • Open your Monthly Budget spreadsheet.
  • Fill the formula defined in cell C17 to D17 through N17.
  • Type Percent Saved in A18.
  • Write a formula in C18 that divides your monthly Savings amount (C17) by your monthly Income (C16).
  • Save and close the Monthly Budget spreadsheet.