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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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,992
Messages
6,128,165
Members
449,428
Latest member
d4vew

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