Solver Not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-2341133%22%20slang%3D%22en-US%22%3ESolver%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2341133%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20basic%20problem%20for%20Solver%2C%20and%20for%20some%20reason%20it%20isn't%20working%2C%20see%20attached.%20It%20is%20for%20a%20Formula%201%20Fantasy%20pool%20I%20am%20in%2C%20I%20was%20interested%20to%20see%20the%20results.%20I%20want%20solver%20to%20select%205%20drivers%20and%201%20team%2C%20where%20it%20maximizes%20total%20points%2C%20without%20exceeding%20a%20total%20cost.%20I%20haven't%20got%20around%20to%20adding%20a%20feature%20where%20repeat%20drivers%20are%20not%20allowed%2C%20but%20even%20still%2C%20Solver%20comes%20back%20with%20an%20error.%20Thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2341133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a basic problem for Solver, and for some reason it isn't working, see attached. It is for a Formula 1 Fantasy pool I am in, I was interested to see the results. I want solver to select 5 drivers and 1 team, where it maximizes total points, without exceeding a total cost. I haven't got around to adding a feature where repeat drivers are not allowed, but even still, Solver comes back with an error. Thoughts?

 

Thanks,

0 Replies