If,Then for multiple variables.

E

Eden397

I have 3 columns (Strain, Genealogy, MOComplete) Below is how I would like
the third column (MOComplete) to formulate. Genealogies are descending in
order and I have provided 3 examples of 3 different strains and 3 different
ways the genealogies can occur.

Some of my Strains have 2 different genealogies, some strains have 3
different genealogies, and some strains have 4 genealogies (Max).

The ordering of genealogies is always FS-->PES-->PED-->POOL.

All POOL Genealogies must have an MOComplete=1.

If there are more than 2 genealogies, the genealogy following POOL will NOT
have an MOComplete but the genealogy that is 1 degree away from POOL needs to
have an MOComplete = 1 as does any remaining genealogy(ies).

Is this an If/Then statement? What is a good equation to get the MOComplete
for each strain and each genealogy? Thanks

Strain Genealogy MOComplete
49 FS
49 POOL 1

51 FS 1
51 PES
51 POOL 1

58 FS 1
58 PES 1
58 PED
58 POOL 1
 
M

Mike H.

Things I don't understand about your question:
1. You say pool is always at the bottom, but then you state that anything
following Pool will not have an MOComplete. How can it follow Pool if pool
is always at the bottom?
2. Also you use the word "degree" and I have no idea what you mean by
"degree"
3. I have no idea what equation would be a good one because I can't tell
what you need to calculate. If you can describe the calculation perhaps it
would help.
4. If you calculate by geneology, then I assume it is across all strains?
right? Please be MUCH more specific and I hope to be able to help you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top