Excel Solver - How to apply whole number/integer constraint to both variable and results?

Copper Contributor

I've a variable A that is used to calculate values B and C

I want to apply a constraint that all A, B, C values should be integer.

How do I now identify one or more (say min) values of A that will meet this constraint?

Can I use Solver or some other Excel function for this purpose?

0 Replies