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

¦h±ø¥ó¦¡­pºâ(¤w¸Ñ¨M)

¦h±ø¥ó¦¡­pºâ(¤w¸Ñ¨M)

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

«ô°U·|¨ç¼Æªº°ª¤âÀ°À°§Ú¦n¶Ü?
§Ú¤S¬O·s¤â
À´±o¤£¦h¥u¦n¤W¨Ó¨D±Ï

¦^´_ 1# koala2099

E5=D5/VLOOKUP(A5,$A$17:$B$21,2,0)*VLOOKUP(C5,$B$2:$E$3,2,0)/VLOOKUP(C5,$B$2:$E$3,3,0)*VLOOKUP(C5,$B$2:$E$3,4,0)
©Î
E5=D5/VLOOKUP(A5,$A$17:$B$21,2,0)*SUM(($B$2:$B$3=C5)*$C$2:$C$3/$D$2:$D$3*$E$2:$E$3)     °}¦C¤½¦¡

TOP

¦^´_ 1# koala2099

°}¦C¤½¦¡
E5=D5/SUM(($A$17:$A$21=A5)*($B$16:$C$16=C5&"¥Ø¼Ð")*$B$17:$C$21)*SUM(($B$2:$B$3=C5)*$C$2:$C$3/$D$2:$D$3*$E$2:$E$3)

TOP

¦^´_ 1# koala2099

E5=INDEX($B$17:$C$21,MATCH($A5,$A$17:$A$21,0),MATCH($C5&"¥Ø¼Ð",$B$16:$C$16,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-1-13 22:27 ½s¿è

¨S·Q¨ì³o»ò§Ö´N±o¨ì¦^À³
·PÁ¤j¤j¬°§Ú¸Ñ¨M¤u§@¤Wªº§xÂZ
Åý§Ú³o¤u§@·s¤â§Ö³t§¹¦¨¤âÃä¤u§@
¨¯­W¤F~

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD