I'm very new to excel, only did basic stuff in high school and that was almost 10 years ago. What I'm searching for is a way to have cells B12:B15 display a value that is not greater than 1,000 and not less than 0. The combined total of cells B12:B15 can not exceed 2,000. They will each have their own different number. but yeah, I've been at this for about 2 hours now searching, gave up and decided to ask lol. Also, Each cell in the array B12:B15 will have another calculation like that needs to be equal to this.

B12 is =SUM(C12*.6653) This can not exceed 1000
B13 is =SUM(C13*.5882) This can not exceed 1000
B14 is =SUM(C14*.7272) This can not exceed 1000
B15 is =SUM(C15*.6150) This can not exceed 1000

As stated above, the combined total of all of these can not exceed 2000 and i will basically need to get as close to it as possible staying within the rules.
Anyways, if there's a way to find that, that would be awesome. Also, sorry if this has been asked before XD