Sunday, May 19, 2013

yogi_Assign A Code Based On Criterion Resulting From Combination Of Input Into Several Columns

                                          Google Spreadsheet   Post  #1200
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 19, 2013
user yolty  (!category-topic/docs/spreadsheets/ywbg85R21q0)
assign a code based on value of multiple cells

I would like to compare the value of four different cells in a row and assign a group code based on the combination of values of these cells like so:

There is a gender column and three other columns, all of which are essentially boolean.

What is the best way to accomplish this?  My first thought was a long nested if with comparisons for each possible combination, but I'm sure there must be a way to use arrays or run a query.

Thanks for the help!
following is a solution to the problem