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.

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

## How to Calculate Mileage in Excel: Simple Steps

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 Calculate MPG 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, which 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).

**Download Practice Workbook**

You can download the practice workbook from the link below.

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