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

¦p¦ó­pºâ¾lÃB

¥»©«³Ì«á¥Ñ register313 ©ó 2012-5-15 17:58 ½s¿è

¦^´_ 10# leiru


1.     B6=ROUNDDOWN(B4/12,0)
  => B6=ROUNDDOWN(B4/((YEAR(B3)-YEAR(B2))*12+MONTH(B3)-MONTH(B2)),0)
       ¦~ú:¬õ¦r=12
       ¥b¦~ú:¬õ¦r=6
       ©uú:¬õ¦r=3
2.¨ä¥LÀx¦s®æÀ³¸Ó¤£¥Î­×¥¿§a
3.Àˬd´ú¸Õ¬Ý¬Ý

TOP

¦^´_ 10# leiru


B6=ROUNDDOWN(B4/DATEDIF(B2,B3+1,"M"),0)
¨ä¤¤B7À³¦¬¤Ñ¼Æ¸òB8À³¦¬ª÷ÃBÀ³¸Ó¦Ò¼{°h¯²·í¤é¬O§_À³¸Ó¦¬¶O
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂregister313¤ÎHsieh¨â¦ì¤j®v,­è¤~¸Õ¤F,µª®×³£¥¿½T,ÁÂÁÂ
TO Hsieh:°h¯²¤é·í¤Ñ¬O­n¦¬¶Oªº.
joyce

TOP

¦^´_ 11# register313


    register313¤j®v
½Ð°Ý§Ú®M³o¤½¦¡,§ó§ï°_¨´¤é,µo²{µª®×¤£¹ï,´f½Ð«ü±Ð.

¦p¦ó­pºâ°h¾lÃB.zip (8.98 KB)

joyce

TOP

¦^´_ 14# leiru

B7=ROUNDDOWN(B5/DATEDIF(B3,B4+1,"M"),0)

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD