Concatenating two conditions in a "IF" Formula.

ringo tan · Dec 1, 2004

Hi,

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

Thanks and regards.

Ringo

Frank Kabel · Dec 1, 2004

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

CLR · Dec 1, 2004

Maybe.....

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

Vaya con Dios,
Chuck, CABGx3