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

[µo°Ý] ¥[¯Z®É¼Æ±ø¥ó³]©w,·P®¦

¦^´_ 10# JBY
¤w§¹¦¨,ÁÂÁ¤j¤j«ü¾É,±N¦b¤µ«á¤u§@¤W¦³²ö¤j§U¯q,
¦A¦¸·P®¦

TOP

¦^´_ 11# morgan6312
¦³¥i¯à¬O­Ó¤H¤W¶Ç¸ê®Æ¿ù»~,
§Ú­nªºµ²ªG¬O¹ê»Ú¤ä»â®É¼Æ,¦Ó«D¹ê¼Æ(ª÷ÃB)
¤j¤jµ¹ªºµ²ªG¬Oª÷ÃB¼Æ,¦Ó¤£¬O­Ó¤H©Ò»Ý­nªº®É¶¡¼Æ,
·P®¦

TOP

¦^´_ 12# morgan6312

­×§ï

¹ê»Ú¤ä»â (®É¼Æ) :

=MIN((SUMIF(G2:G5,"<=8")+COUNTIF(G2:G5,">8")*8+SUM(H2:H5)),ROUND(8000/120.26,0))

TOP

¦^´_ 13# JBY

¤w®M¥Î­q¥¿,·PÁ¤j¤j«ü¾É
·|§Q¥Î®É¶¡¬ã¨s°Ñ¦Ò³]©w§Þ¥©,·P®¦

TOP

¦^´_ 13# JBY
ªñ¤é¦b®M¥Î¤j¤jªº¤½¦¡®É¡]¥H31¤é­pºâ¡^¡Aµo²{¤u§@Á`®É¼Æ350¤p®É¡B¥[¯Z®É¼Æ78¤p®É¡A¹ê»Ú¤ä»â¹ê¼Æ67¤p®É¡A
®M¥Î¤½¦¡«á¡AµLªk²z¸Ñµ²¾l®É¼Æ251¤p®É¬O«ç»òµ²ºâ¥X¨Óªº,

01-1.zip (2.77 KB)

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD