Concatenating two conditions in a "IF" Formula.

[ringo tan]

Hi,

Can anyone advice me how to concatenate two conditions in a "IF" formula?

Thanks and regards.


Ringo

 

[Frank Kabel]

Hi
do you mean something like
=IF(AND(A1=1,B1=2),"Match","no match")

 

[CLR]

Maybe.....

=IF(AND(A1=1,B1=2),CONCATENATE(A1,B1),"")

Vaya con Dios,
Chuck, CABGx3