Forum Discussion

Welda1962's avatar
Welda1962
Copper Contributor
Jun 24, 2019
Solved

Percentages

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 ...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Jun 24, 2019

    Welda1962 

    For 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.

nabilmourad's avatar
nabilmourad
MVP
Jun 24, 2019

Welda1962 

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