Remembering Cell Values

D

Don

I want to change the value of cell-A conditioned on the value of another
cell, however if the condition fails I want the value of cell-A to be
unchanged.

In other words, I want cell-A to remember the value from the last time the
condition was met.

It sounds like setting a global variables might accomplish this, but I don't
think Excel has this capability.

I don't know VBA.

Any ideas?
 
D

Don

Example:

I want Cell-A to copy Cell-B if Cell-C="yes". Else, I want Cell-A to stay at
it's last value.

Cell-B=5
Cell-C=yes
Cell-A=5 (condition met so value of Cell-A copied from Cell-B)

Later:
Cell-B=6
Cell-C=xyz (not "yes")
Cell-A=5 (stays at last value that last met condition)

Still later:
Cell-B=6
Cell-C=yes
Cell-A=6 (condition met so value of Cell-A copied from Cell-B)
 
Top