Thank you but this was not helpful. I want to have both sets "live" so that
changes can be made and obserrved, also, the insertnamedefine does not
work. Only the cell name appears in the name box.
This is what I am trying to do:
Ron
Enter values
Loan amount $30,000.00
Annual interest rate 3.290% 5.000%
Loan period in years 5 5
Start date of loan 4/1/2005 4/1/2005

Monthly payment $542.94 $542.94
Number of payments 60 60
Total interest $2,576.13 $2,576.13
Total cost of loan $32,576.13 $32,576.13




"Peo Sjoblom" wrote:

Why don't you copy and paste special as values, that way you would have the
data you need
independent of the formulas, then put in the modified data where the first
used to be for a comparison?
Btw, the cells are using defined names, that is why you see them in the name
box when you select the cells
it can be foound and changed under insertnamedefine where you can see a
list of all names and their
absolute references, if you delete from there they will revert to the cell
coordinates


--

Regards,

Peo Sjoblom


"Mr. C" <Mr. wrote in message
...
I am trying to use the loan calculator two times at once, on the same
spreadsheet. In other words, copy the column of cells that the variables
are
entered into, (Loan Amount, Interest Rate, Years, Start Date) to a nearby
column and run slightly different numbers, say different interest rate or
different loan amount and be able to quickly compare the results in the
lower
portion of both columns (P&I, total interest paid, total of payments,
number
of payments), on the same spreadsheet, at the same time

Apparently the "loan calculator" uses IF statements which I do not
understand and cannot figure out. (I must be too old!). When the original
cells are highlighted there is a drop down box on the top left menu bar
with
field names that correspond to the cell being entered, like, Loan_Amount,
or
Loan_Start, Interest_Rate etc. I only see cell addresses when I highlight
the
second, copied column (the second column that I cam trying to run the same
formulas, but using the modified data).

Can anyone understand my problem? Can anyone help?

Thank you
Ron C