Writing to cells

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> skrol
> ------------------------------------------------------------------------
> skrol's Profile:
http://www.excelforum.com/member.php...o&userid=27126
> View this thread: http://www.excelforum.com/showthread...hreadid=466483
>

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).