Xisaabinta Dulsaarka Fudud^{(Simple Interest)} waa hab aad u fiican oo lagu qiimeeyo kaydkaaga hore. Si kastaba ha ahaatee, xisaabinta dano kala duwan iyo wadarta guud waxay noqon kartaa mid adag. Tani waa halka uu Excel u yimaado inuu ku caawiyo. Haddii aad rabto inaad xisaabiso xiisaha^(Interest) fudud ee Microsoft Excel , fadlan akhri maqaalkan.

Sida loo xisaabiyo dulsaarka^(Interest) fudud ee Excel

Haddii ay dhacdo Dulsaar^(Interest) Fudud , qaacidadu waa:

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

Markaa, qaacidada lagu helo xiisaha^(Interest) fudud ee Excel waxay noqotaa:

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

Halkee,

• <unug leh qiimaha aasaasiga ah> waa lambarka gacanta ee unugga ka kooban qaddarka ugu muhiimsan
• <cell with rate of interest> waa lambarka unugga unugga oo leh heerka dulsaarka.
• <cell with time period> waa wakhtiga dhigaalka ee sanadaha.

Waa in la ogaadaa in heerka dulsaarka uu yahay boqolkiiba. Waxaad u baahan tahay inaad ku darto calaamadda boqolkiiba ka dib markaad sheegto heerka. Haddii aan sidaas la yeelin waxay abuuri doontaa jaantus meesha xiisaha^(Interest) Fudud ee la gaaro uu noqon doono 100 jeer qiimaha saxda ah.

Sidoo kale, lacagta qiimaha ugu muhiimsan waxaa lagu dari karaa tabka Guriga .^(Home)

Tusaale ahaan. Aan ka soo qaadno in qiyamka aasaasiga ahi ay ku jiraan tiirka A laga bilaabo unugga A3 ilaa A11 , heerka dulsaarka qiimuhu waa tiirka B laga bilaabo unugga B3 ilaa B11 , qiyamka muddada wakhtigana waxay ku jiraan tiirka C laga bilaabo unugga C3 ilaa C11 . Qiimaha xiisaha fudud ayaa looga baahan yahay tiirka D laga bilaabo D3 ilaa D11 . Qaabka xiisaha fudud ee D3 wuxuu noqonayaa:

=A3*B3*C3 

Geli caanahan unugga D3 ka dibna isticmaal shaqada Buuxi^(Fill) si aad ugu qaaddo unugga D11 . Si aad sidaas u samayso, dhagsii meel kasta oo ka baxsan unugga D3 ka dibna dib ugu celi unugga D3. Kadib, waxaad ku arki doontaa dhibic yar oo ku taal geeska hoose ee midig ee unugga D3.

Rajo inay ku caawiso!

Akhri soo socda^{(Read next)} : Xisaabi miisaanka ilaa dhererka saamiga iyo BMI gudaha Excel adoo isticmaalaya qaacidada xisaabinta ee 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

• Sida loo xisaabiyo xiisaha isku dhafan ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Casharka Microsoft Excel, ee Bilowga ah

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida waqti loogu daro ama loogu daro Microsoft Excel