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

¦X­p¹Bºâ°¾®t¡A¬O§_¦³¸Ñ

¦^´_ 10# jackson7015

G10 =IF(LEN($F10)>0,ROUND((P$13-SUM(G$1:G9))*F10/SUM(F10:F$41),0),"")
½Æ»s¨ìH10
G10:H10©¹¤U½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
¥ý·PÁÂML089ª©¥Dªº¦^ÂÐ

³o­Ó­pºâ¤½¬O¤]ÆZ¯S§Oªº
¥H²{¦³¼Æ¾Ú­pºâ¨Ó¬Ý¡A¥i¥Hº¡¨¬¹q¸£¸Õºâªº³¡¤À
¦ý¬Oªí­±¤WªºÁ`¦X­p¥i¯à·|³Q¤NÃø¡A³o³¡¤À¥u¯à¸ò·|­p¥h¨ó½Õ¤F

¦A¦¸ÁÂÁ«e½ú­Ìªº«ü¾É

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD