Page 98 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

To create a complex formula using the order of operations:

In the example below, we'll use cell references along with numerical values to create a complex
formula that will calculate the subtotal for a catering invoice. Select the cell that will contain the
formula. In our example, we'll select cell C5.

TIP
The formula will calculate
the cost of each menu item
first, then add these
values.

1. Enter your formula. In our example, we'll type =B3*C3+B4*C4. This formula will follow
the order of operations, first performing the multiplication: 2.79*35 = 97.65 and 2.29*20
= 45.80. It then will add these values to calculate the total: 97.65+45.80.

2. Double-check your formula for accuracy, then press Enter on your keyboard. The
formula will calculate and display the result. In our example, the result shows that the
subtotal for the order is $143.45.

89 | P a g e