Conditional Concatenation?

[otrevino3]

Not sure whether this would actually be called "conditional concatenation".

I want the following to happen in Column A:

If the value in Column C is "abc", then display "***"+the value in Column B
If the value in Column C is "def", then display "**"+the value in Column B
Else display only the value in Column B

thanks.

 

[colbymack]

=if(c1="abc",concatenate("***",B1),if(c1="def",concatenate("**",B1),B1))

 

[Smitty]

Maybe this:

=IF(C1="abc","***"&B1,IF(C1="def","**"&B1,B1))

Hope that helps,

Smitty

 

[Andrew Poulsom]

Like this?

=IF(C1="abc","***",IF(C1="def","**",""))&B1

 

[rs2k]

Try this
=IF(A1="abc","***"&B1,IF(A1="def","£££"&B1,B1))

Colin

 

[otrevino3]

thanks all!