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