Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
see reply to earlier message
-- Regards Roger Govier wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
Sounds like a VBA code issue
there is a table function in VBA which might simlar I am not familiar with 2007, if this is what you are using, it may also be a fuction available there " wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
I can't figure out where the formula is that the table refers to.
That's the problem. It's like the formula is hidden. On Jun 1, 7:47 am, "Roger Govier" wrote: see reply to earlier message -- Regards Roger Govier wrote in message oups.com... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
Table function is u der the menu Dta -- table and is used mostly for
scenario analysis ..basically what the outcome would be if one of the variable were changed...In your particular instance the variables are in D19 thru D21 and the resuilts re coming from the cell right above the table perhaps E18 " wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
select cell d19
<tools<formula auditing<trace dependents a blue arrow show show from D19 to the cell with the formula used in the table your table should start right and down one cell the values in the table will change by sustituting the values to the right of the arrow into the equation at the arrow in the place of what the eqyation shows as D20 and D19 will be replaced by the values below the equation. This is from interpreting items in Help. with which I sometimes (ok most of the time) have problems. " wrote: I can't figure out where the formula is that the table refers to. That's the problem. It's like the formula is hidden. On Jun 1, 7:47 am, "Roger Govier" wrote: see reply to earlier message -- Regards Roger Govier wrote in message oups.com... 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do? {=table(D19,D21)}
Back in April I added some comments to a (somewhat) similar post. Lets say
that you are looking at NPV and IRR (a financial example). You can place the NPR and IRR on the horizontal axis (x axis). Lets say these go in C14:D14. Make sure these are references to the cells where you actually calculated the NPV and IRR, based on the cash flows generated by the project that you are analyzing! Hard coding these values will not work in your data table/sensitivity analysis. Then, you can place numbers corresponding to a growth rate on the vertical axis (y axis). Lets say these go in B15:B20. Starting at 0% and going to 25%, in increments of 5%, may be a good idea. Then click on B14 (the empty cell between your x & y vales). Move down and right so that B14:D20 are selected. Then click, Data, Table, Column input cell (this should be your growth rate, whatever cell it is on your spreadsheet), Ok. Your data table should populate with all relevant information. Write back if you get stuck somewhere. Check out this link for a much more comprehensive explanation of data tables and sensitivity analysis: http://www.ce.cmu.edu/~hsm/bca2005/l...chrome2001.pdf -- RyGuy "N Harkawat" wrote: Table function is u der the menu Dta -- table and is used mostly for scenario analysis ..basically what the outcome would be if one of the variable were changed...In your particular instance the variables are in D19 thru D21 and the resuilts re coming from the cell right above the table perhaps E18 " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data table function | Excel Worksheet Functions | |||
Table function question | Excel Worksheet Functions | |||
Pivot Table Function | Excel Worksheet Functions | |||
Pivot Table or Function?? | Excel Discussion (Misc queries) | |||
How do I use the TABLE worksheet function? | Excel Worksheet Functions |