how do i create funciton values_entered in excel

T

Tamaboy

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
 
K

Ken Johnson

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

=IF(Values_Entered??? 1
How do I create a set of words that are flagged? 0
how do I make "NOW" function static 2
How do I change the loan period in a amortization from years to mo 7
how do i format a cell to use text and formulas 3
How do I create a custom Function Key Template 1
how do i copy down x number of times 1
How do I creat a math formula that remains in Excel. 0

Top