So I created a very simple solver model that aims to make the difference of the original contract (Cell F23) and the new contract (Cell N23) equal to ZERO, thus maintaing the total contract amount-makes sense right? And the solver should be changing cell P10 (which is a number that is being added to the quantity of ITEM 9, I do it this way because in the future I might want to try to change two or three items respectfully-always with the same goal: maintaining the total amount of the contract equal to cell F23. I am stuck at this simple (I believe it is simple *sighs*) solver problem.īasically I have a total amount of money in a contract which is cell F23 ($37,257,548.96) and I am trying to redistribute some quantities but maintaining the final TOTAL AMOUNT constant.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |