Hi,
Please see the spreadsheet file attached.
What I am trying to get is the value of the RED CELL when the YELLOW CELL = 0.
The two GREEN CELLS values depend on the two macros/goalfinders which are in its same lines (on the right).
Please, note that the YELLOW CELL equation contains all the values that it has over it, including the ones in RED and GREEN CELLS.
Basically I would need to run a GoalFinder for YELLOW CELL = 0 changing the RED CELL, but I donīt know how to do that in this particular case.
Thank you very much for your help.
Bookmarks