Complex Formulas

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


  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a complex formula that will perform addition before multiplication. If you are using the example, create a formula in cell D6 that first adds the values of cells D3, D4, and D5 and then multiplies their total by 0.075. Hint: You'll need to think about the order of operations for this to work correctly.