Hello,
I am a complete Excel novice tasked with creating a form that contains three questions, the answer to each is either High or Low. Based on the answers, there are 8 possible outcomes e.g.
Low - Low - Low = Type 8
High - High - High = Type 7
Low - High - High = Type 6
High - High - Low = Type 5
High - Low - High = Type 4
Low - High - Low = Type 3
Low - Low - High = Type 2
High - Low - Low = Type 1
I created drop down boxes for each with either Low or High but no idea how to make the next cell determine the type based on the 3 answers? Any help would be much appreciated
I am a complete Excel novice tasked with creating a form that contains three questions, the answer to each is either High or Low. Based on the answers, there are 8 possible outcomes e.g.
Low - Low - Low = Type 8
High - High - High = Type 7
Low - High - High = Type 6
High - High - Low = Type 5
High - Low - High = Type 4
Low - High - Low = Type 3
Low - Low - High = Type 2
High - Low - Low = Type 1
I created drop down boxes for each with either Low or High but no idea how to make the next cell determine the type based on the 3 answers? Any help would be much appreciated