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

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

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

¥»©«³Ì«á¥Ñ loantai ©ó 2013-10-11 03:45 ½s¿è

½Ð±Ð¤@¤U¦p¦ó¤~¯àÅý"±Æ¯Zº[Á~¸êªí"¤¤ªº"¸ê²`¤uŪ¥Í"ªº®ÉÁ~¸òµÛ"Á~¸ê¯Å¾ªí"³]©w¤§®ÉÁ~¤@°_ÅÜ°Ê
¤uŪ¥Í»P¨ä¥L¾¦ì³£¥i¥¿±`¹F¨ì³]©w,°ß¿W"¸ê²`¤uŪ¥Í"µLªk¦Û°ÊÅܰʧP©w¬°109¤¸,·Q½Ð±Ð§P©w¨ç¼Æ¤¤¬O§_­þ¦³»~?ÁÙ±æ«e½ú«üÂI,ÁÂÁÂ

=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)))

102¦~10¤ë.rar (93.63 KB)

½Ð«üÂI

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-11 08:50 ½s¿è

¦^´_ 1# loantai
½Ð°Ý±zªº¤½¦¡­n¸m©ó­þ¤@Äæ(Àx¦s®æ)¡H·Ð½Ð§iª¾¡AÁÂÁ¡I

TOP

¦^´_ 2# p212
BW41¨º®æ

TOP

¦^´_ 3# sunnyso


   ¤£¦n·N«ä,¤w¸g§ï¥¿

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD