Hi.
Anyone can help me how to make block coding for this calculation . I want to make application for calculating amount of interst obtain from this farmula
Principle X rate of interest X year . Anyone can help
If we assume that the formula to calculate interest is the principal x by the interest (%) and multiplied by the years, it would be something like this:
Good validation, but
The Is Number test covers the blank test, and
Compound interest would require the ^ operation, right?
"The Is Number test covers the blank test"
I had not considered that...so, those validations are not necessary...Thank you for the comment.
For the interest formula...I have written what I understood he asked for...I don't have much idea how to calculate compound interest....
then it would be something like this (if I haven't googled the formula wrong...):
P [(1 + i)^n – 1]
Where:
P = principal
i = annual interest rate
n = number of compounding periods
Thank you @ABG !
The Is Number test is still necessary, because the textbox numbers flag leaks blanks
From the last time I banged my head on an accounting book, I guess
New Principal = Principal * (1+(rate/100))^years
(Edit)
Note for OP
Since you wear suit and tie, I guess presentation is important to you.
Spelling...
Principal
Formula
In case you are wondering how I guessed this was a compound interest question...
There is a high correlation between wearing a suit and tie and the calculation of compound interest, in my experience.
Bankers,
Real Estate Brokers,
Car dealers
They all bring out that paperwork at the end.
thank you everyone
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.