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

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

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

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