surminderbains
New member
- Joined
- Sep 15, 2015
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hi Experts,
I'm looking for the maximum revenue. I have already setup everything in the following excel.
(If there are formulas with WENN replace them with IF but there shouldn't.)
To the row C (Origin) I would like to add or subtract values according to the min and max values in the row a and b, but only that much that the gap between to values is a max of 25 (or -25).
The values should be added or subtracted by the prices. Negativ prices should suggest to subtract and positiv to add.
The value which is add or subtracted and the prices equal the revenue.
All revenue in the sum should be maximized.
It's complicated to write, but If you see the excel you should understand what I mean.
To solve the problem I have used the solver.
It should maximized the cell H10.
For the any infringement of rules its if check Cell E10 = 0.
And the values which should be add on or subtracted are in the cells D2 to D9
The solver finds a result, but not the maximum.
I want to find the maximum.
Do you see any mistakes or should I solve this problem in a other way.
Thanks for help
Surminder
I'm looking for the maximum revenue. I have already setup everything in the following excel.
(If there are formulas with WENN replace them with IF but there shouldn't.)
To the row C (Origin) I would like to add or subtract values according to the min and max values in the row a and b, but only that much that the gap between to values is a max of 25 (or -25).
The values should be added or subtracted by the prices. Negativ prices should suggest to subtract and positiv to add.
The value which is add or subtracted and the prices equal the revenue.
All revenue in the sum should be maximized.
It's complicated to write, but If you see the excel you should understand what I mean.
To solve the problem I have used the solver.
It should maximized the cell H10.
For the any infringement of rules its if check Cell E10 = 0.
And the values which should be add on or subtracted are in the cells D2 to D9
The solver finds a result, but not the maximum.
I want to find the maximum.
Do you see any mistakes or should I solve this problem in a other way.
Thanks for help
Surminder