dabug80
asked on
Excel. Applying Incremental Pricing in one Formula
Hi,
I have an incremental pricing table. I am seeking help with a formula that would sum the different incremental pricing levels for a given number of MJs.
See this attached spreadsheet
Thanks for your help.
ee-incremental.xlsx
I have an incremental pricing table. I am seeking help with a formula that would sum the different incremental pricing levels for a given number of MJs.
See this attached spreadsheet
Thanks for your help.
ee-incremental.xlsx
ASKER
Thanks Excel amusant,
I was hoping for a solution that was in one formula without hardcoded values.
Plus, your solution doesn't work if the MJs are changed to another smaller value, like 10.
I was hoping for a solution that was in one formula without hardcoded values.
Plus, your solution doesn't work if the MJs are changed to another smaller value, like 10.
Okay please find below formula and put it in Cell d5.
=SUMPRODUCT(--(D4>{0,3.28,7.67,16.44,16.45}),D4-{0,3.28,7.67,16.44,16.45},{0.298,-0.767,-0.0057,0.0522,0.0605})
ASKER
Hi,
Please don't hard code in the prices. It would be great if these values were referenced from the table.
Please don't hard code in the prices. It would be great if these values were referenced from the table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great. Thanks
Open in new window
Also please see attached example.
ee-incremental.xlsx