Right Fiatzo Forumo. For all you folks out there, here is some handy MPG info.
Working out MPG in Microsoft Excel
Open a new spread sheet and enter the folowing infomation.
Column Headings -
a1 MPG b1 Miles driven c1 Gallons d1 Litres e1 Pence per Litre f1 Pounds worth of fule
Formulas/Data -
a2 =sum(B2/C2) b2 type miles driven here i.e. (200) c2 =sum(D2/4.54) d2 =sum(F2/E2) e2 type pence per litre here f2 type pounds worth of petrol here
In F2 the cost needs to be entered without the decimal place eg: £25.81 is 2581.
Now we all should be able to work out our MPG!
P.S. Could a mod make this a sticky?
Working out MPG in Microsoft Excel
Open a new spread sheet and enter the folowing infomation.
Column Headings -
a1 MPG b1 Miles driven c1 Gallons d1 Litres e1 Pence per Litre f1 Pounds worth of fule
Formulas/Data -
a2 =sum(B2/C2) b2 type miles driven here i.e. (200) c2 =sum(D2/4.54) d2 =sum(F2/E2) e2 type pence per litre here f2 type pounds worth of petrol here
In F2 the cost needs to be entered without the decimal place eg: £25.81 is 2581.
Now we all should be able to work out our MPG!
P.S. Could a mod make this a sticky?