On Apr 22, 10:12*am, Christopher Naveen
wrote:
Hi,

Let me explain u in words. if cell A1 is "ABC" then overwrite the cell b1 as
"XYZ" (cell B1 may contain some value, I need to overwrite it as "XYZ") and
if the condition is false then take the value of A1. (Formula I entered in
D1).

I hope now u can understand my requirement.

-Chr



"Pete_UK" wrote:
Please explain in words what you are trying to do.

Pete

On Apr 22, 9:10 am, Christopher Naveen
wrote:
Hi,

I am trying with if condition but it returns some error. Pls refer the below
formula.

A * * * *B * * * *C * * * * D
ABC * *XYZ * * * * * * *
DEF * * * * * * * * * * * * *DEF

I am entering the formula in D1
=if(A1="ABC",B1="XYZ",A1)

Can anyone help me with the above formula.

Thanks in advance!

Chr.- Hide quoted text -

- Show quoted text -

How I am understanding this is.
Condition a) A1 = "ABC"
Condition b) B1 = "XYZ"
If both Condition's are TRUE, then D1 needs to equal the contents of
A1.

If this is correct, then you need IF plus the AND function..
=IF(AND(A1="ABC",B1="XYZ"),A1," ")