I am using a template for a loan amortization schedule that I came across that uses named cells. The formula in the total interest cell is the following: =IF(Values_Entered,SUMIF(Beg_Bal,">0",Int),""). When I go to Insert=>Name=>Define Values_Entered refers to the following formula =IF(Loan_Amount*Interest_Rate*Loan_Years*Loan_Start>0,1,0). I was wondering if you could tell me what role "Values_Entered" plays in the first formula above. Realize this may not be enough information. Happy to provide additional data if needed. Just let me know. Thanks.