You won't be able to do that. A formula returns a result to the cell
that it sits in, so it would have to be in column A in order to return
a value there. Consequently, it cannot refer to itself (circular
reference).

However, if you put the formula in C2, then you could have this:

=IF(AND(A2="C",B2="BSY"),"W","")

This will return a "W" in C2 if the two conditions are met, otherwise
C2 will appear blank.

Hope this helps.

Pete

On Sep 19, 3:03*pm, MayJuneJuly
wrote:
Could you help me to write and if-and-then statement?

example:
Col A * *Col B

* C * * * BSY

I am trying to have the statement read: IF Column A = C AND Column B = BSY,
THAN Column A = W