Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|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

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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