I work out balances on debt owed and payments made. This is my formula I use to calculate the interest:
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:
if G9 is less than G8 the formula must be:
See attached spreadsheet
View best response
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
For consistency of formulas along rows, I suggest this formula in H8:
See such formula in the attached file.