Calculating MPG

[Nicky_B]

March 2014.xlsx

Can anyone help?? If you look at week 1, column G you will see figures for fuel purchased, miles (KMs) travelled, and at the bottom of each driver a MPG achieved. How do I get a MPG when there are days when no fuel is purchased, and no cost for fuel?

[windy58]

As no fuel has been purchased it has nothing to calculate so cannot return a mpg result.