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.

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

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.

Read More: How to Create ZIP to ZIP 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.

• Afterward, press Enter to get the distance traveled on 01-12-2022.

• 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.

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.

Read More: How to Make Daily Vehicle Mileage and Fuel Report 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.

• Then Hit Enter.

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

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.

• Next, select cell G6 and write the formula given below, and press Enter.

• Then AutoFill this formula to the rest of column G to 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.

• Further, hit the Enter button on your keyboard.

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

Download Practice Workbook

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.

<< Go Back to Excel Mileage Calculator | Excel Templates