Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data table - hmz - 2nd posting because could not find the first on
Hi,
I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, hmz -- hmz Wash DC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Posting Data From 1 Wksht to Another | Excel Worksheet Functions | |||
How can I find out where data in piviot table comes from | Excel Discussion (Misc queries) | |||
Find a specific posting | New Users to Excel | |||
Find data in one table from another. | Excel Worksheet Functions | |||
the owner of posting should be able to delete the posting | Excel Discussion (Misc queries) |