I have inherited a spreadsheet with an IRR calculation that has the following formula:
I would guess it is a structured reference referring to a table, but I can't find the table.
Q1: What is the formula doing? It pulls in an NPV amount, which is then used for IRR, so it seems to be some sort of look up.
Q2: If a formula is referring to a table, how do I find the table? I can see many tables being recalculated, but can't find them.