ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦h±ø¥ó§PÂ_ªº¤£¦P Åã¥Ü¹ïÀ³¤å¦r

[µo°Ý] ¦h±ø¥ó§PÂ_ªº¤£¦P Åã¥Ü¹ïÀ³¤å¦r

½Ð°Ý¦p¤U¹Ï¤º³¡ªº³W«h¡A³£¦b²Å¦Xªº±ø¥ó¤º«h©¹¤W¤É¯Å
¦p¦ó¸Ó¥Î¦h±ø¥ó¡A¹F¦¨¦Û°Ê§PÂ_¨ìE¯Åªº¤½¦¡

=IF(AND(C7<=G2,D2<=H2,D3<=I2,D4<=J2,D5<=K2),"A","B") ¥Ø«e¥u·|¤@¦¸ªº

¦^´_ 1# starry1314

¥i§_¤W¶Çªþ¥ó¡H§_«hÃø¥H¦^µª~

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-4-3 23:55 ½s¿è

¦^´_ 2# tku0216

¤w¤W¶ÇªþÀÉ~¦A³Â·Ð¤F
¥Ø«e¬O¥H³æ¦C§PÂ_¬O§_²Å¦X±ø¥ó«á,¦b¥HVLOOKUP¥h§ä¥X²Å¦X"TRUE"ªº¦ì¸mªº¯Å§O
¦p³£¤£²Å¦X±ø¥ó«hµø¬°E
½Ð±Ð_¦h±ø¥ó§PÂ_.rar (8.32 KB)

TOP

¦^´_ 3# starry1314

¸Õ¸Õ³o¤ä¤½¦¡¡A¶K¦b¥ô¤@³B¬Ò¥i
=IF(AND(VLOOKUP(LOOKUP(IF(C6<30,30),$H$2:$H$6),$H$2:$K$6,1,FALSE)>=D2,VLOOKUP(LOOKUP(IF(C6<30,30),$H$2:$H$6),$H$2:$K$6,2,FALSE)>=D3,VLOOKUP(LOOKUP(IF(C6<30,30),$H$2:$H$6),$H$2:$K$6,3,FALSE)>=D4,VLOOKUP(LOOKUP(IF(C6<30,30),$H$2:$H$6),$H$2:$K$6,4,FALSE)>=D5,VLOOKUP(LOOKUP(IF(C6<30,30),$H$2:$H$6),$H$2:$K$6,1,FALSE)>=C6),LOOKUP(IF(C6<30,30,LOOKUP(C6,$H$2:$H$6)),$H$2:$H$6,$M$2:$M$6),"E")

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-4-4 09:59 ½s¿è

¦^´_ 4# tku0216

ÁÂÁÂ¥i¨Ï¥Î~¦b·Q¿ìªk¦p¦ó®M¥Î¦b­Ó¤H¦Ò®Ö¤W

TOP

¢Ñ¢°¢²¡D°}¦C¤½¦¡¡G
=MID("EABCD",MIN(IF(MMULT((C6<=H2:H5)*(TRANSPOSE(D2:D5)<=H2:K5),{1;1;1;1})=4,{1;2;3;4}))+1,1)

¥kªí¦¸¼Æ¥¼¶ñ¼Æ¦r¡A·N¸q¬°¦ó¡H¡@ªí¥Ü¢¯¡A¤£¯àµo¥Í¡H¡@ÁÙ¬O¤£­­¨î¦¸¼Æ¡H

TOP

¦^´_ 6# ­ã´£³¡ªL

¤£¦n·N«ä~¨Sµù©ú¸Ô²Ó
0=¤£¯àµo¥Í
ªÅ¥Õ=¤£­­¦¸¼Æ

TOP

¦^´_ 7# starry1314

¨º´N·Ó6¼Ó¤½¦¡,
¥kªíªÅ®æ¶ñ¤J "NA" ©Î¨ä¥¦[¤å¦r],

¥t¤@°ÝÃD¬O, ¦P®É¦³¦h­Ó²Å¦X, ¨ú¥ý©Î¨ú«áªÌ?
¥H¥Ø«eªº¨Ò¤l, D¤ÎE³£²Å¦X!

TOP

¦^´_ 8# ­ã´£³¡ªL


    ¥ý¨úD ¶W¥X5¦A¬°E

TOP

¦^´_ 9# starry1314

´ú¸ÕÀÉ¡G¦Û¦æ®M¥Î
Xl0000257.rar (7.09 KB)

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD