jeudi 9 juillet 2020

Concatenate in Goggle sheet if NOT Blank

I have this formula in Google sheets

Basically, I want to concatenate only if Both Cells W2 and AA2 are NOT BLANK.

=IF(AND(NOT(ISBLANK(W2)),NOT(ISBLANK(AA2))),CONCATENATE(H2,"-",AA2),"")

It Concatenate me the cells because i guess W2 and AA2 have some Array formulas.

Is there a workaround this ?

Aucun commentaire:

Enregistrer un commentaire