Hi,

I having trouble designing a way to only conditionally update a cell. Basically, you choose a scenario/case to run, does about 400 iterations (since the logic has to be circular), and outputs some result.

However, to run one scenario, i will need the results of a previous scenario or "base" case.

I was wondering if there was a way for cells to update only when they see a certain scenario number. For example, the formula looks to another cell containing the scenario number, if that is the correct scenario number it updates the values, else it keeps the last value it had (presumably the "base" case value).

I can do this in VB, but was hoping for a non-macro/non-VB solution.

Thanks.
Sameer