Formula for Pricing Per Mile
Hi Guys,
I'm trying to create a formula for the following example (see picture). I have a friend using a software, and it's not taking an account for the return miles, so we are trying to build a formula that will give us the answer in Excel when we plug in the total round trip miles. An example is 302.14 miles, the 1st mile is $125, miles after that 1 mile up to 45 miles is .05 per mile, and the remainder are calculated at $3 per mile
miles.png
You didn't show an Excel sheet so you will have to translate these formulas to fit your actual data layout.
Values as displayed
Underlying formulas
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Please check and update your profile accordingly.2016 I think
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks