Complex Excel formulas include more than one operator. Understand how to use complex formulas in Excel and other programs.
- Open an existing Excel workbook. If you want, you can use the example file for this lesson.
- 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.