Concatenation or if Statement

[clemkonan]

Here is my data :
A1= Sequential number
B1 = Part ID
C1 =Area
D1= Target

So that :
A2 = 500
B2 = 500-G
C2= Production office
D2 = Office Door
E2 = Glass

I want to generate B2 by having an if formula that if E2 =glass than add the suffix "-G" ro A2 so that it becomes 500-G,otherwise add suffix"-BR" which then generates 500-BR.

So I end up with a list of parts that are either Glass or brittle plastic and I hyperlink the part number to the picture.

I guess I will have to hide column A

Thanks in advance

 

[Joe4]

Try:

=A2 & IF(E2="Glass","-G","-BR")

 

[jtakw]

Nvmd

 

[admiral100]

Hi,

Maube this :-

=IF(E2="glass",A2&"-G",A2&"-BR")