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

[µo°Ý] §éÂÂÅu¾Pªí

[µo°Ý] §éÂÂÅu¾Pªí

¦U¦ì¥ý¶i¡A¦³¤@Åu¾Pªí½Ð±Ð¦p¦ó§Ö³t»sªí(¦pªþÀÉ)¡A°²³]§Ú¦b2015/08¹w­pÁʤJ¤@¸ê²£($100,000)¡A­@¥Î¦~­­¬°¤T¦~¡A¨º»ò§é¶O¥Î«K¬O±q2015/08~2018/07¶}©l¡A¨C¤ë§é¶O¥Î¬°100,000/36=2,778¡A½Ð°Ý­n¦p¦ó³]©w¤½¦¡¡A¦b§Ú©ñ¤J¨ú±o¤é´Á®É¡A¥L·|¦Û°Ê¹ïÀ³¨ì­n¶}©lÅu¾Pªº¦~¤ë¡AÁÂÁ¡C

§éÂÂÅu¾Pªí.zip (30.79 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-4 15:20 ½s¿è

¦^´_ 1# shootingstar
Àx¦s®æE2¿é¤J
=IF((E$1<$D2)+(E$1>$D2+365*$C2),"",$B2/(12*$C2))
¦V¥k¡B¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD