Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
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
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.
Completed Calculations and Results section