Remembering Cell Values

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?

Excel can do almost anything. Give examples.

--
Don Guillett
SalesAid Software
[email protected]
"Don" <[email protected]> wrote in message
news:%[email protected]...
>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?
>

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)


"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> Excel can do almost anything. Give examples.
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Don" <[email protected]> wrote in message
> news:%[email protected]...
>>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?
>>
>
>