Concatenating with an "IF" Statement

[Diane Hogue]

I have a spreadsheet containing to/from text messages between a suspect and a victim. I am able to concatenate several of the columns to create a "description" column. One of the conditions in the description needs to be an IF statement: IF(B2="Incoming","from","to")


The string would be something like this: =CONCATENATE(B2,"text message", " ", [conditional statement to or from],"victim")

I think I understand that it is not possible to put an IF statement in the middle of another string, but I don't know how to place it at the beginning and then do the concatenation part.

Any suggestions would be appreciated.

Diane

[Bo_Ry]

Please try at C2
=CONCATENATE(A2," text message ",IF(A2="Incoming","from","to")," victim")

Or
=A2&" text message "&IF(A2="Incoming","from","to")&" victim"

[Diane Hogue]

Thank you, Bo_Ry!! I thought I tried that exact string before, but it didn't work. Obviously, I had some part of it out of place. I appreciate you sooooo much!!!!!!

Diane