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:

[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][/tr]
[tr][td]

1​

[/td][td]

0​

[/td][td]

1​

[/td][td]

2​

[/td][td]

1​

[/td][td]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})[/td][/tr]

[tr][td]

2​

[/td][td]

0​

[/td][td]

1​

[/td][td]

1​

[/td][td]

4​

[/td][td][/td][/tr]

[tr][td]

3​

[/td][td]

0​

[/td][td]

2​

[/td][td]

1​

[/td][td]

7​

[/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

0​

[/td][td]

1​

[/td][td]

0​

[/td][td]

8​

[/td][td][/td][/tr]

[tr][td]

5​

[/td][td]

1​

[/td][td]

2​

[/td][td]

0​

[/td][td]

9​

[/td][td][/td][/tr]

[tr][td]

6​

[/td][td]

0​

[/td][td]

0​

[/td][td]

1​

[/td][td]

10​

[/td][td][/td][/tr]

[tr][td]

7​

[/td][td]

0​

[/td][td]

0​

[/td][td]

0​

[/td][td]

14​

[/td][td][/td][/tr]

[tr][td]

8​

[/td][td]

1​

[/td][td]

1​

[/td][td]

0​

[/td][td]

18​

[/td][td][/td][/tr]

[tr][td]

9​

[/td][td]

1​

[/td][td]

0​

[/td][td]

2​

[/td][td]

19​

[/td][td][/td][/tr]

[tr][td]

10​

[/td][td]

1​

[/td][td]

0​

[/td][td]

1​

[/td][td]

20​

[/td][td][/td][/tr]

[tr][td]

11​

[/td][td]

2​

[/td][td]

0​

[/td][td]

1​

[/td][td]

21​

[/td][td][/td][/tr]

[tr][td]

12​

[/td][td]

1​

[/td][td]

0​

[/td][td]

0​

[/td][td]

24​

[/td][td][/td][/tr]

[tr][td]

13​

[/td][td]

2​

[/td][td]

1​

[/td][td]

0​

[/td][td]

27​

[/td][td][/td][/tr]
[/table]

 

[hsandeep]

No problem at all. Well taken bro...