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

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

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

½Ð±Ð¤@¤U¦p¦ó¤~¯àÅý"±Æ¯Zº[Á~¸êªí"¤¤AV41Àx¦s®æ 102¦~10¤ë.rar (89.05 KB) ªº®ÉÁ~¸òµÛ"±Æ¯Zº[Á~¸êªí"C41Àx¦s®æªº¿ï¶µÀH"Á~¸ê¯Å¾ªí"³]©w¤§®ÉÁ~¤@°_ÅÜ°Ê
¤U©Ô¦¡¿ï³æ¿ï¥X¤uŪ¥Í»P¨ä¥L¾¦ì³£¥i¥¿±`¹F¨ì¤½¦¡³]©w,°ß¿W"¸ê²`¤uŪ¥Í"µLªk¦Û°ÊÅܰʧP©w¬°115¤¸,µ²ªG»P¤uŪ¥Í¿ï¶µ109¬Û¦P,·Q½Ð±Ð§P©w¨ç¼Æ¤¤¬O§_­þ¦³»~?ÁÙ±æ«e½ú«üÂI,ÁÂÁÂ

¦^´_ 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

¦^´_ 2# yuhuahsiao







TOP

¦^´_ 3# loantai


    AV41 =IF((C41="¤uŪ¥Í"),Á~¸ê¯Å¾ªí!$L$5,IF(C41="¸ê²`¤uŪ¥Í",Á~¸ê¯Å¾ªí!$L$6,0))

   ¥L¤½¦¡ªº­ì·N¬O¤uŪ¥Í= ¸ê²`¤uŪ¥Í = ®ÉÁ~109   ¨ä¥L¤H´N¥X²{0
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# loantai

=IF(C41="¤uŪ¥Í",Á~¸ê¯Å¾ªí!$L$5,IF(C41="¸ê²`¤uŪ¥Í",Á~¸ê¯Å¾ªí!$L$6,0))

TOP

ÁÂÁ¦U¦ì«üÂI,¤F¸Ñ¦p¦ó¨Ï¥Î¤F,·P¿E¸U¤À

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD