¾´«³¬¼¶´óµ¥Ö¸±ê¸±Í¼ÊÇÒ»ÖÖÀûÓü¼Êõ·ÖÎöµÄÖ¸±ê¹¤¾ß£¬ÓÃÓÚ¸¨ÖúÑ¡¹É¡£Ëüͨ¹ý¼ÆËãÿÈճɽ»Á¿Öеij¬´óµ¥±ÈÀý£¬²¢½«Æä»æÖÆÔÚKÏßͼµÄ¸¨ÖúͼÉÏ¡£Õâ¸öÖ¸±êÄܹ»Ö±¹ÛµØÏÔʾ³¬´óµ¥µÄÂòÂôÇé¿ö£¬°ïÖúͶ×ÊÕßÁ˽âÊг¡µÄ×ʽðÁ÷ÏòºÍ¶¯Ïò¡£Ê¹ÓÃËü¿ÉÒÔ¸¨ÖúÅжϹÉƱµÄ×ßÊƺÍÇ÷ÊÆ£¬Ìá¸ßÑ¡¹ÉµÄ׼ȷÐÔ¡£ ͨ´ïÐź¯ÊýÔ´ÂëÈçÏ£º ``` ´óµ¥Á¿=VOL*(C>=HHV(C,20)) ³¬´óµ¥Á¿=VOL*(C>=HHV(C,20))*2 ³¬´óµ¥±ÈÀý=SUM(³¬´óµ¥Á¿,30)/SUM(´óµ¥Á¿,30)*100 ``` ÒÔÉÏÊǾ´«³¬¼¶´óµ¥Ö¸±ê¸±Í¼µÄ¼ÆË㹫ʽ£¬Í¨¹ý½«ÆäÓ¦ÓÃÔÚͨ´ïÐÅÈí¼þÖУ¬¾Í¿ÉÒԵõ½ÏàÓ¦µÄ¸±Í¼¡£ ¹Ø¼ü´Ê£º¾´«³¬¼¶´óµ¥Ö¸±ê¸±Í¼¼¼Êõ·ÖÎöÑ¡¹É¹ÉƱ³É½»Á¿³¬´óµ¥ÂòÂôÇé¿ö×ʽðÁ÷Ïò×ßÊÆÇ÷ÊÆ