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

[µo°Ý] ¶ñ¤J¼t¯Ê&µù¸Ñ

¥»©«³Ì«á¥Ñ PJChen ©ó 2020-5-31 22:38 ½s¿è

¦^´_ 20# ­ã´£³¡ªL
  1.     If Val(Brr(i, 1)) < 0 Then
  2.        T(1) = "¤é¦L" & Format(Crr(i, 1), "m/d ") & "*" & Val(Crr(i, 2)) & "½c" & IIf(Val(Crr(i, 3)) > 0, "+" & Crr(i, 3), "")
  3.     End If
  4.     If Val(Brr(i, 2)) < 0 Then
  5.        T(2) = "¤é¦L" & Format(Crr(i, 4), "m/d ") & "*" & Val(Crr(i, 5)) & "½c" & IIf(Val(Crr(i, 6)) > 0, "+" & Crr(i, 6), "")
  6.     End If
  7.     TT(1) = T(1) & IIf(T(2) = "", "", vbCrLf & T(2))
  8.     '--------------------------------
  9.     If Val(Brr(i, 3)) < 0 Then
  10.        T(3) = "¤é¦L" & Format(Crr(i, 7), "m/d ") & "*" & Val(Crr(i, 8)) & "½c" & IIf(Val(Crr(i, 9)) > 0, "+" & Crr(i, 9), "")
  11.     End If
  12.     If Val(Brr(i, 4)) < 0 Then
  13.        T(4) = "¤é¦L" & Format(Crr(i, 10), "m/d ") & "*" & Val(Crr(i, 11)) & "½c" & IIf(Val(Crr(i, 12)) > 0, "+" & Crr(i, 12), "")
  14.     End If
½Æ»s¥N½X
'----------------------------------
­ã¤j¦n,
¥H¤Wµ{¦¡¹ïÀ³¨Ó·½¡G³Ì·s®w¦sB.xlsx GE:GPªº4²Õ½LÂI¸ê®Æ,·íVal(Brr) < 0,«h­n²£¥Íµù¸Ñ
¦ý²£¥Íªºµù¸Ñ´X¥G³£¤£¹ï,¥i§_§ï¬°§P§OED:EE>0²£¥Íµù¸Ñ,¤ñ¸û¦n§P§O¥Bª½Æ[¡I
¬O§_²£¥Íµù¸Ñ,³£¬ÝED:EE¬O§_>0
¥H¤U°t¦XÀÉ®×,¤ñ¸û¦n²z¸Ñ......
1) ¥H¦^¼t¼ÆED:EE§@§P§O, ¼Æ­È>0,¥Nªí¦³²£«~­n¦^¼t
2) ³o®ÉGA:GD¦Ü¤Ö¦³¤@­Ó­È<0,§ä<0¦bCKªº­þ¤@²Õ
3) ¦A¹ïÀ³GE:GPªº4²Õ½LÂI¸ê®Æ,¦¨¬°µù¸Ñªº¨Ó·½
4) 4²Õ½LÂI¸ê®Æ, ¤@©w¬O¥Ñ¤p¨ì¤j±Æ¦C,¤é´Á¤pªº±Æ¦b«e­±
5) ED:EE¥HEDÀu¥ý§P§O,ED³Ñ¤U¨Óªº¦^¼t¼Æ,´N¬OEEªº
6) EEÄæ: µL¦^¼t¼Æ®É,Àx¦s®æ¬°0 (¥­®É¦³¤½¦¡)
7) ED¬O¤â°Ê¶ñ¤J,µL¦^¼t¼Æ®ÉÀx¦s®æ¬°ªÅ¥Õ
8) EDªº­È>0 & ´«ºâ«á¥þ³¡¾ã¼Æ½c,­YEE>0,«hEE¦^¼t¹s¼Æ²~
9) EDªº­È>0 & ´«ºâ«á ¾ã½c+²~ ,³o®ÉEE¤@©w=0(µL¦^¼t)

ex1:
ED4=4416=4416/¤J¼Æ24=184½c (§äGA:GD¥þ³¡<0,«hµù¸ÑGE:GP 4²Õ¤é´Á)
EE4=5/¤J¼Æ24=¤£¨¬1½c=5(1²Õ¤é´Á)

ex2:³o­Ó§¹¥þµLªk²£¥Íµù¸Ñ
ED4=ªÅ¥Õ (µL¦^¼t=µLµù¸Ñ)
EE4=425/¤J¼Æ16=(2²Õ¤é´Á)
¦b¥ØªºÀÉAW²£¥Íµù¸Ñ
05/17*9
05/18*26½c

TOP

¦^´_ 21# PJChen


