+ Reply to Thread
Results 1 to 5 of 5

Calculate Mileage Based on 2 Rates

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    Erie, PA
    MS-Off Ver
    2013
    Posts
    2

    Calculate Mileage Based on 2 Rates

    I am building a mileage expense report and need a formula for the following:

    From 0 to 700 miles, miles are $0.55 each. From 701 miles on they are $0.30 a mile.

    I am having trouble with Excel calculating two different rates.

    Any help would be appreciated.

    Thank you.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculate Mileage Based on 2 Rates

    =0.3 * miles + (0.55 - 0.3) * min(700, miles)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-17-2014
    Location
    Erie, PA
    MS-Off Ver
    2013
    Posts
    2

    Re: Calculate Mileage Based on 2 Rates

    Great! Thanks for the help!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculate Mileage Based on 2 Rates

    You're welcome.

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Calculate Mileage Based on 2 Rates

    Assuming miles are in A1 try this =IF(A1<701,0.55,0.3) * A1

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for HMRC Mileage rates
    By Jinky_uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2013, 01:04 PM
  2. [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
  3. Replies: 5
    Last Post: 10-01-2012, 12:11 PM
  4. Using a formula to calcualte different mileage rates
    By andrewf in forum Excel General
    Replies: 2
    Last Post: 01-17-2012, 11:59 AM
  5. [SOLVED] service invoice for parts, tax, two labor rates,mileage inventory.
    By T&amp;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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1