CF in a cell with 6 conditions

[hsandeep]

I want to formulate 6 CFs in a cell B1 to generate either of the value 1,2,3,4,5,6.

6 CFs are to be formulated to generate either of:
CF1=1: A1 is less than B1; B1 is less than C1 and A1 is less than C1
CF2=2: A1 is less than B1; B1 is greater than or equal to C1 and A1 is less than C1
CF3=3: A1 is less than B1; B1 is greater than or equal to C1 and A1 is greater than or equal to C1
CF4=4: A1 is greater than or equal to B1; B1 is greater than or equal to C1 and A1 is greater than or equal to C1
CF5=5: A1 is greater than or equal to B1; B1 is less than C1 and A1 is greater than or equal to C1
CF6=6: A1 is greater than or equal to B1; B1 is greater than or equal to C1 and A1 is less than C1



What should the formula be in the CF? Thanx in adv.

 

[hsandeep]

Yes table in thread#20 combined with a portion of table (column R,S,T) in thread#19 is best to follow. I am working on it & would revert back with the outcome. Thanks for the help rendered.

 

[shg]

You're welcome.

 

[shg]

I'm embarrassed to need to post this -- yet another correction:

	A​	B​	C​	D​	E​
1​	0​	1​	2​	1​	D1: =LOOKUP(9*SIGN(A1-B1) + 3*SIGN(B1-C1) + SIGN(A1-C1) + 14, {1,4,7,8,9,10,14,18,19,20,21,24,27}, {1,4,7,8,9,10,14,18,19,20,21,24,27})
2​	0​	1​	1​	4​
3​	0​	2​	1​	7​
4​	0​	1​	0​	8​
5​	1​	2​	0​	9​
6​	0​	0​	1​	10​
7​	0​	0​	0​	14​
8​	1​	1​	0​	18​
9​	1​	0​	2​	19​
10​	1​	0​	1​	20​
11​	2​	0​	1​	21​
12​	1​	0​	0​	24​
13​	2​	1​	0​	27​

 

[hsandeep]

No problem at all. Well taken bro...