how do i create funciton values_entered in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm download template loan amortation schedule from
http://office.microsoft.com/templat...10197771033&Application=XL&Result=2&Version=8

on that template at row A:18 there is function =IF(Values_Entered;1;""); my
question is how to create values_entered function, with macro or vb, i'm
trying to find how to create that function from all my friend and searching
on internet but i can't found it.
Did anyone know how to create that function, please tell me...

thanx
Tamaboy
 
Do you mean the formula in the refers to box of the define name dialog,
which is...

=IF(Loan_Amount*Interest_Rate*Loan_Years*Loan_Start>0,1,0)

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loan Amortization Schedule Template from Business Financial Plng. 5
=IF(Values_Entered??? 1
How do I change the loan period in a amortization from years to mo 7
change loan periods in an amortization schedule 2
How do I calculate loan balances when payments are missed? 2
how do I make "NOW" function static 2
Microsoft's Loan Amortization template 5
how do i copy down x number of times 1

Back
Top