Data Table

[Guest]

I am not sure I understand what I want here.
The name of the item is Data Table.
My customer wants the following info to be completed:

Rate 3%
Investment ? 2,000,000
Interest ? 60,000

? 60,000
3.00% In here I would like to see Interest amt for
3.50% the interest variables on the first columns.
4.00%
4.50%
5.00%
5.50%

Thanks again

Ann

 

[Mike Lewis]

Ann, you need to use the "data table" option from the
Excel menu.

Your spreadhseet is structured perfectly.

I assume that the cell to the right of "Interest" is a
formaula to calculate interest.

The cell to the upper right of your column of interest
rates must reference that cell i.e. "=E12".

Then highlight both the column of rates and also the
column to the right, make sure to include your formula.

Once highlited, go to menu and select Data - Table.

Enter the location of the cell that contains the interest
rate calcualtion in the "column input cell" box.

Press f9 to recalc and you are done.


Good luck

Mike