Hi,

No. you didnt understand my requirement.

only one condition.

if A1 = "ABC" (if it is true) then overwrite the cell B1 as "XYZ", if th
condition is false then take the value of a1 into d1 (I entered the formula
in D1)

=if(A1="ABC",B1="XYZ",A1)

if the condition is true then overwrite the value "XYZ" in cell B1

-Chr
"NPell" wrote:

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," ")