mileage calculator

  1. L

    A formula that highlights either age or mileage of a vehicle, whichever comes first

    I have a challenge, if anyone is kind enough to assist. I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped! I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I...
    • les361800
    • Thread
    • condition formula formula & macro if or and statements if satement mileage calculator service date
    • Replies: 2
    • Forum: Excel Questions
  2. J

    mileage rates based on yearly total

    I'm a bit of an excel noob and need help with a formula. I submit mileage expenses monthly. My mileage rate is based on yearly totals: 40 cents/mi for everything up to 5000 miles per year, 20 cents after that. So I need to input the yearly total mileage from the previous monthly report, then...
    • jzinko
    • Thread
    • cents fomula mileage mileage calculator miles
    • Replies: 2
    • Forum: Excel Questions
  3. J

    Need Mileage calculator using Google Maps and MS Excel

    Hello, I'm looking to create a mileage calculator in Excel using Google Maps, depending on how many addresses I input, I would like Excel to return a total trip mileage. I'm not interested in having this do anything else, I want to keep it simple, would not mind if in Excel I see a snapshot or...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top