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:
https://docs.google.com/
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
No comments:
Post a Comment