Results 1 to 10 of 10

formula for mileage - various rates

Threaded View

  1. 11-19-2019, 03:10 PM #1
    edengarden
    edengarden is offline
    Registered User
    Join Date
    11-19-2019
    Location
    dublin
    MS-Off Ver
    365
    Posts
    4

    formula for mileage - various rates

    Hi

    I'm trying to do a mileage expense formula based on the following (i'm not sure if my attachment will load up)

    Km cent

    Rate 1 0 - 1500 44.79
    Rate 2 1501 - 5500 83.53
    Rate 3 5501 - 25000 32.21
    Rate 4 25001 - 25.85


    Total Mileage to date 9500



    Can anyone help with a formula. I'm guessing it's an IF formula rather than a vlookup?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating Mileage rates based on different rates depending on cumulative miles travelled
    By mcadde83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2020, 12:22 PM
  2. [SOLVED] Help with creating excel spreadsheet for calculating mileage with multiple rates
    By Annahstar in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-29-2016, 01:18 PM
  3. Calculate Mileage Based on 2 Rates
    By jbondbmw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2014, 09:21 PM
  4. Formula for HMRC Mileage rates
    By Jinky_uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2013, 01:04 PM
  5. [SOLVED] Mileage Log and Reimbursement Form with Split rates
    By robiniwitz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-28-2012, 02:26 PM
  6. Using a formula to calcualte different mileage rates
    By andrewf in forum Excel General
    Replies: 2
    Last Post: 01-17-2012, 11:59 AM
  7. service invoice for parts, tax, two labor rates,mileage inventory.
    By T&M Petro Mike B. in forum Excel General
    Replies: 0
    Last Post: 01-19-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1