LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
hmz hmz is offline
external usenet poster
 
Posts: 16
Default 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
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
Posting Data From 1 Wksht to Another RobL Excel Worksheet Functions 1 December 5th 07 07:50 PM
How can I find out where data in piviot table comes from kristall Excel Discussion (Misc queries) 1 October 24th 07 12:18 PM
Find a specific posting Jerry New Users to Excel 16 September 26th 06 01:54 AM
Find data in one table from another. micmed Excel Worksheet Functions 23 January 22nd 06 11:45 PM
the owner of posting should be able to delete the posting Mahendra Excel Discussion (Misc queries) 7 August 8th 05 07:21 PM


All times are GMT +1. The time now is 07:04 PM.

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

About Us

"It's about Microsoft Excel"