Are You Making Any Money?

Profit is what you make after you pay for the costs. In our example, the equation is: =D2-B2.


3. Try This: Calculate the Profit

Select Cell E1 and type the label: Profit.

Select Cell E2 and enter the equation:

=D2-B2

 

Copy and paste that equation into Cells E3 through E5.

4. Add This, Too: Sum up the Profit

Select Cell E6.

Go to AutoSum.

 

What Do You See? For each fruit basket that you sell, there is a profit of $4.25.

Keep going...

graphci2

Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions: Demonstrate the SUM Function

graphic1
Home -> Editing ->AutoSum