Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
4.2 kB
4
Indexable
Never
=IF(E19="Junior";
IF(AND(G19/F19<0,3);'Data base'!$C$11;
IF(AND(G19/F19>=0,3;G19/F19<0,5);VLOOKUP(MAXIFS('Data base'!$B$11:$B$12;'Data base'!$B$11:$B$12;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE);
IF(AND(G19/F19>=0,5;G19/F19<0,75);VLOOKUP(MAXIFS('Data base'!$B$11:$B$13;'Data base'!$B$11:$B$13;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE);
IF(AND(G19/F19>=0,75;G19/F19<0,85);VLOOKUP(MAXIFS('Data base'!$B$11:$B$14;'Data base'!$B$11:$B$14;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE);
IF(AND(G19/F19>=0,85;G19/F19<1);VLOOKUP(MAXIFS('Data base'!$B$11:$B$15;'Data base'!$B$11:$B$15;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE);
IF(AND(G19/F19>=1;G19/F19<1,25);VLOOKUP(MAXIFS('Data base'!$B$11:$B$16;'Data base'!$B$11:$B$16;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE);
IF(AND(G19/F19>=1,25;G19/F19<1,5);VLOOKUP(MAXIFS('Data base'!$B$11:$B$17;'Data base'!$B$11:$B$17;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE); 
IF(AND(G19/F19>=1,5);VLOOKUP(MAXIFS('Data base'!$B$11:$B$18;'Data base'!$B$11:$B$18;"<="&H19);'Data base'!$B$11:$C$18;2;FALSE); 0))))))));
IF(E19="Senior";
IF(AND(G19/F19<0,3);'Data base'!$C$11;
IF(AND(G19/F19>=0,3;G19/F19<0,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$12;'Data base'!$D$11:$D$12;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE);
IF(AND(G19/F19>=0,5;G19/F19<0,75);VLOOKUP(MAXIFS('Data base'!$D$11:$D$13;'Data base'!$D$11:$D$13;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE);
IF(AND(G19/F19>=0,75;G19/F19<0,85);VLOOKUP(MAXIFS('Data base'!$D$11:$D$14;'Data base'!$D$11:$D$14;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE);
IF(AND(G19/F19>=0,85;G19/F19<1);VLOOKUP(MAXIFS('Data base'!$D$11:$D$15;'Data base'!$D$11:$D$15;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE);
IF(AND(G19/F19>=1;G19/F19<1,25);VLOOKUP(MAXIFS('Data base'!$D$11:$D$16;'Data base'!$D$11:$D$16;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE);
IF(AND(G19/F19>=1,25;G19/F19<1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$17;'Data base'!$D$11:$D$17;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE); 
IF(AND(G19/F19>=1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$18;'Data base'!$D$11:$D$18;"<="&H19);'Data base'!$D$11:$E$18;2;FALSE); 0))))))));
IF(E19="Sup/Leader";
IF(AND(G19/F19<0,3);'Data base'!$C$11;
IF(AND(G19/F19>=0,3;G19/F19<0,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$12;'Data base'!$D$11:$D$12;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE);
IF(AND(G19/F19>=0,5;G19/F19<0,75);VLOOKUP(MAXIFS('Data base'!$D$11:$D$13;'Data base'!$D$11:$D$13;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE);
IF(AND(G19/F19>=0,75;G19/F19<0,85);VLOOKUP(MAXIFS('Data base'!$D$11:$D$14;'Data base'!$D$11:$D$14;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE);
IF(AND(G19/F19>=0,85;G19/F19<1);VLOOKUP(MAXIFS('Data base'!$D$11:$D$15;'Data base'!$D$11:$D$15;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE);
IF(AND(G19/F19>=1;G19/F19<1,25);VLOOKUP(MAXIFS('Data base'!$D$11:$D$16;'Data base'!$D$11:$D$16;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE);
IF(AND(G19/F19>=1,25;G19/F19<1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$17;'Data base'!$D$11:$D$17;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE); 
IF(AND(G19/F19>=1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$18;'Data base'!$D$11:$D$18;"<="&H19);'Data base'!$D$11:$F$18;3;FALSE); 0))))))));
IF(E19="Giám đốc khối";
IF(AND(G19/F19<0,3);'Data base'!$C$11;
IF(AND(G19/F19>=0,3;G19/F19<0,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$12;'Data base'!$D$11:$D$12;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE);
IF(AND(G19/F19>=0,5;G19/F19<0,75);VLOOKUP(MAXIFS('Data base'!$D$11:$D$13;'Data base'!$D$11:$D$13;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE);
IF(AND(G19/F19>=0,75;G19/F19<0,85);VLOOKUP(MAXIFS('Data base'!$D$11:$D$14;'Data base'!$D$11:$D$14;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE);
IF(AND(G19/F19>=0,85;G19/F19<1);VLOOKUP(MAXIFS('Data base'!$D$11:$D$15;'Data base'!$D$11:$D$15;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE);
IF(AND(G19/F19>=1;G19/F19<1,25);VLOOKUP(MAXIFS('Data base'!$D$11:$D$16;'Data base'!$D$11:$D$16;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE);
IF(AND(G19/F19>=1,25;G19/F19<1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$17;'Data base'!$D$11:$D$17;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE); 
IF(AND(G19/F19>=1,5);VLOOKUP(MAXIFS('Data base'!$D$11:$D$18;'Data base'!$D$11:$D$18;"<="&H19);'Data base'!$D$11:$G$18;4;FALSE); 0))))))))
;0))))