I downloaded the loan amortization schedule from the help function in Excel.
The template uses a condition in its IF formulas that requires a number of
cells be populated in order for the formula to run through its calculation.
An example is =IF(Values_Entered,A316+1,"") where cells d5-d7 and d9 had to
be populated or the cell is left blank. Was wondering how that is set up
where the IF formula looks to those cells to verify that there is data.
Also, "Values_Entered" does not appear in the drop box for the range names.
Thanks in advance for your assistance.