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

[µo°Ý] excel½Ð°Ý¦p¦óÁY´î¤U¦C¨ç¼Æªºªø«×

[µo°Ý] excel½Ð°Ý¦p¦óÁY´î¤U¦C¨ç¼Æªºªø«×

¥»©«³Ì«á¥Ñ dany9177 ©ó 2019-9-8 17:33 ½s¿è

©êºp³oÀ³¸Ó¬O¦³ÂI·s¤âªº°ÝÃD¡A¦ý§Ú¥u¬Oªì¾ÇªÌ¡A¯uªº¤£ª¾¹D¦³¬Æ»ò¨ä¥Lªº¨ç¼Æ¥i¥HÁY´îªø«×¡A¥i¬O¥þ³¡¥´¶i¥hxcel§i¶D§Úªø«×¶W¹L8192¦r¤¸¡AµLªk°õ¦æ¡A½¤F¨â¤Ñªºmicro office°ÝÃD±Ð¾Ç¡AÁÙ¬O¤£ª¾¹D¦p¦óÁY´îªø«×¡A§Ú¹ê¦b¨D§UµLªù¡A§Æ±æ¦³«e½ú°ª¤H¯à°÷«üÂI«á¶i¡A·P¿E¤£ºÉ¡C

§Úªº¥Øªº¬OÀˬda79³o®æªº¼Æ­È¬°Æä¿ï¾Ü­¶¡ÐµLÆå¡BÆä¿ï¾Ü­¶¡Ð¥ÒÆå¡BÆä¿ï¾Ü­¶¡Ð¤AÆå¡BÆä¿ï¾Ü­¶¡Ð¤þÆå
¡@¡@¡@¡@¥BÀˬdb79³o®æªº¼Æ­È¬°ÆäªZ¾¹­¶¢Ï¢²¸¹Æå¨ìÆäªZ¾¹­¶¢Ï¢°¢¯¢¯¸¹Æå
¦pªG¬OÆä¿ï¾Ü­¶¡Ð¤þÆ媺ÆäªZ¾¹­¶¢Ï¢³¸¹Æå«hÅã¥ÜÆäªZ¾¹­¶¢×¢³Æå³o®æªº¼Æ­È¡A¨Ì¦¹Ãþ±À¡C
¡]¥D­n°ÝÃD¦b©ó¨ç¼Æ¤Óªø¡A³o¤w¸g¬O§Ú§V¤OÁY´î¹Lªºª©¥»¤F¡A¦ü¥G¨ì¤F¤£§ï´««äºû¤èªk´N¨S¿ìªkªº¦a¨B¤F¡^

