Unknown IF function parameter on amortization schedule
I downloaded the loan amortization schedule from MSO Online (the one with 4
1/2 stars rating on 889 votes). It is using IF functions with "Values_Entered" and "Last_Row" as logical_test values. I cannot determine from where these values are determined. They do not show in the list of named ranges, there are no hidden worksheets, there are no macros defined, etc. I do not believe these are Excel reserved words. Can anyone tell me about this implementation? Thank you in advance. |
They're named formulas. Look them up using Insert/Name/Define...
In article , "Michael from Austin" <Michael from wrote: I downloaded the loan amortization schedule from MSO Online (the one with 4 1/2 stars rating on 889 votes). It is using IF functions with "Values_Entered" and "Last_Row" as logical_test values. I cannot determine from where these values are determined. They do not show in the list of named ranges, there are no hidden worksheets, there are no macros defined, etc. I do not believe these are Excel reserved words. Can anyone tell me about this implementation? Thank you in advance. |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com