LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default What does this function do? {=table(D19,D21)}

I'm reviewing someone else's excel model and I've run across something
I hadn't seen before. This is a repeated function in what appears to
be a 5x5 table. Obviously, D19 and D21 are referring to specific
cells. When I change those reference cells, the table changes.
However, I can't figure out where the results within this table are
coming from? For finance types, the results within the table are
IRRs, and the table is a sensitivity analysis (based on the D19 and
D21 reference cells) but I can't see where it's drawing from.

Any help would be appreciated.

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data table function maestro Excel Worksheet Functions 17 April 11th 07 12:34 PM
Table function question [email protected] Excel Worksheet Functions 0 January 31st 07 10:55 PM
Pivot Table Function carl Excel Worksheet Functions 1 May 24th 06 07:03 PM
Pivot Table or Function?? jo74 Excel Discussion (Misc queries) 1 November 22nd 05 08:39 PM
How do I use the TABLE worksheet function? Jo Excel Worksheet Functions 2 July 2nd 05 12:41 PM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"