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     www.energyefficientbuild.com.   May 19, 2013
user yolty  (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/ywbg85R21q0)
assign a code based on value of multiple cells
Hi,

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