ÁöµM»¡©ú¦h¦¸, ¦ýÁÙ¬O§Ë¤£À´, ¤@°ï¤å¦r¬Ý±o²´ªá,
µ{¦¡½X¤w¾¨¶q¤À¶}¼g§PÂ_, µ¹¤F¤èªk, ­Y³£µLªk²z¸Ñµ{¦¡½X¦Ó¦Û¦æ­×§ï,
³o¼Ë¤j®a³£¦£¤£§¹~~

TOP

¦^´_ 3# ­ã´£³¡ªL
­ã¤j¦n,

§Ú·Q¦b¸ü¤J¼t¯Êµ{¦¡¤¤,¥[¤J¸ü¤J¹º³æ¼Æ¦r,¸ê®Æ¨Ó·½¬°
­ì©l­q³æAP:BH
¼t¯Ê¼ÆBJ:CB
¹º³æ¼ÆCD:CV
1) ¤ë®w¦sªí¤ºªº­ì©l­q³æ¼Æ¦r¬O§@·~ªÌ,¦Û¦æ¶ñ¤J,¥u¦³¼Æ­È
2) ¦P¤@®Æ¸¹,­Y¦³¼t¯Ê¼Æ®É«h,Àx¦s®æ¤º=­ì©l­q³æ-¼t¯Ê¼Æ,
µù¸Ñ:
¼t¯Ê*XXX
3) ¦P¤@®Æ¸¹,­Y¦³¹º³æ¼Æ®É«h,Àx¦s®æ¤º=­ì©l­q³æ-¹º³æ¼Æ,
µù¸Ñ:
¹º³æ*XXX
4) ¦P¤@®Æ¸¹,­Y¦³¼t¯Ê¼Æ&¹º³æ¼Æ®É«h,Àx¦s®æ¤º=­ì©l­q³æ-¼t¯Ê¼Æ-¹º³æ¼Æ,
µù¸Ñ:
¼t¯Ê*XXX
¹º³æ*XXX

½Ð°Ýµ{¦¡¦p¦ó­×§ï¹F¨ì¤W­z»Ý¨D¡H
¼t¯Ê¶ñ¤J¤½¥Î®w¦sªí2.rar (875.74 KB)

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2022-4-17 20:47 ½s¿è

¦^´_ 22# ­ã´£³¡ªL
­ã¤j¦n,
³o­Óµ{¦¡§ï¤F¤@¦~¦h,³Ì«á­×§ï¤F±z¤§«e¼gªº¤@­Ó¥tµ{¦¡&¦X¨Ö³o­Ó,¥Î¨Ó¸ü¤J²£«~¹L¤¹ªº¼Æ¶q¤Î³Æµù,
­×§ï«á¼g¤J³Æµù¤è­±¦³¨ÇBug,¯à§_½Ð±z¼·¤¾À°¦£¬Ý¤U¡H§Ú§âµ{¦¡¼g¦b"­¸¤ñÁ`ªí.xls"¤¤

³Æµù§ì¨ú¤è¦¡
1..¨C­Ó®Æ¸¹,·íED:EE>0,«h¶ñ¤J¤½¥Î®w¦sªíªºAX:AY¬Û¹ïÀ³¦ì¸m
2..ED:EE>0ªº¦P¤@¦C,FZ:GC´N·|<0,
     ¦P¤@®Æ¸¹¾î¦V¨úFZ:GC,¨Ì§Ç¨ú
EX: C15®Æ¸¹,EE22=64
FZ22<0,¨úGE22ªº¤é´Á+GX22ªº¼Æ¶q...4/28*44
GA22=<0¨úGH22ªº¤é´Á+GY22ªº¼Æ¶q...4/29*20
GB22=<0¨úGK22ªº¤é´Á+GZ22ªº¼Æ¶q...4/30*336
¶ñ¤J¤½¥Î®w¦sªíªºAY22ªº³Æµù¤¤

3..°õ¦æ¶ñ¤J³Æµùªº°ÝÃD
GA:GC<0,·í³Æµù¶ñ¤JAX:AY®É,
GA:GC·|³Q­«½Æ§P§O,¾É­Pµù¸Ñ­«½Æ¶ñ¤JAX:AY¤¤

¦³°ÝÃDªº³¡¥÷,¦b¤½¥Î®w¦sªí¤¤,¤w¥Î¤£¦PÃC¦â¾ã¦CµÛ¦â,
½Ð°Ý­ã¤j,¦p¦óÅý³Æµù¤£­n³Q­«½Æ§ì¨ú?
¼g¤J¹L¤¹¼Æ¶q¤Î³Æµù.rar (204.82 KB)

TOP

¦^´_ 24# PJChen

ÁÂÁ¤j®a,
§Ú¤w§ä¨ì¤èªk¤F¡I

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD