Hi Carim
I'm so sorry for the delay in getting back to you. I'm only back a few days and I'm really not feeding well but lets push on. I'm not sure where are you getting A1. All 3 cells for Solver are located in A23, B23 and C23. I've copied my notes with the settings from Solver and the answer (1.55) if using the 7.77 problem from above to be solved:
[SIZE=12px]Cell A23 = 2[/SIZE]
[SIZE=12px]Cell B42 = A23+7.77 (7.77 have to be entered by macro) [/SIZE]
[SIZE=12px]Cell C23 = A23/2*B5 (B5 have to entered by macro. Cell L23 with 5 in it gets used to refer to cell A5 and use the adjacent cell B5 number of 12.00)[/SIZE]
Solver – Set Target cell: $A$1
Equal To: Min Value of: 0
By changing cell $A$23
Subject to the constraints $B$23 = $C$23
Answer: 1.55