Excel 2013
Complex Formulas
Challenge!
- Open an existing Excel workbook. If you want, you can use the Lesson 14 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.