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.