View Single Post
 
Old 01-13-2017, 01:12 PM
H28Sailor H28Sailor is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Mar 2013
Posts: 55
H28Sailor is on a distinguished road
Default 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
Reply With Quote