Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Create Gas Mileage Calculator in Excel (with Easy Steps)

The number of miles a vehicle can travel using a certain amount of gas or fuel is known as gas mileage. A vehicle user might want to keep track of the vehicle running costs that he is spending. For that, he will need to know the mileage of each day of his vehicle. In this article, we will walk you through six easy steps to create a gas mileage calculator in Excel. Here’s an overview of the gas mileage calculator we have prepared for this article.

gas mileage calculator excel


Download Practice Workbook

Download this practice workbook to exercise while reading this article.


Step-by-Step Procedures to Create Gas Mileage Calculator in Excel

In this article, we will demonstrate six steps to create a gas mileage calculator in Excel. The steps are described in detail with proper illustrations in the following section.


Step 1: Insert Date and Odometer Reading

In the first step, we will need the odometer reading from a vehicle. We will use this reading as input.

  • First of all, Insert two columns and name them Date and Odometer Reading.
  • Then write the dates and odometer reading of each date as input in the columns.

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


Step 2: Calculate the Distance Traveled

We will now calculate the distance traveled by the vehicle on each date.

  • First, add a column named Distance Traveled.
  • Then select cell D6 and write down the following formula.
=C6-C5
  • Afterward, press Enter to get the distance traveled on 01-12-2022.

Calculate Distance Traveled to Create a Gas Mileage Calculator in Excel

  • After that, AutoFill this formula to the rest of the cells of column D.
  • Hence, you will get the value of distance traveled for all 7 days.

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


Step 3: Insert Fuel Consumed

In this step, we will need the amount of fuel consumed on each date.

  • First, insert a column and name it Fuel Consumed.
  • Then input consumed fuel in gallons for each date.

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


Step 4: Determine Gas Mileage

In this step, we will determine gas mileage for all 7 days in the Mileage column.

  • First of all, select cell F6 and type the following formula.
=D6/E6
  • Then Hit Enter.

Apply Formula to Create a Gas Mileage Calculator in Excel

  • Finally, AutoFill this formula and you will have the Mileage for all the dates.

AutoFill Mathematical Formula


Step 5: Calculate Cost Per Mile

Now we will calculate the cost per mile driven by the vehicle. For that, we need the value of Fuel Cost per Gallon.

  • First of all, insert the value of Fuel Cost per Gallon.

insert the value of Fuel Cost per Gallon

  • Next, select cell G6 and write the formula given below, and press Enter.
=E6*$D$14/D6

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

  • Then AutoFill this formula to the rest of column G to determine the Cost per Mile of each date.

determine the Cost per Mile of each date


Step 6: Compute Total Cost

In the final step, we will calculate the total cost for the distance traveled on each day.

  • First, select cell H6 and type the following formula.
=D6*G6
  • Further, hit the Enter button on your keyboard.

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

  • Finally, AutoFill this formula to the rest of the cells and you will get the total vehicle running cost for all 7 days.

Use AutoFill Feature

Notes
  • Don’t forget to give proper cell references or you won’t get your desired result.
  • You can change the units of distance and fuel as per your need.

Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know six easy steps to create a gas mileage calculator in Excel. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo