Hi,
I'm trying to automize a pricing table threshold calculation using Sumproduct, but this fails.
I'm stuck.
Cfr the file, it's self-explanatory.
Please help.
Brgds,
Michael
Hi,
I'm trying to automize a pricing table threshold calculation using Sumproduct, but this fails.
I'm stuck.
Cfr the file, it's self-explanatory.
Please help.
Brgds,
Michael
This?= 50Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
No, the result for check = 55 should be : 10 * 4 + 40 * 3 + 5 * 2 = 170
And that would be why? You know how and why you expect that result. I don't. Others may understand but, given you've had 29 views and only my response, Im guessing not.
Let me clarify :
The first 10 Q you buy are priced 4
The next 11 to 50 Q are priced 3
The next 51 to 200 Q are priced 2
Above 200 Q are priced 1
So when you buy 55 Q, this is the calculation :
10 Q * 4 = 40
40 Q * 3 = 120
5 Q * 2 = 10
Result : total 55 Q for 170
How to convert this into one function with Q as input field ?
Last edited by mimijojo; 03-24-2024 at 04:53 PM.
I'm still stuck. Someone available to help ?
Be patient, please. Your last post was in the middle of yesterday evening and it's now only just the start of a new day. AND it's a free forum - you aren't paying for this. Bumping threads should only happen once 24 hours have passed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I found the solution:
Reshuffling the threshold column, adding a new price difference column and compiling these two columns into the sumproduct function now calculates the right result.
Attachment 863984
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Another formula.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks