miles

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

<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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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