J John Pierce Jul 7, 2006 #1 Can anyone tell me how the "Values_Entered" IF statement in Microsoft's Loan Amortization Template works? Thanks,' John Pierce
Can anyone tell me how the "Values_Entered" IF statement in Microsoft's Loan Amortization Template works? Thanks,' John Pierce
B Bearacade Jul 7, 2006 #2 This was covered before.. http://www.excelforum.com/showthread.php?t=553822 Look in Insert > Name > Define =IF(Loan_Amount*Interest_Rate*Loan_Years*Loan_Start>0,1,0
This was covered before.. http://www.excelforum.com/showthread.php?t=553822 Look in Insert > Name > Define =IF(Loan_Amount*Interest_Rate*Loan_Years*Loan_Start>0,1,0