Determining mileage is crucial when comparing the fuel efficiency of motor vehicles. With this in mind, this article wishes to guide you on how to calculate mileage in Excel.

**Download Practice Workbook**

You can download the practice workbook from the link below.

**What Is Mileage?**

Before going into the details, let’s dwell a little upon what is mileage? In short, mileage is the number of miles that a vehicle can travel on one gallon of fuel. In fact, mileage is a measure of the fuel efficiency of a vehicle, simply put, the greater the mileage the higher the fuel efficiency of the vehicle.

**Arithmetic Formula to Calculate Mileage**

As we have a fair understanding of mileage, let’s get to know the arithmetic formula for calculating mileage.

`Mileage = Distance Travelled / Fuel Consumed`

Generally speaking, the distance traveled is quoted usually in Miles while the volume of fuel consumed is given in US Gallons.

**Simple Steps to Calculate Mileage in Excel **

Microsoft Excel makes calculating mileage a simple process. So, just follow these steps.

Throughout this article, we’re going to use the dataset shown below. The dataset consists of a **Mileage Log** with the **Date** of the journey, the **Distance **traveled (in Miles) between two Cities, and lastly, the volume of **Fuel** consumed (in US Gallons) to cover the *Distance *respectively.

__Step 01: Determine Mileage__

- At the very beginning, insert an additional column for
**Mileage**. - Then, type in the
**ROUNDUP function**to round up the result to one decimal place. - Next, enter the expression provided below.

`=ROUNDUP(E5/F5,1)`

In this expression, the **E5** cell refers to the **Distance **(** number **argument) in miles while the

**F5**cell indicates the

**Fuel**in US gallons (

**argument). In contrast, the value of**

*number***1**refers to the

**argument which rounds the result to the nearest 1 decimal place.**

*num_digits*__Step: 02 Use Fill Handle to Complete the Table__

- Secondly, use the
**Fill Handle**to copy the formula and fill up the table. - In this case, the
*Mileage*values are shown in the**G5:G13**cells.

- Finally, this concludes the calculation of
*Mileage*, and the results are shown below.

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

## Calculating Best Mileage in Excel

Now, if you’re wondering is there any shortcut to finding the best mileage result? Then the answer is a resounding yes, let’s see it in action.

As we’ve discussed earlier, a bigger value of mileage is more desirable. Fortunately, Excel has the **MAX function** to determine the largest value from a selected range.

`=MAX(G5:G13)`

In this formula, the **G5:G13 **cells represent the *Mileage* (**number1** argument).

## Computing **Average Mileage**

In a similar fashion, we can also determine the **Average Mileage **from the range using the **SUM function** as shown in the formula below. This article also **covers the calculation of Average MPG**, you may explore if you want.

`=SUM(E5:E13) / SUM(F5:F13)`

In the above expression, the **E5:E13 **cells refer to the array range of the *Distances *while **F5:F13 **cells represent the range of *Fuel*.

## Determining **Worst Mileage**

By now you’ve probably figured out that Excel has a function to calculate the minimum value in the selected range. In fact, you’re correct, Excel’s **MIN function** does just that. So, just follow along.

`=MIN(G5:G13)`

In this formula, the **G5:G13 **cells represent the *Mileage* (**number1** argument).

**Read More:** **How to Calculate Mileage Reimbursement in Excel (Step-by-Step Guide)**

**Conclusion**

To conclude, I hope you found in this article what you were looking for. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website **ExcelDemy**.