+ Reply to Thread
Results 1 to 3 of 3

................

  1. #1
    Registered User
    Join Date
    12-06-2021
    Location
    Prince Edward Island, Canada
    MS-Off Ver
    2019
    Posts
    2

    Post ................

    ........................
    Last edited by mmtaylor23; 12-07-2021 at 10:51 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Mileage sheet with 3 different rates for different kilometre ranges

    if you create a blank row as row 7
    so 8 is 01-apr-21
    i8=IF(G8>19,MIN(8000,H8)*$I$6-SUM($I$7:I7),0)
    j8=IF(AND(H8>8000,G8>19),MIN(8000,H8-8000)*$J$6-SUM(J$7:J7),0)
    k8=IF(AND(H8>16000,G8>19),MIN(16000,$H8-16000)*$K$6-SUM(K$7:K7),0)

    if you had put the km limits in cells they would not need to be hard coded and the formula could have been copied across

  3. #3
    Registered User
    Join Date
    12-06-2021
    Location
    Prince Edward Island, Canada
    MS-Off Ver
    2019
    Posts
    2
    .......................
    Last edited by mmtaylor23; 12-07-2021 at 10:55 AM.

+ 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. Replies: 3
    Last Post: 12-08-2020, 12:22 PM
  2. formula for mileage - various rates
    By edengarden in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-19-2019, 08:44 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

Tags for this Thread

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