concatenate IF

[GIROEN]

Hello

I have done a formula and I do have two small problem.

Is it possible to shorten the formula?
=CONCATENATE(IF(B4="x";$B$3;"");"/" &IF(C4="x";$C$3;"");"/"& IF(D4="x";$D$3;"");"/"& IF(E4="x";$E$3;"");"/"& IF(F4="x";$F$3;"");"/"& IF(G4="x";$G$3;"");"/"& IF(H4="x";$H$3;"");"/"& IF(I4="x";$I$3;"");"/"& IF(J4="x";$J$3;"");"/"& IF(K4="x";$K$3;"");"/"& IF(L4="x";$L$3;"");"/" & IF(M4="x";$M$3;"");"/"& IF(N4="x";$N$3;"");"/" & IF(O4="x";$O$3;"");"/"& IF(P4="x";$P$3;""))

I would like to have shown in the cell A4 the value of B3 to P3 with a slash separating the value. But for the moment it shown me all the slash see excel sheet attached.

Thanks a lot for your help

[Aardigspook]

Welcome to the forum.
This will get rid of the multiple slashes:

Please Login or Register  to view this content.

The & symbol does the same as the Concatenate function.

The last course will still have a slash after it, unless that's P3. It's possible to get rid of that too, but it would make the formula a lot more complicated as it would have to check throughout for the next result as well.

Hope that helps.

Edit: I see you have semi-colons not commas in your formula, so:

Please Login or Register  to view this content.

[Phuocam]

Try this:

=REPLACE(CONCATENATE(IF(B4="x","/" &$B$3,""),IF(C4="x","/"&$C$3,"")),1,1,"")

[GIROEN]

Hello Aardigspook

Thanks a lot it works

Brgds Giro