麻辣家族討論版版 - Powered by Discuz! Board

標題: [發問] excel請問如何縮減下列函數的長度 [打印本頁]

作者: dany9177 時間: 2019-9-8 17:32 標題: excel請問如何縮減下列函數的長度

本帖最後由 dany9177 於 2019-9-8 17:33 編輯

抱歉這應該是有點新手的問題，但我只是初學者，真的不知道有甚麼其他的函數可以縮減長度，可是全部打進去xcel告訴我長度超過8192字元，無法執行，翻了兩天的micro office問題教學，還是不知道如何縮減長度，我實在求助無門，希望有前輩高人能夠指點後進，感激不盡。

我的目的是檢查a79這格的數值為［選擇頁－無］、［選擇頁－甲］、［選擇頁－乙］、［選擇頁－丙］
　　　　且檢查b79這格的數值為［武器頁Ａ３號］到［武器頁Ａ１００號］
如果是［選擇頁－丙］的［武器頁Ａ４號］則顯示［武器頁Ｉ４］這格的數值，依此類推。
（主要問題在於函數太長，這已經是我努力縮減過的版本了，似乎到了不改換思維方法就沒辦法的地步了）

函數如下：
=
IF(and(A79='選'!T$13,B79='武'!A$3),'武'!I$3,
IF(and(A79='選'!T$12,B79='武'!A$3),'武'!H$3,
IF(and(A79='選'!T$11,B79='武'!A$3),'武'!G$3,
IF(B79='武'!A$3,'武'!F$3,
IF(and(A79='選'!T$13,B79='武'!A$5),'武'!I$5,
IF(and(A79='選'!T$12,B79='武'!A$5),'武'!H$5,
IF(and(A79='選'!T$11,B79='武'!A$5),'武'!G$5,
IF(B79='武'!A$5,'武'!F$5,
IF(and(A79='選'!T$13,B79='武'!A$5),'武'!I$5,
IF(and(A79='選'!T$12,B79='武'!A$5),'武'!H$5,
IF(and(A79='選'!T$11,B79='武'!A$5),'武'!G$5,
IF(B79='武'!A$5,'武'!F$5,
IF(and(A79='選'!T$13,B79='武'!A$6),'武'!I$6,
IF(and(A79='選'!T$12,B79='武'!A$6),'武'!H$6,
IF(and(A79='選'!T$11,B79='武'!A$6),'武'!G$6,
IF(B79='武'!A$6,'武'!F$6,
IF(and(A79='選'!T$13,B79='武'!A$7),'武'!I$7,
IF(and(A79='選'!T$12,B79='武'!A$7),'武'!H$7,
IF(and(A79='選'!T$11,B79='武'!A$7),'武'!G$7,
IF(B79='武'!A$7,'武'!F$7,
IF(and(A79='選'!T$13,B79='武'!A$8),'武'!I$8,
IF(and(A79='選'!T$12,B79='武'!A$8),'武'!H$8,
IF(and(A79='選'!T$11,B79='武'!A$8),'武'!G$8,
IF(B79='武'!A$8,'武'!F$8,
IF(and(A79='選'!T$13,B79='武'!A$9),'武'!I$9,
IF(and(A79='選'!T$12,B79='武'!A$9),'武'!H$9,
IF(and(A79='選'!T$11,B79='武'!A$9),'武'!G$9,
IF(B79='武'!A$9,'武'!F$9,
IF(and(A79='選'!T$13,B79='武'!A$10),'武'!I$10,
IF(and(A79='選'!T$12,B79='武'!A$10),'武'!H$10,
IF(and(A79='選'!T$11,B79='武'!A$10),'武'!G$10,
IF(B79='武'!A$10,'武'!F$10,
IF(and(A79='選'!T$13,B79='武'!A$11),'武'!I$11,
IF(and(A79='選'!T$12,B79='武'!A$11),'武'!H$11,
IF(and(A79='選'!T$11,B79='武'!A$11),'武'!G$11,
IF(B79='武'!A$11,'武'!F$11,
IF(and(A79='選'!T$13,B79='武'!A$12),'武'!I$12,
IF(and(A79='選'!T$12,B79='武'!A$12),'武'!H$12,
IF(and(A79='選'!T$11,B79='武'!A$12),'武'!G$12,
IF(B79='武'!A$12,'武'!F$12,
IF(and(A79='選'!T$13,B79='武'!A$13),'武'!I$13,
IF(and(A79='選'!T$12,B79='武'!A$13),'武'!H$13,
IF(and(A79='選'!T$11,B79='武'!A$13),'武'!G$13,
IF(B79='武'!A$13,'武'!F$13,
IF(and(A79='選'!T$13,B79='武'!A$14),'武'!I$14,
IF(and(A79='選'!T$12,B79='武'!A$14),'武'!H$14,
IF(and(A79='選'!T$11,B79='武'!A$14),'武'!G$14,
IF(B79='武'!A$14,'武'!F$14,
IF(and(A79='選'!T$13,B79='武'!A$15),'武'!I$15,
IF(and(A79='選'!T$12,B79='武'!A$15),'武'!H$15,
IF(and(A79='選'!T$11,B79='武'!A$15),'武'!G$15,
IF(B79='武'!A$15,'武'!F$15,
IF(and(A79='選'!T$13,B79='武'!A$16),'武'!I$16,
IF(and(A79='選'!T$12,B79='武'!A$16),'武'!H$16,
IF(and(A79='選'!T$11,B79='武'!A$16),'武'!G$16,
IF(B79='武'!A$16,'武'!F$16,
IF(and(A79='選'!T$13,B79='武'!A$17),'武'!I$17,
IF(and(A79='選'!T$12,B79='武'!A$17),'武'!H$17,
IF(and(A79='選'!T$11,B79='武'!A$17),'武'!G$17,
IF(B79='武'!A$17,'武'!F$17,
IF(and(A79='選'!T$13,B79='武'!A$18),'武'!I$18,
IF(and(A79='選'!T$12,B79='武'!A$18),'武'!H$18,
IF(and(A79='選'!T$11,B79='武'!A$18),'武'!G$18,
IF(B79='武'!A$18,'武'!F$18,
IF(and(A79='選'!T$13,B79='武'!A$19),'武'!I$19,
IF(and(A79='選'!T$12,B79='武'!A$19),'武'!H$19,
IF(and(A79='選'!T$11,B79='武'!A$19),'武'!G$19,
IF(B79='武'!A$19,'武'!F$19,
IF(and(A79='選'!T$13,B79='武'!A$20),'武'!I$20,
IF(and(A79='選'!T$12,B79='武'!A$20),'武'!H$20,
IF(and(A79='選'!T$11,B79='武'!A$20),'武'!G$20,
IF(B79='武'!A$20,'武'!F$20,
IF(and(A79='選'!T$13,B79='武'!A$21),'武'!I$21,
IF(and(A79='選'!T$12,B79='武'!A$21),'武'!H$21,
IF(and(A79='選'!T$11,B79='武'!A$21),'武'!G$21,
IF(B79='武'!A$21,'武'!F$21,
IF(and(A79='選'!T$13,B79='武'!A$22),'武'!I$22,
IF(and(A79='選'!T$12,B79='武'!A$22),'武'!H$22,
IF(and(A79='選'!T$11,B79='武'!A$22),'武'!G$22,
IF(B79='武'!A$22,'武'!F$22,
IF(and(A79='選'!T$13,B79='武'!A$23),'武'!I$23,
IF(and(A79='選'!T$12,B79='武'!A$23),'武'!H$23,
IF(and(A79='選'!T$11,B79='武'!A$23),'武'!G$23,
IF(B79='武'!A$23,'武'!F$23,
IF(and(A79='選'!T$13,B79='武'!A$24),'武'!I$24,
IF(and(A79='選'!T$12,B79='武'!A$24),'武'!H$24,
IF(and(A79='選'!T$11,B79='武'!A$24),'武'!G$24,
IF(B79='武'!A$24,'武'!F$24,
IF(and(A79='選'!T$13,B79='武'!A$25),'武'!I$25,
IF(and(A79='選'!T$12,B79='武'!A$25),'武'!H$25,
IF(and(A79='選'!T$11,B79='武'!A$25),'武'!G$25,
IF(B79='武'!A$25,'武'!F$25,
IF(and(A79='選'!T$13,B79='武'!A$26),'武'!I$26,
IF(and(A79='選'!T$12,B79='武'!A$26),'武'!H$26,
IF(and(A79='選'!T$11,B79='武'!A$26),'武'!G$26,
IF(B79='武'!A$26,'武'!F$26,
IF(and(A79='選'!T$13,B79='武'!A$27),'武'!I$27,
IF(and(A79='選'!T$12,B79='武'!A$27),'武'!H$27,
IF(and(A79='選'!T$11,B79='武'!A$27),'武'!G$27,
IF(B79='武'!A$27,'武'!F$27,
IF(and(A79='選'!T$13,B79='武'!A$28),'武'!I$28,
IF(and(A79='選'!T$12,B79='武'!A$28),'武'!H$28,
IF(and(A79='選'!T$11,B79='武'!A$28),'武'!G$28,
IF(B79='武'!A$28,'武'!F$28,
IF(and(A79='選'!T$13,B79='武'!A$29),'武'!I$29,
IF(and(A79='選'!T$12,B79='武'!A$29),'武'!H$29,
IF(and(A79='選'!T$11,B79='武'!A$29),'武'!G$29,
IF(B79='武'!A$29,'武'!F$29,
IF(and(A79='選'!T$13,B79='武'!A$30),'武'!I$30,
IF(and(A79='選'!T$12,B79='武'!A$30),'武'!H$30,
IF(and(A79='選'!T$11,B79='武'!A$30),'武'!G$30,
IF(B79='武'!A$30,'武'!F$30,
IF(and(A79='選'!T$13,B79='武'!A$31),'武'!I$31,
IF(and(A79='選'!T$12,B79='武'!A$31),'武'!H$31,
IF(and(A79='選'!T$11,B79='武'!A$31),'武'!G$31,
IF(B79='武'!A$31,'武'!F$31,
IF(and(A79='選'!T$13,B79='武'!A$32),'武'!I$32,
IF(and(A79='選'!T$12,B79='武'!A$32),'武'!H$32,
IF(and(A79='選'!T$11,B79='武'!A$32),'武'!G$32,
IF(B79='武'!A$32,'武'!F$32,
IF(and(A79='選'!T$13,B79='武'!A$33),'武'!I$33,
IF(and(A79='選'!T$12,B79='武'!A$33),'武'!H$33,
IF(and(A79='選'!T$11,B79='武'!A$33),'武'!G$33,
IF(B79='武'!A$33,'武'!F$33,
IF(and(A79='選'!T$13,B79='武'!A$34),'武'!I$34,
IF(and(A79='選'!T$12,B79='武'!A$34),'武'!H$34,
IF(and(A79='選'!T$11,B79='武'!A$34),'武'!G$34,
IF(B79='武'!A$34,'武'!F$34,
IF(and(A79='選'!T$13,B79='武'!A$35),'武'!I$35,
IF(and(A79='選'!T$12,B79='武'!A$35),'武'!H$35,
IF(and(A79='選'!T$11,B79='武'!A$35),'武'!G$35,
IF(B79='武'!A$35,'武'!F$35,
IF(and(A79='選'!T$13,B79='武'!A$36),'武'!I$36,
IF(and(A79='選'!T$12,B79='武'!A$36),'武'!H$36,
IF(and(A79='選'!T$11,B79='武'!A$36),'武'!G$36,
IF(B79='武'!A$36,'武'!F$36,
IF(and(A79='選'!T$13,B79='武'!A$37),'武'!I$37,
IF(and(A79='選'!T$12,B79='武'!A$37),'武'!H$37,
IF(and(A79='選'!T$11,B79='武'!A$37),'武'!G$37,
IF(B79='武'!A$37,'武'!F$37,
IF(and(A79='選'!T$13,B79='武'!A$38),'武'!I$38,
IF(and(A79='選'!T$12,B79='武'!A$38),'武'!H$38,
IF(and(A79='選'!T$11,B79='武'!A$38),'武'!G$38,
IF(B79='武'!A$38,'武'!F$38,
IF(and(A79='選'!T$13,B79='武'!A$39),'武'!I$39,
IF(and(A79='選'!T$12,B79='武'!A$39),'武'!H$39,
IF(and(A79='選'!T$11,B79='武'!A$39),'武'!G$39,
IF(B79='武'!A$39,'武'!F$39,
IF(and(A79='選'!T$13,B79='武'!A$40),'武'!I$40,
IF(and(A79='選'!T$12,B79='武'!A$40),'武'!H$40,
IF(and(A79='選'!T$11,B79='武'!A$40),'武'!G$40,
IF(B79='武'!A$40,'武'!F$40,
IF(and(A79='選'!T$13,B79='武'!A$41),'武'!I$41,
IF(and(A79='選'!T$12,B79='武'!A$41),'武'!H$41,
IF(and(A79='選'!T$11,B79='武'!A$41),'武'!G$41,
IF(B79='武'!A$41,'武'!F$41,
IF(and(A79='選'!T$13,B79='武'!A$42),'武'!I$42,
IF(and(A79='選'!T$12,B79='武'!A$42),'武'!H$42,
IF(and(A79='選'!T$11,B79='武'!A$42),'武'!G$42,
IF(B79='武'!A$42,'武'!F$42,
IF(and(A79='選'!T$13,B79='武'!A$43),'武'!I$43,
IF(and(A79='選'!T$12,B79='武'!A$43),'武'!H$43,
IF(and(A79='選'!T$11,B79='武'!A$43),'武'!G$43,
IF(B79='武'!A$43,'武'!F$43,
IF(and(A79='選'!T$13,B79='武'!A$44),'武'!I$44,
IF(and(A79='選'!T$12,B79='武'!A$44),'武'!H$44,
IF(and(A79='選'!T$11,B79='武'!A$44),'武'!G$44,
IF(B79='武'!A$44,'武'!F$44,
IF(and(A79='選'!T$13,B79='武'!A$45),'武'!I$45,
IF(and(A79='選'!T$12,B79='武'!A$45),'武'!H$45,
IF(and(A79='選'!T$11,B79='武'!A$45),'武'!G$45,
IF(B79='武'!A$45,'武'!F$45,
IF(and(A79='選'!T$13,B79='武'!A$46),'武'!I$46,
IF(and(A79='選'!T$12,B79='武'!A$46),'武'!H$46,
IF(and(A79='選'!T$11,B79='武'!A$46),'武'!G$46,
IF(B79='武'!A$46,'武'!F$46,
IF(and(A79='選'!T$13,B79='武'!A$47),'武'!I$47,
IF(and(A79='選'!T$12,B79='武'!A$47),'武'!H$47,
IF(and(A79='選'!T$11,B79='武'!A$47),'武'!G$47,
IF(B79='武'!A$47,'武'!F$47,
IF(and(A79='選'!T$13,B79='武'!A$48),'武'!I$48,
IF(and(A79='選'!T$12,B79='武'!A$48),'武'!H$48,
IF(and(A79='選'!T$11,B79='武'!A$48),'武'!G$48,
IF(B79='武'!A$48,'武'!F$48,
IF(and(A79='選'!T$13,B79='武'!A$49),'武'!I$49,
IF(and(A79='選'!T$12,B79='武'!A$49),'武'!H$49,
IF(and(A79='選'!T$11,B79='武'!A$49),'武'!G$49,
IF(B79='武'!A$49,'武'!F$49,
IF(and(A79='選'!T$13,B79='武'!A$50),'武'!I$50,
IF(and(A79='選'!T$12,B79='武'!A$50),'武'!H$50,
IF(and(A79='選'!T$11,B79='武'!A$50),'武'!G$50,
IF(B79='武'!A$50,'武'!F$50,

作者: dany9177 時間: 2019-9-8 17:32

抱歉，函數太長只能分成兩段來發。
以下為剩下的函數：

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

作者: monsterpo 時間: 2019-11-21 12:56

可以把問題描述得清楚一點
比如說你的原始資料跟你想達到的需求
來想想看有沒有別的方法可以達成

歡迎光臨麻辣家族討論版版 (http://forum.twbts.com/)