Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Is TABLE() a custom macro? – sblair May 17 '11 at 10:20
Is there another cell somewhere that has a formula operating on this particular table? It seems as if TABLE just groups the cells together for another operation like a "what-if" analysis. – jonsca May 17 '11 at 10:38
good thought, but i don't see any macros. thx – user81607 May 17 '11 at 10:40
Reference for my other comment – jonsca May 17 '11 at 10:46

This is a data table, normally produced from (in Excel 2007) Data > Data Tools> What-if Analysis > Data Table...

It seems to be a 2-way table so the reference formula should be in the top-left cell of the table. E47 and C41 will be referred to in this formula, and the data table substitutes these values with the values in the leading row and column of the data table. You can use this feature to produce, for instance, a multiplication table.

See the following for more information:

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .