Goal Seek ;Solver Function

[Tererai]

Hallo guys

Need help in using solver or goal seek to determine revenue in a cell using solver or goal seek .Have attached the sheet .Have tried to no avail .am clueless .

Kindly assist

Regards

Tererai

 

[Saba Sabaratnam]

Hi

I assume that you are using Average percentage sold per event as variable.

-calculate profit and loss using normal formulas in a cell (say A 20) and refer the cell Set Cell (A20)
-set the target profit To value

Then select average percentage sold per even cell % By Changing Cell and then click ok.

Solver is more complicated and involves constraints.

Kind regards

Saba