Complex Formulas

Complex Excel formulas include more than one operator. Understand how to use complex formulas in Excel and other programs.


  1. Open an existing Excel workbook. If you want, you can use the example file for this lesson.
  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.