Calculate Miles Needed

Robby19

Board Regular
Joined
Mar 19, 2018
Messages
227
Good day,

I am driving myself crazy with trying to figure this out. Please save me!

I need a formula that will tell me how many miles are needed to be driven annually, based off of a Cents Per Mile and Driver Salary. Need help figuring out the "###" parts.

Web example can be found here. Basically I am re-creating this in Excel and changing it to my specifications. However this functionality will help in the long run with estimations.
http://www.thetruckersplace.com/OwnerWrkSheet.aspx

Example;
Annual CostsMonthly CostsCents Per Mile
Actual Cost of Operation1.57
Drivers Income$50,000=B3/12 ($4,166.67)=B3/Miles Needed (###)
Miles Needed:###

<TBODY>
</TBODY>
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I think I figured it out.

Code:
=SUM(Actual Cost of Operation,Drivers Income)*Cents Per Mile
Code:
=SUM(B2,B3)*D2
 
Last edited:
Upvote 0

Forum statistics

Threads
1,215,201
Messages
6,123,617
Members
449,109
Latest member
Sebas8956

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top