Formula Help?

[dkenebre]

How do I express the following formula?

If C1, D1 and E1 equal values in Q1:Q12, then W1=HHH,
If C1 and D1 equal values in Q1:Q12 and E1 equal a value in R1:R12,
then W1=HHT,
If C1 and E1 equal values in Q1:Q12 and D1 equal a value in R1:R12,
then W1=HTH,
If D1 and E1 equal values in Q1:Q12 and C1 equal a value in R1:R12,
then W1=THH,
If C1 and D1 equal values in Q1:Q12 and E1 equal a value in S1:S12,
then W1=HHC,
If C1 and E1 equal values in Q1:Q12 and D1 equal a value in S1:S12,
then W1=HCH,
If D1 and E1 equal values in Q1:Q12 and C1 equal a value in S1:S12,
then W1=CHH,
If C1 and D1 equal values in R1:R12 and E1 equal a value in Q1:Q12,
then W1=TTH,
If C1 and E1 equal values in R1:R12 and D1 equal a value in Q1:Q12,
then W1=THT,
If D1 and E1 equal values in R1:R12 and C1 equal a value in Q1:Q12,
then W1=HTT,
If C1 equal a value in Q1:Q12 and D1 equal a value in R1:R12 and E1
equal a value S1:S12, then W1=HTC,
If D1 equal a value in Q1:Q12 and C1 equal a value in R1:R12 and E1
equal a value S1:S12, then W1=THC,
If D1 equal a value in Q1:Q12 and E1 equal a value in R1:R12 and C1
equal a value S1:S12, then W1=TCH,
If C1 equal a value in Q1:Q12 and E1 equal a value in R1:R12 and D1
equal a value S1:S12, then W1=HCT,
If E1 equal a value in Q1:Q12 and C1 equal a value in R1:R12 and D1
equal a value S1:S12, then W1=CHT,
If E1 equal a value in Q1:Q12 and D1 equal a value in R1:R12 and C1
equal a value S1:S12, then W1=CTH
If C1 and D1 equal values in S1:S12 and E1 equal a value in Q1:Q12,
then W1= CCH,
If C1 and E1 equal values in S1:S12 and D1 equal a value in Q1:Q12,
then W1=CHC,
If D1 and E1 equal values in S1:S12 and C1 equal a value in Q1:Q12,
then W1=HCC,
If C1, D1 and E1 equal values in R1:R12, then W1=TTT
If C1 and D1 equal values in R1:R12 and E1 equal a value in S1:S12,
then W1=TTC,
If C1 and E1 equal values in R1:R12 and D1 equal a value in S1:S12,
then W1=TCT,
If D1 and E1 equal values in R1:R12 and C1 equal a value in S1:S12,
then W1=CTT,
If C1 and D1 equal values in S1:S12 and E1 equal a value in R1:R12,
then W1= CCT,
If C1 and E1 equal values in S1:S12 and D1 equal a value in R1:R12,
then W1=CTC,
If D1 and E1 equal values in S1:S12 and C1 equal a value in R1:R12,
then W1=TCC,
If C1, D1 and E1 equal values in S1:S12, then W1=CCC

Example
C,D,E=458
Q1:Q12=095
R1:R12=3718
S1:S12=426
answer for W
*W=CHT*

Thanks

 

[Henry]

dkenebre,

Please explain more clearly.
C,D,E=458???
Does C =458,D =458 & E = 458 or does C=4,D =5 & E=8 or is C+D+E =458???
Q1:Q12=095???
Do all of the 12 cells contain 095 or is the Sum of the 12 cells =95??
The same with R1:R12 and S1:S12???

If we can understand the problem we may be able to answer it.

HTH
Henry

 

[dkenebre]

In the example:
c1=4, d1=5 and e1=8
Yes, Q1:Q12 have been merged and the contain are 095. It is not a sum.
The same is true for R1:R12 and S1:S12