miles

  1. Z

    Convert Longitude & Latitude Start and End Coordinates into Nautical Miles (no API)

    I am trying to convert the START and END latitude and longitude coordinates I have into nautical miles. I read here that I had to convert my latitude and longitude (in degrees) to radians which I did by using the =RADIANS function. My situation is as follows: I have a start and finish lat and...
  2. A

    Match and Display Text

    <colgroup><col><col span="2"><col><col></colgroup><tbody> Eng1 Eng2 Eng3 Lowest Miles Eng 40 39 52 39 </tbody> I want to match the 'lowest miles' number to the three ENG numbers. When matched, I want to display the ENG1/2/3 under ENG
  3. M

    Screwing up a nested IF function

    Hi. I'm creating a spreadsheet for a music group that pays tutor expenses for travel. For a round trip up to 200 miles the standard payment is £25, for a round trip of between 200 and 400 miles its £50, and anything over a 400 mile round trip pays £100. What I want is to be able to enter the...
  4. G

    Formula Help Needed - "If Cell Contains Text String, then run this calculation =MAX(((G14-30)*0.5),0)"

    I am working with an expense reimbursement report that takes into consideration several scenarios for mileage: 1. The first 30 miles driven of a total one-way trip are not reimbursed if the employee leaves from his/her residence. 2. If an employee leaves on a trip from the company storage...
  5. J

    mileage rates based on yearly total

    I'm a bit of an excel noob and need help with a formula. I submit mileage expenses monthly. My mileage rate is based on yearly totals: 40 cents/mi for everything up to 5000 miles per year, 20 cents after that. So I need to input the yearly total mileage from the previous monthly report, then...
  6. D

    Lookup text in one column, return date from same row in different column

    Using Excel 2016. In the GMH Table, I am attempting to Lookup "Gas Tank Fill" in Event column of the History Table to return the date from same row in the Out column of the History Table using a table that will advance the formula when the next row is added. =LOOKUP("Gas Tank...
  7. C

    Maximum Miles (Power BI)

    Hi - hope you can help I have two tables. A fact table - Table 1 <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D </thead><tbody> 6 Date Booking Number Post Code 7 01/03/2019 578908 GH 8 01/03/2019 578908 DG 9 01/03/2019 456782 PH 10...
  8. M

    Automating Mileage Form

    Hi, I am wondering if you are able to help me, I am trying to create an automated word documents which take its data from excel to calculate the mileage i travel between clients address just by entering there name, So i would enter client 1 to clients 2 and it would calculate how many miles it...
  9. M

    Sum Rows in Lookup

    My first post. I have two tabs, Assets and Fuel. On the Asset tab I want to total the miles for my three vehicles, Jeep 1, Jeep 2 and Car 1. There are multiple columns on both tabs in addition to the ones I listed; I included only the bare necessities in this example. I have tried vlookup...
  10. T

    Excel Formula Needed

    Hello everyone, I seem to be stumped trying to assemble a formula. I need to total the mileage run by month from one worksheet to another summary worksheet by the month. Basically I have column A called loaded miles driven and in column B I have deadhead miles driven. Column C has the month and...
  11. R

    Calculate Miles Needed

    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...
  12. T

    Formula (or Macro) to caculate if one property is within a 5 mile radius of another?

    Hi Everyone, Not sure if this is possible but I have a list of propertys I downloadd every day. there location is show in Longatude and latatude. I want to know how many are within a 5 mile radius of my Home. also in in Longitude and latitude. So the ideal solution would be two formulas. 1...
  13. R

    Reverse Link

    Hello, I would like to ask for your kind support in solving my not so easy problem. Given City A – City Z distance in miles (one way, by car) City Z – City A distance in miles (the other way, bytrain) Ask: For any given city pairs, find 1. If the A2Z has a counterpart Z2A 2. If there is one...
  14. B

    How to calculate costs, when you have different rates for different criteria?

    I'm looking for some help as whilst I have a basic working knowledge of excel, in my job I'm fast having to get to grips with more complex formulas. I need to work out the total cost for something, where you have a flat rate, and then an additional cost that changes depending on how much of...
  15. J

    Match Column Header then find cell below (offset 1 cell to right) that match another value.

    Each Zip Code listed in row 1 has 4 data elements. I am trying to find the Miles for the Zip listed in row 1 and match it to the zip code 1 column over from it and give me the miles to the right of that. Essentially, I have two cells containing the 1st zip code and another containing the...
  16. I

    Pull rates from another sheet in work book

    I am sure my title is not correct on what I need to do. OK, I have a spreadsheet (work book) that has 2 sheets in it. Points has city and miles. <tbody> <tbody> Points Miles MEMPHIS TN 13 GERMANTOWN TN 18 BARTLETT TN 22 CORDOVA TN 24 COLLIERVILLE TN 27 MILLINGTON TN 29 EADS TN...
  17. L

    Insert Value Based upon Entry into Another Cell

    Hi Everyone, I'm sure this is fairly easy but I just can't figure it out. Information will be entered into Sheet 1, cell E5 which is the mileage from our business to the customer's business. Down in Sheet 1 cell B76, I'm wanting this to then calculate a mileage charge based upon the...
  18. B

    Formula to pick stores with lowest miles?

    Hello, I am hopeful someone will be able to help me with the problem outlined below. I have 2 tables. One table has sales reps and the number of hours in a week they work. <tbody> Rep Weekly Hours Capacity How many hours left? John 38 2 Mary 37 3 Sue 39 1 Bob 40 0 </tbody> My...
  19. T

    Animated Progress Bar For Map

    Morning, I'm looking for suggestions to achieve the following situation: We are having a charity bike rid from John O Grote's to Lands End on a stationary bike. We would like to display the progress from the bike ride on a TV from Excel. So a value of miles done will be entered regularly be it...
  20. B

    Sumproduct problem

    hiya having a little trouble with a Sumproduct formula. Below is what i would like to achieve Cost of journey determine by length 0-29 Miles @ £1.7 30-50 Miles @ £1.6 51-80 Miles @ £1.4 80+ Miles @ £1.3 i have entered the formula (c21 being where i enter the mileage)...

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