Reckon that's just a limitation of Goalseek. You could switch to Solver, or just use a formula in H6:
=((J11+1)*F9 - SUMPRODUCT({100;101;99}%*F6:F8)) / SUM(F6:F8)
Reckon that's just a limitation of Goalseek. You could switch to Solver, or just use a formula in H6:
=((J11+1)*F9 - SUMPRODUCT({100;101;99}%*F6:F8)) / SUM(F6:F8)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks