Calculate Expenses Tutorial Home >Software >Finance >Microsoft Works 2000 Projects >Travel Budget >Calculate Expenses Tutorial Home >Software >Office >Microsoft Works 2000 Projects >Travel Budget >Calculate Expenses Tutorial Home >Software >Publishing >Microsoft Works 2000 Projects >Travel Budget >Calculate Expenses   Step 1:  Enter a Formula You need to calculate how much money each expense category will cost. To do so, you enter a formula that will multiply the Unit Cost by the Number. Click cell E5, then enter the formula =C5*D5 as shown.   Step 2:  Calculate the Formula Press the Enter key to show the result of the formula. As you can see, the two flights will cost $900. You'll format the cell with the Currency style in a later step.   Step 3:  Show the Fill Icon To save time, you can copy the formula from cell E5 down to cell E11. First, click cell E5, then point to the lower left corner to display the Fill icon as shown.   Step 4:  Copy the Formula Drag the Fill icon down to cell E11. All of the expenses are automatically calculated except the Groceries expense since you didn't enter a value for it.   Step 5:  Calculate a Total You need to calculate how much the entire trip will cost. Click in cell C12 and then click the AutoSum button as shown.   Step 6:  View the Total Click the AutoSum button again to complete the calculation. As you can see, the Mexican vacation will cost $5,400—that is, unless you spend some time modifying the expenses!   Step 7:  Apply Currency Format Select cells E5 through E12, then click the Currency button. Here's how the totals for each expense category appear.