How to get solver to return only whole numbers?

Hi everyone,

I'm working on a problem where I have to find the greatest possible revenue by stocking shelves with single cans, 6-packs, and 12-packs. I have it all set up but the answer that solver gives me returns a decimal for number of 12-packs, which isn't possible. Is their a way to make it so solver only returns whole numbers in the answer? I attached the spreadsheet I'm working on if it'll be any help. Thank you

Without looking at your example, add a constraint that the result must be an integer. Various constraints are standard features of Solver.

awesome, that solved it, thank you very much.

Glad it worked, you're welcome.