In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.
- Open an existing Excel workbook. If you want, you can use our practice workbook.
- 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.