Maybe.....

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

Vaya con Dios,
Chuck, CABGx3



"ringo tan" wrote:

Hi,

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

Thanks and regards.


Ringo