ªð¦^¦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 : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD