Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create funciton values_entered in excel
i'm download template loan amortation schedule from
http://office.microsoft.com/template...lt=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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create funciton values_entered in excel
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_Star t0,1,0) Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create a mailing list in excel, not importing d. | New Users to Excel | |||
create excel based standalone application | Excel Discussion (Misc queries) | |||
how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) |