Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
how to copy formulas to other cells in excell | Setting up and Configuration of Excel | |||
how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel |