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.

Sorry for the inconvinience.

-Chr


"Mike H" wrote:

Hi,

I'm not entirely sure what you are trying to do but does this help?

=IF(AND(A1="abc",B1="xyz"),"Do this is true","Do this is false")

Mike

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