Nested IF

[hsandeep]

In 2 col, I m having either 0 or 1. In 3rd column i want to do the check (permutations & combinations).
It is like:
0 0 A
0 1 B
1 0 C
1 1 D
How to do it?
Also, how to count nos. of A, B, C & D generated?
Thanx in adv

 

[davesweep]

Hi,

Does this

=INDEX({"A","B","C","D"},1+BIN2DEC(A1&B1))

or this

=INDEX({"A","B","C","D"},MATCH(VALUE(A1&B1),{0,1,10,11},0))

work for you?

You could use

=COUNTIF(C:C,"A")

to return the number of "A" generated.

 

[mikerickson]

=choose(2*a1+b1+1,"a","b","c","d")

 

[hsandeep]

INDEX({"A","B","C","D"},MATCH(VALUE(A1&B1),{0,1,10,11},0))

& even choose(2*a1+b1+1,"a","b","c","d") WORKS.

Which one would be "more comfortable"?

 

[hsandeep]

In
INDEX({"A","B","C","D"},MATCH(VALUE(A1&B1),{0,1,10,11},0))
instead of A, B, C & D, I want to get the numerical value lying in F1, G1, H1 & I1. How to accomplish it?

 

[davesweep]

Index(f1:i1,match(value(a1&b1),{0,1,10,11},0))

 

[hsandeep]

Done Sir..davesweep. Thanks a lot.

 

[davesweep]

No worries.

 

[hsandeep]

Index(f1:i1,match(value(a1&b1),{0,1,10,11},0))

I got the the numerical value lying in F1, G1, H1 & I1.
I got these values in column C.
Now, how to check the "COUNT" of values in column C are less than the numerical value lying in X1, Y1 & Z1?

 

[hurgadion]

Hi, You can try the formula:

=CHAR(65+BIN2DEC(A1&B1))

also,

best regards.