I was able to do a simple subtracting formula to show amount owed and amount paid and balance remaining. Is there a way to expand on that formula to include when interest is charged so that it can be added to the balance? I want to have a more accurate picture of my financial spending. Any help or advice would be appreciated. Thank you.
