Forum Discussion
Automatic calculation
I need to set up an excel sheet which should give me automatic results like the following: 1 piece should cost 15p and so on till 25pcs, then 25 pcs should cost 14p and so on till 50 pcs, then 50 pcs should cost 13p and so on
PPLON Created a mock-up on the basis of your picture. Using SUMPRODUCT, some named (helper) ranges (in blue) will give you what you need, I believe. The formula is in B18 (green).
If not, please come back with some example calculations. It could be as easy as adjusting the lower boundaries of the various rate groups.
3 Replies
PPLON Created a mock-up on the basis of your picture. Using SUMPRODUCT, some named (helper) ranges (in blue) will give you what you need, I believe. The formula is in B18 (green).
If not, please come back with some example calculations. It could be as easy as adjusting the lower boundaries of the various rate groups.
Riny_van_Eekelen Looks great will go through, thanks so much for your help
Please see example
