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

¤À²Õ¤£¦P±o¤À¤W­­(¤w¸Ñ¨M)

¤À²Õ¤£¦P±o¤À¤W­­(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-2-18 16:07 ½s¿è

¦³­Ó§xÃø«×ªº¥i¥H½Ð¤j¤jÀ°¦£¶Ü?¦pªþ¥ó
¹ï§Ú¦Ó¨¥«ÜÃø·d©w
½Ð¨DÀ°À°¦£
¤À²Õ¤S¤À§O­­¤£¦P±o¤À¤W­­
¥B±o¤À°t¤À¤£¦P

¶µ¥Ø.zip (13.36 KB)

¦^´_ 1# koala2099

J10=IF(I10<$F$2,0,MIN(SUMPRODUCT(($F10=$G$1:$H$1)*$G$2:$H$2*(ROUND(I10,2)-$F$2)*100),SUMPRODUCT(($F10=$G$1:$H$1)*$I$2:$J$2)))
O10=IF(N10<$F$3,0,MIN(SUMPRODUCT(($F10=$G$1:$H$1)*$G$3:$H$3*(ROUND(N10,2)-$F$3)*100),SUMPRODUCT(($F10=$G$1:$H$1)*$I$3:$J$3)))
R10=IF(Q10<$F$4,0,SUMPRODUCT(($F10=$G$1:$H$1)*$K$4:$L$4))

TOP

¦^´_ 2# register313

SUMPRODUCT³o­Ó¨ç¼Æ¤£¤ÓÀ´
©I~¯u¬O¾Ç°Ý§r!¨¯­W¤j¤j¤F~
­n¾Çªº¦a¤èÁ٫ܦh
¨¯­W±zÅo!

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD