Hi,
Any help you can offer would be appreciated as this one is making me bald...an unattractive concept for a redhead.
I'm trying to build a sumproduct equation to calculate a waterfall tiered pricing system.
There are two worksheets, "Calculations" which is the working spreadsheet and "Tiers" which holds the actual tiered information so that future adjustments can be done cleanly.
My equation is =SUMPRODUCT(--(E2>Tiers!$C$3:$C$5),E2-Tiers!$C$3:$C$5,Tiers!$D$3:Tiers!$D$6)
I based this on models found at http://mcgimpsey.com/excel/variablerate.html
The first two arrays work but the equation is slogging on the third.
Calculations test variable is E2 = 61.19 hours
Tiers is as follows:
- A B C D
1 Tiers | Hours | range | Billing per hour
2 >= <
3 1 0 20 100
4 2 20 50 75
5 3 50 75 65
6 4 75 55
Any help you can offer would be appreciated as this one is making me bald...an unattractive concept for a redhead.
I'm trying to build a sumproduct equation to calculate a waterfall tiered pricing system.
There are two worksheets, "Calculations" which is the working spreadsheet and "Tiers" which holds the actual tiered information so that future adjustments can be done cleanly.
My equation is =SUMPRODUCT(--(E2>Tiers!$C$3:$C$5),E2-Tiers!$C$3:$C$5,Tiers!$D$3:Tiers!$D$6)
I based this on models found at http://mcgimpsey.com/excel/variablerate.html
The first two arrays work but the equation is slogging on the third.
Calculations test variable is E2 = 61.19 hours
Tiers is as follows:
- A B C D
1 Tiers | Hours | range | Billing per hour
2 >= <
3 1 0 20 100
4 2 20 50 75
5 3 50 75 65
6 4 75 55
Last edited: