Results 1 to 9 of 9

How to calculate multi tier tariff?

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2019
    Location
    Dubai
    MS-Off Ver
    2016
    Posts
    5

    How to calculate multi tier tariff?

    Hi,

    I was looking for a solution for calculating multi tier tariff as shown below:

    For example below, 0-50 units cost 3.50, above 50 up to 100 will cost 3.90, etc. Finally if consumption exceeds 200, total units will be charged rate of 6.10

    Kw Amount
    0-50 3.50
    51-100 3.90
    101-150 4.80
    151-200 5.20
    >200 6.10

    Regards,
    Jishar
    Last edited by jisharka; 05-27-2020 at 01:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multi Tier - Match & Vlookup or INDEX or INDIRECT function help needed
    By yogananda.muthaiah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2016, 12:32 AM
  2. Multi tier lookup tables
    By buckobro in forum Excel General
    Replies: 5
    Last Post: 03-26-2015, 03:44 AM
  3. Multi Tier Chart Forumla
    By pg300 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-17-2012, 08:17 AM
  4. multi tier x axis
    By pg300 in forum Excel General
    Replies: 1
    Last Post: 09-01-2011, 10:49 PM
  5. Replies: 6
    Last Post: 10-01-2010, 04:55 PM
  6. Sum Multi tier selection
    By CLC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2010, 08:16 AM
  7. A Limited Pick List - Multi Tier
    By ComcoDG in forum Excel General
    Replies: 5
    Last Post: 05-29-2008, 02:21 PM

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