I have a spreadsheet in Apple Numbers which I use to track debts and amortize payments. To do this, I use calls to INDIRECT on the Amortization table to load relevant data from the Debts table. However, one of the INDIRECT calls is failing due to the error
This formula can't reference its own cell, or depend on another formula that references this cell
Here is the formula in question:
INDIRECT( "Interest Rate " & E1 )
It is supposed to load the name of the Loan from cell E1 and concatenate it on to the string
"Interest Rate " so that the formula will retrieve the value from the relevant cell in the Debts table.
The INDIRECT function is successfully used in the Amortization table elsewhere, since it works fine if I enter an Interest Rate manually.
What is it that I am doing wrong here? I tried deleting the cell that says "Interest Rate" in the Amortization table but it doesn't seem to change anything.
EDIT: Additionally, the Interest Rate cells in the Debts tables are values, not formulae. This issue is present regardless of the Loan selected, and this is using Numbers 10.0 (6748)