Thanks for all every ones help.

But I need another formula. I changed the format of the spreadsheet.

The columns are as follows:
Date, Description, Hotel, Transport, Mileage, Mileage Cost, Meals, Phone,
Entertainment, Misc, and Total.

I need a formula in the total field that would automatically calculate the
mileage cost (e.g.miles time 0.405) with all the other fields.

I do not want the actual mileage rate of 0.405 to show on the spreadsheet. I
just want the mileage cost to appear in that field.