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

 

[hsandeep]

hurgadion,
Could not get? Pls refer my 1st & 5th post in this thread.

 

[hurgadion]

I'm sorry, my formula is the answer for the first post...

 

[hsandeep]

I'm sorry, my formula is the answer for the first post...

Ok. But pls HELP. I am waiting.

 

[hurgadion]

If I understand good Yor problem now try the formula for E1:

=COUNTIF(C:C, "<"&X1)

Best regards.

 

[hsandeep]

If I understand good Yor problem now try the formula for E1:

=COUNTIF(C:C, "<"&X1)

Best regards.

I want to COUNT the number of occurences in column C by using criteria if the values are less than X1, Y1 Z1.
X1, Y1 & Z1 are numerical values.
Pls how to accomplish it?

 

[hurgadion]

<min(x1,y1,z1),1,0))<min(x1, Y1,="" Z1),1,0))
<X1)*(C1:c1000<y1)*(c1:c1000<z1),1,0)<min(x1,y1,z1),1,0)<x1,1,0)<min(x1,y1,z1),1,0)<min(x1,y1,z1);1;0)
Try the table formula:

=SUM(IF(MIN(X1,Y1,Z1)>=C:C,1,0))<min(x1,y1,z1),1,0))

Best regarda<min(x1,y1,z1);1;0)

</min(x1,y1,z1);1;0)
</min(x1,y1,z1),1,0))
</X1)*(C1:c1000<y1)*(c1:c1000<z1),1,0)<min(x1,y1,z1),1,0)<x1,1,0)<min(x1,y1,z1),1,0)<min(x1,y1,z1);1;0)
</min(x1,y1,z1),1,0))<min(x1,>

 

[hurgadion]

Better try the table formula:

=SUM(IF((MIN(X1;Y1;Z1)>=C:C)*(C:C<>"");1;0))

The above formula has small mistake (counts empty Cells too),

best regards.

 

[hsandeep]

Sir it is like:

A1=5000 B1=0
A2=10000 B2=175
A3=15000 B3=200

Formula in column D, D1:D999, should get either B1 or B2 or B3 PROVIDED column C has numerical values <=A1, <=A2 or > A3 respectively.
Also COUNT of the different values generated in column C is required in 3 new cells i.e. E1, F1 & G1.

I hope I am more clear now. Please help.

 

[hurgadion]

Hmmm,
I don't understand what do you want exactly. Would you give me an example ?

 

[hsandeep]

A B C D

5000</SPAN>	0</SPAN>	4500</SPAN>	0</SPAN>
10000</SPAN>	175</SPAN>	9999</SPAN>	175</SPAN>
15000</SPAN>	200</SPAN>	10000</SPAN>	175</SPAN>
		5200</SPAN>	175</SPAN>
		15001</SPAN>	200</SPAN>
		15000</SPAN>	No Answer</SPAN>
		10001</SPAN>	No Answer</SPAN>
		99999</SPAN>	200</SPAN>
		12</SPAN>	0</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=3><COL></COLGROUP>