Jun 24 2019 01:27 AM
I work out balances on debt owed and payments made. This is my formula I use to calculate the interest:
=(G8*C6/100)/365*D8
G8 is the capital amount due
C6 is the percentage
D8 is the total days between payments
Now on my next line (row 9) in want to tell it that if G9 is greater than G8 the formula must read:
=(G8*C6/100)/365*D9
if G9 is less than G8 the formula must be:
=(G9*C6/100)/365*D9
See attached spreadsheet
Jun 24 2019 01:48 AM
Hi
I guess you need to direct your calculation to one of 2 options based on a comparison between 2 values G8 & G9
Accordingly, it should be a simple IF statement like this:
=IF(G9>G8, (G8*C6/100)/365*D9, (G9*C6/100)/365*D9)
If copying your formulas down then you have to mind Relative & Absolute cell references.
Hope that helps
Nabil Mourad
Jun 24 2019 03:10 AM
SolutionFor consistency of formulas along rows, I suggest this formula in H8:
=IF(G8>G7,G7,G8)*
C$6/100*
D8/365
See such formula in the attached file.
Jun 24 2019 03:10 AM
SolutionFor consistency of formulas along rows, I suggest this formula in H8:
=IF(G8>G7,G7,G8)*
C$6/100*
D8/365
See such formula in the attached file.