Microsoft Office Tutorials and References

In Depth Information

**USING EXCEL SOLVER**

FIGURE D-13

AutoSum button in the Editing group

SUM(G16:G20), and the displayed answer should be 25716.

Now you can copy cell G21 to cells H21, I21, J21, K21, L21, and N21. When you have completed this section

of the table, it should have the values shown in Figure D-14.

Cell G21 should now contain the formula

¼

FIGURE D-14

Most totals cells completed

The last formula to enter is for cell M21. This is not a total, but an overall percentage of Vehicle Capacity

Utilized for all the vehicles used. This calculation uses the same formula as the cell above, so you can simply

copy cell M20 to cell M21. The formula for this cell is

G21/L21, which is Volume Required divided by Total

Vehicle Capacity, expressed as a percentage. Your completed spreadsheet should look like Figure D-15.

¼

FIGURE D-15

Completed Calculations and Results section