# mileage

1. ### Result based on criteria fro 2 lists

Please can someone advise me the best way to go around this scenario. To help ease calculations for a mileage report I want to put together. I am thinking I will have 2 lists that generate a result (you maybe able to advise a better way?) – a list of clients (going from) and a list of clients...
2. ### Getting value from a different tab (How to make my current formula drag down?)

Hello! I made a formula to display the latest value entered in a column on a different tab. In the column on “Sheet2,” an employee enters the new amount of mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns)...
3. ### 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...
4. ### Multiplication

This probably sounds very simple but I'm stumped. So in the first column I have my mileage rate which is 0.25p per mile then I my full row of values of mileage (300, 180, 120). Then the last cell of the row I want to multiply each value by my 0.25 to give me a total. I've got it to work by...
5. ### 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. ### Copy/Paste to Add Sum of Cells Across Separate Workbooks

I have a master worksheet which is generated automatically at the end of the week by our system, which logs tips and mileage collected by each employee. We have deliveries which take place outside of our system which also need to be recorded, but cannot be logged by the system, so they need to...
7. ### Using sum function across multiple worksheets of varying column sizes

Hi I'm a basic excel user, and I need to sum a column of data (Vehicle Mileage in Column F) across multiple sheets (all in the same column) however the columns of data are of varying length which is what I'm having the problem with because I need to print these sheets and I want the total just...
8. ### 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. ### Why are my 3 message boxes repeating twice?

Hi My 'Daily Tracking' worksheet has the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("EntRng")) Is Nothing Or Target.Count > 1 Then Exit Sub ' PROCEDURE 1 With Worksheets("Training Log") MsgBox "Lifetime Mileage: " &...
10. ### Four Criteria Mileage Calculation

Hi Folks Hope you can help me with my calculation please? Much appreciated for any assistance you can offer me on this. <tbody> Enter Mileage Claim Here 1500 KM Four Criteria Mileage Calculation Band €/KM KM Range Distance KM € Text 1 €0.4479 0 to 1500...
11. ### Formula calculating two criteria and adding together

Hi there excel gurus How do I write a formula for an invoice that will calculate the following mileage: mileage up to <=200km the rate is .50c, remaining mileage >200km rate is .35c - the formula will be in one cell looking at the quantity in the next cell. So for anything over 200km the...
12. ### Some calculations do not calculate

I have a spreadsheet that has short (50-80) rows with 7 columns. 2 columns are used to calculate data. Calculations use Google Maps to get mileage from one point to another point. The calculations either work or don't work. That is, the calculated cells either have the correct mileage or have a...
13. ### 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...
14. ### Mileage Dilema

I have a nephew that plays different country music gigs. He wasn't aware that he could claim the mileage on his truck to the IRS. There's no chance that I can get him to remember to write down his starting and ending mileage for each gig, but he posts all of his locations. What I need is a...
15. ### Text in one row auto fills a number of cells

I have spent a whole day trying to find an answer to this problem and my head now hurts!:eeek: I have a work expenditure sheet that I fill in and the problem I would like automated is in column B I enter some text Salary, Mileage, Subsistence etc. this then auto fills 2 cells on the same row...
16. ### Send a single e-mail to multiple recipients if certain cell is not populated with a value

I have a list of e-mail addresses in column D. Column B populates from a query as mileage reports are received from employees. Until a report is received and captured by the query, the cell shows "#N/A" (A VLookup with no result yet.) I would like to send a single e-mail reminder to all...
17. ### Lookup value at intersection of two locations in mileage chart

I have an expense form that includes a mileage chart. I have "From Branch" and "To Branch" columns, each of which uses the same list of branches as data validation. <tbody> From To Mileage Main Ditch Road 12.51 The Other Branch Main 16.86 </tbody><colgroup><col><col><col></colgroup> I...
18. ### Drop down list question

I enter my mileage onto a spreadsheet for various garages. I wish to have a drop down list with the garages name & miles to & from there. In the drop down list i would need to see the name of the garage & also the miles BUT when i make my selection i would only require the mileage to be entered...
19. ### Returning data from a matrix table using multiple criteria

Hi there New to the forum, hoping you can help! I have numerous matrix tables showing miles per gallon (which varies with mileage and tonnage). Each vehicle registration number has its own table. I want to return values from those tables based on criteria. See below. As you can see, the...
20. ### Help! Creating a formula.

Hello geniuses! I need help calculating a formula for a mileage log sheet. The information below is what I will be working with: Types of Rides: Ambulatory (A) Share Ride with Ambulatory (SA) Wheel Chair (W) Share Ride with Wheel Chair (SW) These rides are attached to set rates that are...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...