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

[µo°Ý] ¦³¼h¦¸ªº¾P°âª÷ÃB¤Î°h³fª÷ÃB¤§¤½¦¡¡A­n¦p¦ó³]©w

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-2-25 23:04 ½s¿è

¦^´_ 2# julieh96590

¨Ì§AªºÅÞ¿è¡A¥i¥H¥Îchoose°tmatch¨Ó¼g
=CHOOSE(MATCH(A1,{0,13,41}),A1*1080,(A1-12)*970+12960,(A1-40)*700+40120)

TOP

¦^´_ 1# julieh96590


   ¸òºî©Òµ|ªº²Ö¶i½Òµ|¦³ÂI¹³!  ¥u¬O­n¥t§@°Ñ¦Òªí®æ!

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-2-26 16:30 ½s¿è

¦^´_ 12# handmuch
¯Å¶Zªíªº¤è¦¡¨Ó¼g¤½¦¡¡A¥»¨Ò°â¥XÁ`»ù¥i¨Ï¥ÎLOOKUP¨ç¼Æ©Î³\§ó®e©ö²z¸Ñ
B1=IF(A1>0,SUMPRODUCT(LOOKUP(ROW(INDIRECT("A1:A"&A1)),{0,13,41},{1080,970,700})*1),"")
B2°}¦C¤½¦¡
=IF((A2>0)*(A2<=A1),SUM(SMALL(LOOKUP(ROW(INDIRECT("A1:A"&A1)),{0,13,41},{1080,970,700}),ROW(INDIRECT("A1:A"&A2)))),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD