Cell C1 takes is value from any one of three other cells depending on the
value of cell B4. The if statement I should like to writr would go something
like this

if(b4=1,b1&if(b4=2,b2&if(b4=3,b3)))

Is this syntax correct?

Many thanks

Dave