URGENT PLS HELP: Solver, "could not find a feasible solution"

[Fyeung]

Dear All Experts,

I am able to use the Solver to derive the Return % (i.e. my target cell) in Cell E5, while the constraint is set as $E$9 <= $F$9.

However, I encounter the captioned error message when I change the constraint as $E$8 <= $F$8.

Do you have any idea on how to resolve it?

Please kindly advise, thanks.

Best Regards,

Freddy

[Alf]

The problem is not with solver but with your set constraint as solver can’t match that that value i.e. E8 <= 25 000.

The lowest E8 value seems to be 147903 when E5 is -150 %.

Changing the E5 value to -160 % will make E8 = 150546 and testing with E5 -140 % will also set E8 value to 150546.

Alf

[Fyeung]

Dear Alf,

Thanks for your reply and help.

Rgds,
Freddy