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

[µo°Ý] µL®§¤À´Á¥¼¯à¾ã°£¤§ª÷ÃB¨Ö¤J­º´Á...

[µo°Ý] µL®§¤À´Á¥¼¯à¾ã°£¤§ª÷ÃB¨Ö¤J­º´Á...

µL®§¤À´Á¥¼¯à¾ã°£¤§ª÷ÃB¨Ö¤J­º´Á...

¸Õºâ¥»ª÷±Ä«ö´Á§¡Åu(¥¼¯à¾ã°£¤§ª÷ÃB¨Ö¤J­º´Á)
­Y¦³¦~§Q²v®É§Q®§­pºâ...¤p¼ÆÂI±N¥|±Ë¤­¤J¦Ü¾ã¼Æ¦ì

½Ð°Ý¥H¤U  E ~ H ¬ÛÃöÄæ¦ì¤§¼Æ¾Ú¤½¦¡¸Ó¦p¦ó³]©w??


1120708.rar (7.08 KB)

¦^´_ 4# ­ã´£³¡ªL

·PÁ  ­ã´£³¡ªL  ¦^ÂÐ
¨Ï¥ÎPMT¨ç¼Æ¥i¥H­pºâ¨C´ÁÀ³ÀvÁÙªº¶U´Úª÷ÃB
¨Ï¥ÎPPMT¨ç¼Æ©MIPMT¨ç¼Æ¥i¥H­pºâ¨C´ÁÁÙ´Úª÷ÃB¤¤ªº¥»ª÷©M§Q®§

TOP

¦^´_ 3# cypd

¤À´Á¥I´Ú¦U¶µª÷ÃB//¬d¤U¦C¨ç¼Æ¥Îªk//
PPMT
IPMT
PMT

TOP

¦^´_ 2# ­ã´£³¡ªL

«D±`·PÁ  ­ã´£³¡ªL  ¦^ÂÐ

­Y¬O  B2 Àx¦s®æ¤À´Á¦~§Q²v¬°  5%
½Ð°Ý G Äæ ¤À´Á§Q®§¤½¦¡¦p¦ó­×¥¿  ?

TOP

E2//
=IF(D2>B$3,"",B$1-SUM(F$1:F1))

F2//
=IF(N(E2)=0,"",INT(B$1/B$3)+MOD(B$1,B$3)*(D2=1))

TOP

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