up vote 3 down vote favorite
share [g+] share [fb]

I have inherited a spreadsheet with an IRR calculation that has the following formula:

{=TABLE(E47,C41)}

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.

link|improve this question
3  
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
feedback

1 Answer

up vote 3 down vote

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:

http://support.microsoft.com/kb/282856

http://www.techrepublic.com/article/teach-two-variable-excel-data-tables-with-real-life-examples/1042399

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.