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