Results 1 to 7 of 7

Sumproduct tiered rates

Threaded View

  1. 09-01-2015, 07:02 AM #7
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Sumproduct tiered rates

    Another method,

    =SUMPRODUCT(D$3:D$9,B$3:B$9)

    In D3:

    =IF(SUM(C$3:C3)<$D$1,C3,$D$1-SUM(D$2:D2))

    See the attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. working out weekday rates vs weekend rates
    By scott11106 in forum Excel General
    Replies: 3
    Last Post: 08-29-2015, 12:14 PM
  2. Formula for Tiered fee rates
    By sbigelow26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2015, 06:22 PM
  3. [SOLVED] Formula for calculating a value based on tiered percentage rates
    By d_max_c in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-07-2014, 04:04 AM
  4. [SOLVED] Can someone please explain this array formula in this sumproduct function - Tiered pricing
    By thedon_1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-11-2014, 01:47 PM
  5. Tiered tax rates
    By BenVH in forum Excel General
    Replies: 7
    Last Post: 08-17-2011, 08:06 PM
  6. SUMPRODUCT to accurately calculate tiered sequential pricing.
    By JBeaucaire in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2008, 05:32 PM
  7. Expense S/S with tiered rates and minimums
    By arhurdaly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2007, 11:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1