语法:ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])要点应运用 DATE 函数输入日
è¯æ³ï¼ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
è¦ç¹
åºè¿ç¨ DATE å½æ°è¾å ¥æ¥æï¼æè å°å½æ°ä½ä¸ºå ¶ä»å ¬å¼æå½æ°çç»æè¾å ¥ãä¾å¦ï¼è¿ç¨å½æ°DATE(2008,5,23) è¾å ¥ 2008 å¹´ 5 æ 23 æ¥ãåå¦æ¥æ以ææ¬å½¢å¼è¾å ¥ ï¼åä¼åºç°é®é¢ã
ACCRINT å½æ°è¯æ³å ·æä¸ååæ°ï¼
Issueå¿ éãè¯å¸çåè¡æ¥ã
First_interestå¿ éãè¯å¸çé¦æ¬¡è®¡æ¯æ¥ã
Settlementå¿ éãè¯å¸çç»ç®æ¥ãè¯å¸ç»ç®æ¥æ¯å¨åè¡æ¥æä¹åï¼è¯å¸åç»è´ä¹°è çæ¥æã
Rateå¿ éãè¯å¸çå¹´æ¯ç¥¨å©çã
Parå¿ éãè¯å¸ç票é¢å¼ãåå¦çææ¤åæ°ï¼å ACCRINT è¿ç¨ ï¿¥ 1,000ã
Frequencyå¿ éãå¹´ä»æ¯æ¬¡æ°ãåå¦æå¹´æ¯ä»ï¼frequency = 1;æåå¹´ææ¯ä» ï¼frequency = 2;æå£æ¯ä»ï¼frequency= 4ã
Basiså¯éãè¦è¿ç¨çæ¥è®¡æ°åºåç±»åã
calc_methodå¯éãä¸ä¸ªé»è¾å¼ï¼æå®å½ç»ç®æ¥ææäºé¦æ¬¡è®¡æ¯æ¥ææ¶ç¨äºè®¡ç®æ»åºè®¡å©æ¯çæ¹æ³ãåå¦å¼ä¸ºTRUE (1)ï¼ååæ¥ä»åè¡æ¥å°ç»ç®æ¥çæ»åºè®¡å©æ¯ãåå¦å¼ä¸º FALSE (0)ï¼ååæ¥ä»é¦æ¬¡è®¡æ¯æ¥å°ç»ç®æ¥çåºè®¡å©æ¯ãåå¦ä¸è¾å ¥æ¤åæ°ï¼åé»è®¸ä¸º TRUEã
说æ
Microsoft Excel å¯å°æ¥æåå¨ä¸ºå¯ç¨äºè®¡ç®çåºåå·ãé»è®¸æ åµä¸ï¼1900 å¹´ 1 æ 1 æ¥çåºåå·æ¯ 1ï¼è 2008å¹´ 1 æ 1 æ¥çåºåå·æ¯ 39448ï¼è¿æ¯å 为å®è· 1900 å¹´ 1 æ 1 æ¥æ 39448 天ã Microsoft Excel for theMacintosh è¿ç¨å¦å¤ä¸ä¸ªé»è®¸æ¥æç³»ç» ã
issueã first_interestã settlementã frequency å basis å°è¢«æªå°¾åæ´ã
åå¦ issueã first_interest æ settlement ä¸æ¯æææ¥æï¼å ACCRINT å°åæ¥è¿éå¼ #VALUE!ã
åå¦ rate ≤ 0 æ par ≤ 0ï¼å ACCRINT å°åæ¥è¿éå¼ #NUM!ã
åå¦ frequency ä¸æ¯æ°å 1ã 2 æ 4ï¼å ACCRINT å°åæ¥è¿éå¼ #NUM!ã
åå¦ basis < 0 æ basis > 4ï¼å ACCRINT å°åæ¥è¿éå¼ #NUM!ã
åå¦ issue ≥ settlementï¼å ACCRINT å°åæ¥è¿éå¼ #NUM!ã
å½æ° ACCRINT ç计ç®å ¬å¼å¦ä¸ï¼
å ¬å¼ä¸ï¼
Ai = å¥æ°æå 第 i 个å票æ¯æçåºè®¡å¤©æ°ã
NC = å¥æ°æå çå票æ¯æææ°ãåå¦è¯¥æ°å«æå°æ°ä½ï¼ååä¸è¿ä½è³ææ¥è¿çæ´æ°ã
NLi = å¥æ°æå 第 i 个å票æ¯æçæ£å¸¸å¤©æ°ã
示ä¾ï¼