S sapril Member Licensed User Dec 8, 2020 #1 I have a problem, how to write the formula b4a : Fee = Rate(Total, Installment, -ph, 0) please help, thank you .
I have a problem, how to write the formula b4a : Fee = Rate(Total, Installment, -ph, 0) please help, thank you .
aeric Expert Licensed User Longtime User Dec 8, 2020 #2 Like this? B4X: R = (1/t)(A/P-1)*100 r = Rate of Interest per year in decimal; r = R/100 t = Time Period involved in months or years A = Total Accrued Amount (principal + interest) P = Principal Amount R = Rate of Interest per year as a percent; R = r * 100 Source: https://www.calculatorsoup.com/calculators/financial/simple-interest-plus-principal-calculator.php Upvote 0
Like this? B4X: R = (1/t)(A/P-1)*100 r = Rate of Interest per year in decimal; r = R/100 t = Time Period involved in months or years A = Total Accrued Amount (principal + interest) P = Principal Amount R = Rate of Interest per year as a percent; R = r * 100 Source: https://www.calculatorsoup.com/calculators/financial/simple-interest-plus-principal-calculator.php