计算单利^{(Simple Interest)}是提前判断您的储蓄的好方法。然而，计算一系列利息和本金金额可能很复杂。这就是Excel提供帮助的地方。如果您想在Microsoft Excel中计算单^{(Microsoft Excel)}利^(Interest)，请通读这篇文章。

如何在Excel中计算单^(Excel)利^(Interest)

在 Simple Interest的情况下，公式为：

Simple Interest = Principal * Rate of Interest (annual) * Time Period (annual)

因此，在Excel中查找简单^(Excel)兴趣^(Interest)的公式变为：

=<cell with principal value>*<cell with rate of interest>*<cell with time period>

在哪里，

• <cell with principal value> 是包含本金金额的单元格的单元格编号。
• <具有利率的单元格> 是具有利率的单元格的单元格编号。
• <cell with time period> 是以年为单位的存款时间段。

需要注意的是，利率是百分比。您需要在提及费率后添加百分比符号。不这样做将创建一个数字，其中获得的单利^(Interest)将是正确值的 100 倍。

此外，可以从主页^(Home)选项卡添加本金价值的货币。

例如。假设本金值在单元格 A3 到A11的 A 列中，利率值在单元格 B3 到B11的 B 列中，时间段的值在单元格 C3 到C11的 C 列中。从 D3 到D11^(D11)的 D 列中需要简单感兴趣的值。对 D3 的简单兴趣的公式将变为：

=A3*B3*C3 

在单元格 D3 中输入此公式，然后使用Fill函数将其带到单元格D11。为此，请单击单元格 D3 之外的任意位置，然后返回单元格 D3。然后，您会注意到单元格 D3 的右下角有一个小点。

希望能帮助到你！

阅读下一篇^{(Read next)}：使用此 BMI 计算公式在 Excel 中计算体重身高比和 BMI^{(Calculate Weight to Height ratio and BMI in Excel using this BMI calculation formula)}。

How to calculate Simple Interest in Excel

Calculating Simple Interest is an excellent method to judge your savings in advance. However, calculating it for a range of interests and principal sums could be complex. This is where Excel comes to help. If you wish to calculate Simple Interest in Microsoft Excel, please read through this article.

How to calculate Simple Interest in Excel

In case of Simple Interest, the formula is:

Simple Interest = Principal * Rate of Interest (annual) * Time Period (annual)

Thus, the formula for finding Simple Interest in Excel becomes:

=<cell with principal value>*<cell with rate of interest>*<cell with time period>

Where,

• <cell with principal value> is the cell number of the cell containing the principal amount.
• <cell with rate of interest> is the cell number of the cell with the rate of interest.
• <cell with time period> is the time period of the deposit in years.

It should be noted that the rate of interest is in percentage. You need to add the percentage symbol after mentioning the rate. Not doing so will create a figure where the Simple Interest attained would be 100 times the correct value.

Also, the currency of the principal value could be added from the Home tab.

Eg. Let us assume that the principal values are in column A from cell A3 to A11, rate of interest values are in column B from cell B3 to B11, and the values of time period are in column C from cell C3 to C11. The values of simple interest are needed in column D from D3 to D11. The formula for simple interest in D3 would become:

=A3*B3*C3 

Enter this formula in cell D3 and then use the Fill function to carry it till cell D11. To do so, click anywhere outside cell D3 and then back on cell D3. Then, you would notice a little dot at the right-bottom corner of cell D3.

Hope it helps!

Read next: Calculate Weight to Height ratio and BMI in Excel using this BMI calculation formula.

Related posts

• 如何计算Excel中的Compound Interest

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Windows 11/10中创建Radar Chart

• 如何在Excel formula中锁定单元格以保护它们

• 如何在Microsoft Excel中提取URLs中的域名

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Microsoft Excel中使用HLOOKUP function

• Microsoft Excel正试图恢复您的信息

• Microsoft Excel在Windows 10运行时导致High CPU usage

• How以使用Excel的Mode function

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何将一列拆分为Excel中的多列

• 如何在Excel中创建Organization Chart

• 如何在Excel中使用Duration Financial Function

• 如何在Excel创建和使用Form Controls

• 如何在一页上打印Excel or Google Sheets中所选单元格