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

¨ç¼Æ&®æ¦¡¤ÆÀx¦s®æ¨D¸Ñvba¼gªk

¨ç¼Æ&®æ¦¡¤ÆÀx¦s®æ¨D¸Ñvba¼gªk

²[¼Æ:
V11=IF(G11="","",R11+U11+T11) ¤U©Ô½Æ»s¤½¦¡
W11=IF(G11="","",G11-V11) ¤U©Ô½Æ»s¤½¦¡
X11=IF(V11>G11,"¸ê®Æ¿ù»~",IF(W11=0,"µ²","")) ¤U©Ô½Æ»s¤½¦¡
Y11=IF(H11="","",IF(COUNT(AD11),TEXT(LOOKUP(99999,AD11:AH11)-H11,"0;;0"),TODAY()-H11)) ¤U©Ô½Æ»s¤½¦¡

Åܰʮ榡¤ÆÀx¦s®æ: (¥H¤U®æ¦¡¬Ò®M¥Î¦Ü³Ì«á¤@¦C)
­YÀx¦s®æX11="µ²", «h¦r«¬²ÊÅéÂŦr, ­Y="¸ê®Æ¿ù»~", «h¬õ©³¶À¦r
­YT11>S11, «hT11®æ¦¡¬°¬õ©³¶À¦r
­YR11>P11, «hR11®æ¦¡¬°¬õ©³¶À¦r
­YP11>N11, «hP11®æ¦¡¬°¬õ©³¶À¦r
­YN11>L11, «hN11®æ¦¡¬°¬õ©³¶À¦r
­YL11>J11, «hL11®æ¦¡¬°¬õ©³¶À¦r
­YJ11>G11, «hJ11®æ¦¡¬°¬õ©³¶À¦r

¦^´_ 1# 074063


    §A³o¸Ì¤£¬O¦³¬Û¦Pªº°ÝÃD¶Ü¡H
http://forum.twbts.com/thread-14719-1-1.html

TOP

¦^´_ 2# lpk187


    ³æ¯Â+-ªº¸ÜÁÙ¥i¥H, ­Y¬O¥[¤W¤@¨Ç§PÂ_ªº¸Ü´N¤£ª¾¹D¦p¦óµÛ¤â

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD