Table There are two columns with numbers A and B. Please tell me how you can write a formula in column C, so that the letter is placed in the cell according to the conditions in the table?

  • 42 blocks 袝褋谢懈 ? - pavel
  • @pavel 5 blocks 械褋谢懈 and a bunch of 袠袥袠(袠()) - slippyk
  • Thanks for the help! I'll try after 5 IF - Maximus

2 answers 2

In case you do not want hard coding a lot 袠袥袠 :

1) Make groups in the matrix of substitutions (0-4, 0-8) (only needed for clarity) enter image description here

2) Add columns for group A and B on the data sheet ( 械褋谢懈 ) (0-4, 0-8)

enter image description here and so on

3) Use 袠袧袛袝袣小 on the substitution matrix and additional columns (offsets) enter image description here

  • Thank you very much! I have already written in one long line, but this method seems more promising to me, I will try to learn. - Maximus

For a

 =袝小袥袠(袠袥袠(袠(A1<3;B1>2);袠(A1<1;B1>1,8;B1<=2));"A";0)

For B

 =袝小袥袠(袠袥袠(袠(A1>=3;A1<5;B1>2);袠(A1>=1;A1<5;B1>1,8;B1<=2);袠(A1<2;B1>1,1;B1<=1,8));"B";0)

For C

 =袝小袥袠(袠袥袠(袠(A1<9;A1>=5;B1>1,8);袠(A1>=2;A1<5;B1>1,1;B1<=1,8);袠(A1<2;B1>0,5;B1<=1,1));"C";0)

For D

 =袝小袥袠(袠袥袠(袠(A1>=9;B1>-2);袠(A1>=9;B1<=-2);袠(A1>=5;A1<9;B1<=1,8;B1>-2);袠(A1>=3;A1<5;B1<=1,1;B1>-2);袠(A1>=2;A1<3;B1<=1,1;B1>0);袠(A1<2;B1<=0,5;B1>0));"D";0)

For e

 =袝小袥袠(袠袥袠(袠(A1>=2;A1<3;B1<=0;B1>-2);袠(A1>=3;A1<9;B1<=-2));"E";0)

For f

 =袝小袥袠(袠袥袠(袠(A1<2;B1<=0;B1>-2);袠(A1<3;B1<=-2));"F";0)

Putting it all in one expression:

=袝小袥袠(袠袥袠(袠(A1<3;B1>2);袠(A1<1;B1>1,8;B1<=2));"A";=袝小袥袠(袠袥袠(袠(A1>=3;A1<5;B1>2);袠(A1>=1;A1<5;B1>1,8;B1<=2);袠(A1<2;B1>1,1;B1<=1,8));"B";=袝小袥袠(袠袥袠(袠(A1<9;A1>=5;B1>1,8);袠(A1>=2;A1<5;B1>1,1;B1<=1,8);袠(A1<2;B1>0,5;B1<=1,1));"C";=袝小袥袠(袠袥袠(袠(A1>=9;B1>-2);袠(A1>=9;B1<=-2);袠(A1>=5;A1<9;B1<=1,8;B1>-2);袠(A1>=3;A1<5;B1<=1,1;B1>-2);袠(A1>=2;A1<3;B1<=1,1;B1>0);袠(A1<2;B1<=0,5;B1>0));"D";=袝小袥袠(袠袥袠(袠(A1>=2;A1<3;B1<=0;B1>-2);袠(A1>=3;A1<9;B1<=-2));"E";=袝小袥袠(袠袥袠(袠(A1<2;B1<=0;B1>-2);袠(A1<3;B1<=-2));"F";0))))))