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.

Twifoo's avatar
Twifoo
Silver Contributor
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.