If function with And as well.

[wallyxl]

Hi everyone,
I don't think this is a hard question, I just can't seem to find it on the net.

I want to do a basic if function which incorporates AND.

Cell A1 value equals x
Cell A2 value equals x

Formula for A3 to read, if A1 is x and A2 is x then return "MATCH",""

I'll kick myself when I see it, any help will be great.

Thanks.

 

[Sektor]

=IF(AND(A1="x",A2="x"),"MATCH","NO MATCH")

 

[wallyxl]

Sektor,
THANK YOU.

I was trying to put the AND between A1 and A2, I knew I would kick myself.

Have a good day buddy.