Another Formula Need

[Lonz]

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.

 

[Pank Mehta]

Lonz,

I am making the assumption that all the heading you have specified are
columns.

I would insert a column before the TOTAL column (i.e. column K) and put in a
value of .405, I would then put the following formula in the TOTAL column,
=e2*k2 and fill/copy both columns down as far as you need. I would then hide
column K (i.e. select the column and select Hide option.

However, I note that you have a column headed Mileage Cost, wouldn’t you
want this Total in there? If you do I would basically insert a column F and
change the above formula to e2*f2 and repeat the above.

HTH

Pank