Got it!
Change formula in range G12 to
=IF(G15=0;0;(D12*D3+E12*E3+F12*F3)/G15)
and make the same adjustment to G13 and G14
Don't know if you use ";" or "," in formulas in Belgium so change if needed. Select "GRG Nonlinear" and run Solver.
As this seems to solve your problem don't forget to mark your thread solved and if you like to give a rating to my answer click on the small star (bottom left) in my post.
Alf
Ps
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
Bookmarks