combining cells with multiple choices
Hi
I am using the following formula for combing cells where there is only one choice
=IF('1'!AY2=1, "Mon",IF('1'!AZ2=1, "Tues",IF('1'!BA2=1, "Wed",IF('1'!BB2=1, "Thurs",IF('1'!BC2=1, "Fri",IF('1'!BD2=1,"Sat","Sun"))))))
What do I need to change if it is a multiple choice question with any number of choices chosen
i.e. output something like
Mon + Tues + Sun
Bob M
|