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

[µo°Ý] ½Ð±Ð¤@­ÓIF§PÂ_°ÝÃD

¦^´_ 1# loantai


§ÚµLªk¤U¸ü ÀÉ®×, ¦ý±q±z¥t¤@½g¤¤¶Kªº¤U¦C¦¡¤l
"¸ê²`¤uŪ¥Í","¤uŪ¥Í"  ¸I¨ì OR(C44={"¸ê²`¤uŪ¥Í","¤uŪ¥Í"})  ³£¬OTrue
³£°õ¦æ (AV44-BN44)*L44   ¤£·| ¥h°õ¦æ False


    =IF(OR(C44={"¸ê²`¤uŪ¥Í","¤uŪ¥Í"}),(AV44-BN44)*L44,IF(L44>=Á~¸ê¯Å¾ªí!$N$5,SUM(U44:AU44)-BE44-BN44+(L44-Á~¸ê¯Å¾ªí!$N$5)*(SUM(U44:AD44)/Á~¸ê¯Å¾ªí!$N$5),IF(L44<Á~¸ê¯Å¾ªí!$N$5,SUM(U44:AM44)-BE44-BN44-(Á~¸ê¯Å¾ªí!$N$5-L44)*(SUM(U44:AD44)/Á~¸ê¯Å¾ªí!$N$5)))

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD