+ Reply to Thread
Results 1 to 4 of 4

Calculate rates based on range of miles

  1. #1
    Registered User
    Join Date
    05-28-2008
    Posts
    2

    Calculate rates based on range of miles

    I need to calculate a rate for each truckload (trucking company) given the number of miles on that individual load (miles are predetermined).

    Specifically, for miles = zero to 200 make the price $400, for miles = 201 to 250 make the price $500, and for miles greater than 250 make the price miles times $2.00 per mile.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    If the miles are in A1

    =IF(A1<=200,400,MAX(500,A1*2))

  3. #3
    Registered User
    Join Date
    05-28-2008
    Posts
    2

    Thank You!

    Works perfectly. Thanks a million!

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Re your PM.....if you want another category try

    =IF(A1<=200,400,IF(A1<=225,450,IF(A1<=250,500,A1*2)))

    that assumes that 201-225 miles has a cost of $450. Change as required

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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