¨ç¼Æ¦p¤U¡G
=
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$3),'ªZ'!I$3,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$3),'ªZ'!H$3,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$3),'ªZ'!G$3,
IF(B79='ªZ'!A$3,'ªZ'!F$3,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$5),'ªZ'!I$5,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$5),'ªZ'!H$5,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$5),'ªZ'!G$5,
IF(B79='ªZ'!A$5,'ªZ'!F$5,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$5),'ªZ'!I$5,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$5),'ªZ'!H$5,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$5),'ªZ'!G$5,
IF(B79='ªZ'!A$5,'ªZ'!F$5,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$6),'ªZ'!I$6,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$6),'ªZ'!H$6,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$6),'ªZ'!G$6,
IF(B79='ªZ'!A$6,'ªZ'!F$6,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$7),'ªZ'!I$7,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$7),'ªZ'!H$7,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$7),'ªZ'!G$7,
IF(B79='ªZ'!A$7,'ªZ'!F$7,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$8),'ªZ'!I$8,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$8),'ªZ'!H$8,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$8),'ªZ'!G$8,
IF(B79='ªZ'!A$8,'ªZ'!F$8,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$9),'ªZ'!I$9,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$9),'ªZ'!H$9,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$9),'ªZ'!G$9,
IF(B79='ªZ'!A$9,'ªZ'!F$9,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$10),'ªZ'!I$10,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$10),'ªZ'!H$10,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$10),'ªZ'!G$10,
IF(B79='ªZ'!A$10,'ªZ'!F$10,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$11),'ªZ'!I$11,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$11),'ªZ'!H$11,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$11),'ªZ'!G$11,
IF(B79='ªZ'!A$11,'ªZ'!F$11,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$12),'ªZ'!I$12,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$12),'ªZ'!H$12,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$12),'ªZ'!G$12,
IF(B79='ªZ'!A$12,'ªZ'!F$12,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$13),'ªZ'!I$13,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$13),'ªZ'!H$13,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$13),'ªZ'!G$13,
IF(B79='ªZ'!A$13,'ªZ'!F$13,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$14),'ªZ'!I$14,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$14),'ªZ'!H$14,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$14),'ªZ'!G$14,
IF(B79='ªZ'!A$14,'ªZ'!F$14,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$15),'ªZ'!I$15,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$15),'ªZ'!H$15,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$15),'ªZ'!G$15,
IF(B79='ªZ'!A$15,'ªZ'!F$15,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$16),'ªZ'!I$16,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$16),'ªZ'!H$16,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$16),'ªZ'!G$16,
IF(B79='ªZ'!A$16,'ªZ'!F$16,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$17),'ªZ'!I$17,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$17),'ªZ'!H$17,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$17),'ªZ'!G$17,
IF(B79='ªZ'!A$17,'ªZ'!F$17,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$18),'ªZ'!I$18,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$18),'ªZ'!H$18,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$18),'ªZ'!G$18,
IF(B79='ªZ'!A$18,'ªZ'!F$18,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$19),'ªZ'!I$19,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$19),'ªZ'!H$19,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$19),'ªZ'!G$19,
IF(B79='ªZ'!A$19,'ªZ'!F$19,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$20),'ªZ'!I$20,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$20),'ªZ'!H$20,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$20),'ªZ'!G$20,
IF(B79='ªZ'!A$20,'ªZ'!F$20,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$21),'ªZ'!I$21,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$21),'ªZ'!H$21,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$21),'ªZ'!G$21,
IF(B79='ªZ'!A$21,'ªZ'!F$21,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$22),'ªZ'!I$22,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$22),'ªZ'!H$22,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$22),'ªZ'!G$22,
IF(B79='ªZ'!A$22,'ªZ'!F$22,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$23),'ªZ'!I$23,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$23),'ªZ'!H$23,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$23),'ªZ'!G$23,
IF(B79='ªZ'!A$23,'ªZ'!F$23,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$24),'ªZ'!I$24,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$24),'ªZ'!H$24,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$24),'ªZ'!G$24,
IF(B79='ªZ'!A$24,'ªZ'!F$24,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$25),'ªZ'!I$25,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$25),'ªZ'!H$25,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$25),'ªZ'!G$25,
IF(B79='ªZ'!A$25,'ªZ'!F$25,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$26),'ªZ'!I$26,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$26),'ªZ'!H$26,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$26),'ªZ'!G$26,
IF(B79='ªZ'!A$26,'ªZ'!F$26,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$27),'ªZ'!I$27,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$27),'ªZ'!H$27,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$27),'ªZ'!G$27,
IF(B79='ªZ'!A$27,'ªZ'!F$27,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$28),'ªZ'!I$28,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$28),'ªZ'!H$28,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$28),'ªZ'!G$28,
IF(B79='ªZ'!A$28,'ªZ'!F$28,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$29),'ªZ'!I$29,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$29),'ªZ'!H$29,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$29),'ªZ'!G$29,
IF(B79='ªZ'!A$29,'ªZ'!F$29,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$30),'ªZ'!I$30,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$30),'ªZ'!H$30,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$30),'ªZ'!G$30,
IF(B79='ªZ'!A$30,'ªZ'!F$30,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$31),'ªZ'!I$31,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$31),'ªZ'!H$31,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$31),'ªZ'!G$31,
IF(B79='ªZ'!A$31,'ªZ'!F$31,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$32),'ªZ'!I$32,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$32),'ªZ'!H$32,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$32),'ªZ'!G$32,
IF(B79='ªZ'!A$32,'ªZ'!F$32,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$33),'ªZ'!I$33,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$33),'ªZ'!H$33,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$33),'ªZ'!G$33,
IF(B79='ªZ'!A$33,'ªZ'!F$33,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$34),'ªZ'!I$34,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$34),'ªZ'!H$34,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$34),'ªZ'!G$34,
IF(B79='ªZ'!A$34,'ªZ'!F$34,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$35),'ªZ'!I$35,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$35),'ªZ'!H$35,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$35),'ªZ'!G$35,
IF(B79='ªZ'!A$35,'ªZ'!F$35,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$36),'ªZ'!I$36,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$36),'ªZ'!H$36,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$36),'ªZ'!G$36,
IF(B79='ªZ'!A$36,'ªZ'!F$36,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$37),'ªZ'!I$37,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$37),'ªZ'!H$37,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$37),'ªZ'!G$37,
IF(B79='ªZ'!A$37,'ªZ'!F$37,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$38),'ªZ'!I$38,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$38),'ªZ'!H$38,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$38),'ªZ'!G$38,
IF(B79='ªZ'!A$38,'ªZ'!F$38,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$39),'ªZ'!I$39,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$39),'ªZ'!H$39,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$39),'ªZ'!G$39,
IF(B79='ªZ'!A$39,'ªZ'!F$39,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$40),'ªZ'!I$40,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$40),'ªZ'!H$40,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$40),'ªZ'!G$40,
IF(B79='ªZ'!A$40,'ªZ'!F$40,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$41),'ªZ'!I$41,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$41),'ªZ'!H$41,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$41),'ªZ'!G$41,
IF(B79='ªZ'!A$41,'ªZ'!F$41,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$42),'ªZ'!I$42,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$42),'ªZ'!H$42,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$42),'ªZ'!G$42,
IF(B79='ªZ'!A$42,'ªZ'!F$42,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$43),'ªZ'!I$43,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$43),'ªZ'!H$43,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$43),'ªZ'!G$43,
IF(B79='ªZ'!A$43,'ªZ'!F$43,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$44),'ªZ'!I$44,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$44),'ªZ'!H$44,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$44),'ªZ'!G$44,
IF(B79='ªZ'!A$44,'ªZ'!F$44,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$45),'ªZ'!I$45,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$45),'ªZ'!H$45,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$45),'ªZ'!G$45,
IF(B79='ªZ'!A$45,'ªZ'!F$45,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$46),'ªZ'!I$46,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$46),'ªZ'!H$46,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$46),'ªZ'!G$46,
IF(B79='ªZ'!A$46,'ªZ'!F$46,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$47),'ªZ'!I$47,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$47),'ªZ'!H$47,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$47),'ªZ'!G$47,
IF(B79='ªZ'!A$47,'ªZ'!F$47,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$48),'ªZ'!I$48,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$48),'ªZ'!H$48,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$48),'ªZ'!G$48,
IF(B79='ªZ'!A$48,'ªZ'!F$48,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$49),'ªZ'!I$49,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$49),'ªZ'!H$49,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$49),'ªZ'!G$49,
IF(B79='ªZ'!A$49,'ªZ'!F$49,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$50),'ªZ'!I$50,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$50),'ªZ'!H$50,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$50),'ªZ'!G$50,
IF(B79='ªZ'!A$50,'ªZ'!F$50,

©êºp¡A¨ç¼Æ¤Óªø¥u¯à¤À¦¨¨â¬q¨Óµo¡C
¥H¤U¬°³Ñ¤Uªº¨ç¼Æ¡G


IF(and(A79='¿ï'!T$13,B79='ªZ'!A$51),'ªZ'!I$51,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$51),'ªZ'!H$51,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$51),'ªZ'!G$51,
IF(B79='ªZ'!A$51,'ªZ'!F$51,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$52),'ªZ'!I$52,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$52),'ªZ'!H$52,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$52),'ªZ'!G$52,
IF(B79='ªZ'!A$52,'ªZ'!F$52,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$53),'ªZ'!I$53,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$53),'ªZ'!H$53,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$53),'ªZ'!G$53,
IF(B79='ªZ'!A$53,'ªZ'!F$53,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$55),'ªZ'!I$55,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$55),'ªZ'!H$55,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$55),'ªZ'!G$55,
IF(B79='ªZ'!A$55,'ªZ'!F$55,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$56),'ªZ'!I$56,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$56),'ªZ'!H$56,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$56),'ªZ'!G$56,
IF(B79='ªZ'!A$56,'ªZ'!F$56,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$57),'ªZ'!I$57,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$57),'ªZ'!H$57,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$57),'ªZ'!G$57,
IF(B79='ªZ'!A$57,'ªZ'!F$57,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$58),'ªZ'!I$58,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$58),'ªZ'!H$58,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$58),'ªZ'!G$58,
IF(B79='ªZ'!A$58,'ªZ'!F$58,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$59),'ªZ'!I$59,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$59),'ªZ'!H$59,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$59),'ªZ'!G$59,
IF(B79='ªZ'!A$59,'ªZ'!F$59,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$60),'ªZ'!I$60,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$60),'ªZ'!H$60,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$60),'ªZ'!G$60,
IF(B79='ªZ'!A$60,'ªZ'!F$60,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$61),'ªZ'!I$61,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$61),'ªZ'!H$61,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$61),'ªZ'!G$61,
IF(B79='ªZ'!A$61,'ªZ'!F$61,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$62),'ªZ'!I$62,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$62),'ªZ'!H$62,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$62),'ªZ'!G$62,
IF(B79='ªZ'!A$62,'ªZ'!F$62,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$63),'ªZ'!I$63,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$63),'ªZ'!H$63,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$63),'ªZ'!G$63,
IF(B79='ªZ'!A$63,'ªZ'!F$63,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$64),'ªZ'!I$64,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$64),'ªZ'!H$64,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$64),'ªZ'!G$64,
IF(B79='ªZ'!A$64,'ªZ'!F$64,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$65),'ªZ'!I$65,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$65),'ªZ'!H$65,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$65),'ªZ'!G$65,
IF(B79='ªZ'!A$65,'ªZ'!F$65,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$66),'ªZ'!I$66,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$66),'ªZ'!H$66,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$66),'ªZ'!G$66,
IF(B79='ªZ'!A$66,'ªZ'!F$66,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$67),'ªZ'!I$67,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$67),'ªZ'!H$67,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$67),'ªZ'!G$67,
IF(B79='ªZ'!A$67,'ªZ'!F$67,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$68),'ªZ'!I$68,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$68),'ªZ'!H$68,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$68),'ªZ'!G$68,
IF(B79='ªZ'!A$68,'ªZ'!F$68,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$69),'ªZ'!I$69,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$69),'ªZ'!H$69,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$69),'ªZ'!G$69,
IF(B79='ªZ'!A$69,'ªZ'!F$69,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$70),'ªZ'!I$70,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$70),'ªZ'!H$70,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$70),'ªZ'!G$70,
IF(B79='ªZ'!A$70,'ªZ'!F$70,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$71),'ªZ'!I$71,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$71),'ªZ'!H$71,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$71),'ªZ'!G$71,
IF(B79='ªZ'!A$71,'ªZ'!F$71,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$72),'ªZ'!I$72,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$72),'ªZ'!H$72,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$72),'ªZ'!G$72,
IF(B79='ªZ'!A$72,'ªZ'!F$72,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$73),'ªZ'!I$73,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$73),'ªZ'!H$73,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$73),'ªZ'!G$73,
IF(B79='ªZ'!A$73,'ªZ'!F$73,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$74),'ªZ'!I$74,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$74),'ªZ'!H$74,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$74),'ªZ'!G$74,
IF(B79='ªZ'!A$74,'ªZ'!F$74,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$75),'ªZ'!I$75,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$75),'ªZ'!H$75,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$75),'ªZ'!G$75,
IF(B79='ªZ'!A$75,'ªZ'!F$75,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$76),'ªZ'!I$76,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$76),'ªZ'!H$76,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$76),'ªZ'!G$76,
IF(B79='ªZ'!A$76,'ªZ'!F$76,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$77),'ªZ'!I$77,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$77),'ªZ'!H$77,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$77),'ªZ'!G$77,
IF(B79='ªZ'!A$77,'ªZ'!F$77,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$78),'ªZ'!I$78,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$78),'ªZ'!H$78,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$78),'ªZ'!G$78,
IF(B79='ªZ'!A$78,'ªZ'!F$78,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$79),'ªZ'!I$79,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$79),'ªZ'!H$79,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$79),'ªZ'!G$79,
IF(B79='ªZ'!A$79,'ªZ'!F$79,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$80),'ªZ'!I$80,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$80),'ªZ'!H$80,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$80),'ªZ'!G$80,
IF(B79='ªZ'!A$80,'ªZ'!F$80,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$81),'ªZ'!I$81,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$81),'ªZ'!H$81,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$81),'ªZ'!G$81,
IF(B79='ªZ'!A$81,'ªZ'!F$81,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$82),'ªZ'!I$82,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$82),'ªZ'!H$82,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$82),'ªZ'!G$82,
IF(B79='ªZ'!A$82,'ªZ'!F$82,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$83),'ªZ'!I$83,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$83),'ªZ'!H$83,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$83),'ªZ'!G$83,
IF(B79='ªZ'!A$83,'ªZ'!F$83,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$84),'ªZ'!I$84,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$84),'ªZ'!H$84,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$84),'ªZ'!G$84,
IF(B79='ªZ'!A$84,'ªZ'!F$84,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$85),'ªZ'!I$85,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$85),'ªZ'!H$85,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$85),'ªZ'!G$85,
IF(B79='ªZ'!A$85,'ªZ'!F$85,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$86),'ªZ'!I$86,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$86),'ªZ'!H$86,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$86),'ªZ'!G$86,
IF(B79='ªZ'!A$86,'ªZ'!F$86,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$87),'ªZ'!I$87,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$87),'ªZ'!H$87,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$87),'ªZ'!G$87,
IF(B79='ªZ'!A$87,'ªZ'!F$87,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$88),'ªZ'!I$88,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$88),'ªZ'!H$88,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$88),'ªZ'!G$88,
IF(B79='ªZ'!A$88,'ªZ'!F$88,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$89),'ªZ'!I$89,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$89),'ªZ'!H$89,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$89),'ªZ'!G$89,
IF(B79='ªZ'!A$89,'ªZ'!F$89,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$90),'ªZ'!I$90,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$90),'ªZ'!H$90,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$90),'ªZ'!G$90,
IF(B79='ªZ'!A$90,'ªZ'!F$90,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$91),'ªZ'!I$91,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$91),'ªZ'!H$91,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$91),'ªZ'!G$91,
IF(B79='ªZ'!A$91,'ªZ'!F$91,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$92),'ªZ'!I$92,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$92),'ªZ'!H$92,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$92),'ªZ'!G$92,
IF(B79='ªZ'!A$92,'ªZ'!F$92,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$93),'ªZ'!I$93,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$93),'ªZ'!H$93,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$93),'ªZ'!G$93,
IF(B79='ªZ'!A$93,'ªZ'!F$93,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$94),'ªZ'!I$94,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$94),'ªZ'!H$94,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$94),'ªZ'!G$94,
IF(B79='ªZ'!A$94,'ªZ'!F$94,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$95),'ªZ'!I$95,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$95),'ªZ'!H$95,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$95),'ªZ'!G$95,
IF(B79='ªZ'!A$95,'ªZ'!F$95,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$96),'ªZ'!I$96,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$96),'ªZ'!H$96,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$96),'ªZ'!G$96,
IF(B79='ªZ'!A$96,'ªZ'!F$96,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$97),'ªZ'!I$97,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$97),'ªZ'!H$97,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$97),'ªZ'!G$97,
IF(B79='ªZ'!A$97,'ªZ'!F$97,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$98),'ªZ'!I$98,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$98),'ªZ'!H$98,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$98),'ªZ'!G$98,
IF(B79='ªZ'!A$98,'ªZ'!F$98,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$99),'ªZ'!I$99,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$99),'ªZ'!H$99,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$99),'ªZ'!G$99,
IF(B79='ªZ'!A$99,'ªZ'!F$99,
IF(and(A79='¿ï'!T$13,B79='ªZ'!A$100),'ªZ'!I$100,
IF(and(A79='¿ï'!T$12,B79='ªZ'!A$100),'ªZ'!H$100,
IF(and(A79='¿ï'!T$11,B79='ªZ'!A$100),'ªZ'!G$100,
IF(B79='ªZ'!A$100,'ªZ'!F$100,
"")

TOP

¥i¥H§â°ÝÃD´y­z±o²M·¡¤@ÂI
¤ñ¦p»¡§Aªº­ì©l¸ê®Æ¸ò§A·Q¹F¨ìªº»Ý¨D
¨Ó·Q·Q¬Ý¦³¨S¦³§Oªº¤èªk¥i¥H¹F¦¨

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD