How to Create a Gas Mileage Calculator in Excel – 6 Steps

This is an overview.

gas mileage calculator excel


Step 1 – Enter the Date and the Odometer Reading

  • Insert two columns: Date and Odometer Reading.
  • Enter the dates and the odometer reading for each date.

Insert Date and Odometer Reading to Create a Gas Mileage Calculator in Excel

Read More: How to Create ZIP to ZIP Mileage Calculator in Excel


Step 2 – Calculate the Distance Traveled

  • Insert the column Distance Traveled.
  • Select D6 and enter the following formula.
=C6-C5
  • Press Enter to get the distance traveled on 01-12-2022.

Calculate Distance Traveled to Create a Gas Mileage Calculator in Excel

  • AutoFill this formula to the rest of the cells in column D.

You will get the distance traveled for 7 days.

AutoFill Formula to Determine Distance Traveled and Create a Gas Mileage Calculator in Excel


Step 3 –  Enter the Consumed Fuel

  • Insert the column Fuel Consumed.
  • Enter the consumed fuel in gallons for each date.

Input Fuel Consumed Values to Create a Gas Mileage Calculator in Excel

Read More: How to Make Daily Vehicle Mileage and Fuel Report in Excel


Step 4 – Determine the Gas Mileage

  • Select F6 and use the following formula.
=D6/E6
  • Press Enter.

Apply Formula to Create a Gas Mileage Calculator in Excel

  • AutoFill the formula to see the Mileage.

AutoFill Mathematical Formula


Step 5 – Calculate Cost Per Mile

  • Enter the Fuel Cost per Gallon.

insert the value of Fuel Cost per Gallon

  • Select G6 and use the formula below.
  • Press Enter.
=E6*$D$14/D6

Apply Formula to Create a Gas Mileage Calculator in Excel and Calculate Cost per Mile

  • AutoFill the formula to see the Cost per Mile.

determine the Cost per Mile of each date


Step 6 – Calculate the Total Cost

  • Select H6 and use the following formula.
=D6*G6
  • Press Enter.

Use Formula to Create a Gas Mileage Calculator in Excel and Compute Total Cost

  • AutoFill the formula to see the total cost for the 7 days.

Use AutoFill Feature

Notes

Download Practice Workbook


 

<< Go Back to Excel Mileage Calculator | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Alif Bin Hussain
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo