Hi. Glad to help. Unfortunately, Solver doesn't give error messages
from these types of errors. It just gives up pretty quickly. :(

Just to add. You may find this interesting.
The equation between the two payments is really the following equation,
just rewritten. In general, this is how to select between two values in
Solver.

= Pay1*(1-Bin) + Pay2*(Bin)

When Bin is zero, you get Pay1, and when Bin is 1, you get Pay2.
Solver can keep track of the reason for this particular jump because it
is keeping track of the Bin value internally.

May I make another guess?

I can provide four "2s" in the amount of
time it takes to perform one "1.".

E10 <= 10

I may have the logic wrong here, so this is just being "general."

Your general equation is probably:
1.0 * Type1 + 0.25 * Type2 <= 10

Mathematically, let's multiply by 4.

4 * Type1 + 1 * Type2 <= 40

(This is my personal preference, and from habit from classes in OR.)

We can use the Binary variable to simplify.
What we want is a linear equation to transform
0 - 4, and 1 - 1

= 4 - 3*Bin

When Bin is 0, we get 4, and when Bin =1 we get 1.

So, the new constraint is that the total "time" <= 40.

= = = = = = = =
Anyway, I may be wrong, so just throwing it out if it helps.
Dana DeLouis


wrote:
Dana - Aha - I think you got it. Your guessing - which must be
instinct - was right. The payment column was taking the inputs and
referencing a table (with IF, AND, MATCH...). I see what you mean
about the 'jumps.' Thank you for the find.