Writing to cells

[skrol]

Good Morning,
How can I write to cells, without using VBA.
Supose I have 3 cells A1, A2 and A3.

A1 = "something"
A2 = "Yes" or "No"

Now I would like a "formula" in A3, that changes the content of A1 to
"Anything" if A2 = "Yes".
If A2 = "No" , the content of A1 remains.

The instruction in A3 must be able to "destroy" the content of A1.

So I'm NOT looking for something in A1 like:
=if(A2="Yes";"Anything";"Something")

Thanks.

S.Krol

 

[Paul B]

skrol, a formula cannot change the content of a cell, so this cannot be done
without VBA

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[skrol]

Thanks Paul,
But I keep on trying how (eventualy) I can manage this.
That's the way to discover things, prove (or not) that something that
is considered inpossible, was possible.

But I'm afraid you are right.............

(Many roads are leading to Rome).