=IF(B1+B2+B3,"Dear "&IF(B1,A1,"")&IF(B1*(B2+B3)," /
","")&IF(B2,A2,"")&IF(B2*B3," / ","")&IF(B3,A3,""),"")
--
David Biddulph

"Sean" wrote in message
...
How could I express the following as a Text string

I have 3 Names in A1:A3 (Jim; Bob; Mike); in B1:B3 is a value of
either 1 or 0 (1;0;1). I wish to construct an opening statement
depending if the values in B1:B3 are 1, so for example if B1=1;B2=0
and B3=1 my opening statement would be:

Dear Jim / Mike

if B1=0;B2=0 and B3=1 my opening statement would be:

Dear Mike

if B1=1;B2=1 and B3=1 my opening statement would be:

Dear Jim / Bob / Mike

if B1=0;B2=0 and B3=0 my opening statement would be:

<blank

I have 5 names in total so haven't put all the permutations above,
perhaps there is not an easy way to do this