loan calculator cells, P&I formulas do not copy to second cloumn

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

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 insert>name>define 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. [email protected]> wrote in message
news:[email protected]...
> 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
>

Thank you but this was not helpful. I want to have both sets "live" so that
changes can be made and obserrved, also, the insert>name>define 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 insert>name>define 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. [email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>

You can use it with 2 sets live unless it is protected which might be the
reason you can't see the names
under define. If you look where you get the results (select one cell with a
result), can you see the formula?
If so just copy the formula let's say 2 columns to the right, now instead of
the defined names replace them with the cells
where you want to put the second variables, that should do it. Or roll your
own, look at the PMT function in help

--

Regards,

Peo Sjoblom


"Mr. C" <[email protected]> wrote in message
news:[email protected]...
> Thank you but this was not helpful. I want to have both sets "live" so
that
> changes can be made and obserrved, also, the insert>name>define 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 insert>name>define 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. [email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> >
> >
> >

Peo,
Thank you again.
No, I cannot see any formulas for the calculation, only like "=E9", "=E10"
etc.
the formulas in the original cells are
=IF(Values_Entered,Monthly_Payment,"")
=IF(Values_Entered,Loan_Years*12,"")
=IF(Values_Entered,Total_Cost-Loan_Amount,"")
=IF(Values_Entered,Monthly_Payment*Number_of_Payments,"")

SOme of hte name box items are:
=Number_of_Payments
=Total_Interest
=Total_Cost

I think what I do not get is what the "IF" statements are and how they work.
If I double click on any of the second result cells I get blue lines around
the original cells

Any other info or direction to help me solve this is appreciated,
Ron

"Peo Sjoblom" wrote:

> You can use it with 2 sets live unless it is protected which might be the
> reason you can't see the names
> under define. If you look where you get the results (select one cell with a
> result), can you see the formula?
> If so just copy the formula let's say 2 columns to the right, now instead of
> the defined names replace them with the cells
> where you want to put the second variables, that should do it. Or roll your
> own, look at the PMT function in help
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Mr. C" <[email protected]> wrote in message
> news:[email protected]...
> > Thank you but this was not helpful. I want to have both sets "live" so
> that
> > changes can be made and obserrved, also, the insert>name>define 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 insert>name>define 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. [email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> > >
> > >
> > >
>
>
>