Unknown IF function parameter on amortization schedule

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

Guest

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.
 

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

amortization schedule calc without interest rate known 1
Print Generated Array 1
=IF(Values_Entered??? 1
Can IF and VLOOKUP functions be inserted together? 4
Need Help With Lookup & Indirect Function! 5
Function to return a Commision Percent based on input from form 7
Using variables as parameters of function 2
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? 4

Back
Top