| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
data tables in Excel
How do I create a data table into Excel that shows varing interest rates and
how they would affect the payments? I am using Excel Professional. Thanks, TJ |
|
#2
|
|||
|
|||
|
Hi TJ,
Maybe you can be a bit more specific? Formulas? What exactly do you want to see? What should vary? -- Kind regards, Niek Otten Microsoft MVP - Excel "TJ" wrote in message ... How do I create a data table into Excel that shows varing interest rates and how they would affect the payments? I am using Excel Professional. Thanks, TJ |
|
#3
|
|||
|
|||
|
TJ -
That's the example in the "About Data Tables" entry of Excel's Help. - Mike www.mikemiddleton.com "TJ" wrote in message ... How do I create a data table into Excel that shows varing interest rates and how they would affect the payments? I am using Excel Professional. Thanks, TJ |
|
#4
|
|||
|
|||
|
I need to set up a data table to show what the different payments would be
when I vary the interest from 3-8% in increments of .5% Thanks, TJ "Niek Otten" wrote: Hi TJ, Maybe you can be a bit more specific? Formulas? What exactly do you want to see? What should vary? -- Kind regards, Niek Otten Microsoft MVP - Excel "TJ" wrote in message ... How do I create a data table into Excel that shows varing interest rates and how they would affect the payments? I am using Excel Professional. Thanks, TJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| Fan charts | Charts and Charting in Excel | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
