唔識入EXCEL FORMULA, 請幫幫手!

2007-07-20 8:05 am

A1: Interest rate 7.5% (365 days per annum)
B1: Loans start date 19 JUL 2007
C1: Loans due date10 SEP 2007
D1: Loans amount HKD10,000.00
E1: Interest Amount? (Set Formula)

HKD10,000 x (7.5%/365) x (10SEP2007-19JUL2007) = Answer

回答 (2)

Adit

2007-07-20 8:29 pm

✔ 最佳答案

First you need to format the cell if you want to calculate the day.
In B1 & C1 cell, format it to the date format you prefer and in E1 cell format it to number.
Enter the formula in E1 as

= D1*(A1/365)*(C1-B1)

👍 0 👎 0

et0418

2007-07-20 9:56 am

=10000 * (7.5%/365) * (date(2007,9,10) - date(2007,7,19) )

👍 0 👎 0

收錄日期: 2021-04-13 00:49:23
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070720000051KK00025

檢視 Wayback Machine 備份