Excel help

Author
Discussion

Guv10

Original Poster:

165 posts

112 months

Tuesday 25th April 2017
quotequote all
Well, not just excel a bit of maths help!!

Recently started a new job where I get a "jobs need car" I get 11p per mile.

Wanted a quick spreadsheet with a formula that if I enter the petrol cost and how many miles the trip is it would work out what my mpg would need to be to break even.

I'm sure it's simple enough but struggling.

Cheers

Guv10

Original Poster:

165 posts

112 months

Wednesday 26th April 2017
quotequote all
Guys, thank you. Need a serious brush up on my maths/excel skills!!

It's not a private car I don't think. It's a job needs car. I have to pay tax on it each month. I don't get paid for personal mileage either

Guv10

Original Poster:

165 posts

112 months

Wednesday 26th April 2017
quotequote all
Yes I get taxed £88 a month. That covers insurance, tax, repairs etc... and then I get 11p per mile

Guv10

Original Poster:

165 posts

112 months

Wednesday 26th April 2017
quotequote all
Yeah that's pretty much it. Not sure I can claim back tax on mileage though