+ Reply to Thread
Results 1 to 4 of 4

taxi fare equation help

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    minneapolis
    MS-Off Ver
    new
    Posts
    14

    taxi fare equation help

    hello. Im sorry but could you help me.

    I need an excel equation for the first 3 miles at $7.87 per mile, $3.50 per mile for the next 7 miles and $3.25 per mile after that. Then multiplied by 1.27 (27 percent) which is actually the total of a 3%, 11% and 13% charge. could you help me?

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: taxi fare equation help

    If cell B5 = total distance travelled, then taxi fare = (MIN(B5,3)*7.87+MIN(MAX(B5-3,0),10-3)*3.5+MAX(B5-10,0)*3.25)*1.27
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2020
    Location
    minneapolis
    MS-Off Ver
    new
    Posts
    14

    Re: taxi fare equation help

    Thanks. I’ll try that.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: taxi fare equation help

    In the future please post a sample sheet ( see yellow banner) with some data and manually calculated examples.
    Thanks

+ 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. Help with Fare Calculator!
    By Asaiki in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-29-2018, 09:38 PM
  2. Cross checking published fare with actual sales
    By Hiruy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-10-2017, 10:30 AM
  3. Taxi fare calculator problem
    By TomThorn in forum Excel General
    Replies: 4
    Last Post: 10-23-2015, 02:03 PM
  4. [SOLVED] New fare
    By Anjukeerthi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2015, 08:02 AM
  5. Mileage tariffs for a taxi
    By tomkilbourn in forum Excel General
    Replies: 21
    Last Post: 07-23-2009, 10:10 AM
  6. Fare Share Distribution Algorithm
    By bernsky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2007, 10:51 PM
  7. taxi driver accounts template
    By Dave in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-06-2006, 07:25 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