Concatenate if not -1

[helpneeded123]

Hi I'm trying to concatenate two columns if one of the columns is not -1 and I'm running into some difficulty.

I came up with this formula but it's not being accepted - =IF(AA<>-1,CONCATENATE(A2,AA2),-1))

If column AA is -1, I'd like the concatenate column to remain -1 but if it's not -1, I'd like it to concatenate columns A2 and AA2.

Thanks in advance for any help!
Katie

 

[Rick Rothstein]

=IF(AA2<>-1,CONCATENATE(A2,AA2),-1))

You forgot to include the row number (shown in red above).

 

[helpneeded123]

Thank you! I was so close!