Which at first looked great, I thought I had only the else part to fix. But it turns out that the IF always evaluates to true. Whether I put 1, “1”, 8 or “8”.
Please relieve me of my misery, what am I missing?
hi @Piet_Strydom , since you try to calculate interests over loans, did you consider using Power(), this function avoids that you have to apply a spreadsheet logic in which you work with previous rows.
Thanks for the idea. What I am working on is to allow for variable payments and reversals into a loan account. And the technique will also be helpful in other areas where one wants to work with financial information over a period of time exceeding a year.
Anybody that needs to build a table for a loan account with payments, withdrawals and an interest calc, please feel free to use this. It has one month in a row, and is quite a bit quicker to set up than 12 months in a row.