EXCEL Solver: Constraint equals one of two values (0 or 100)?

Hi all,

I was wondering if anyone knew of a way to set up Solver in order to maximise revenue, but with the constraints equalling ONLY one of two values (e.g. 0 or 100)?

Is there a work around for this?

Many thanks to all in advance,

Dave

Try setting for example B4 as binary and "C4=100*B4" then C4 can only be 0 or 100.

Alf