Data Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top