Excel Magic Trick 355: VLOOKUP for Mortgage Calculator
Rate:
10 ratings
Views:
330
From : ExcelIsFun
Added: Aug 7, 2009
See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan.
Category : Tech
Added: Aug 7, 2009
See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan.
Category : Tech
Related Videos
See how to use the OFFSET function to retrieve only a desired cell's content, and how to deliver a range to a Function. Learn about the OFFSETS 5 arguments: 1. Starting point ...
See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references!
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can ...
For big data sets, extracting only certain records based on complex criteria can be done easily with Advanced Filter! See how to Extract data from an Excel Table/Database ...
Excel! See how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values. See how to do this lightening fast ...
See methods for summing with criteria: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount,...
Amazing Custom Number Formatting Tricks! See a complete list of all the code and examples that will give you power over Custom Number Formatting. See 8 amazing examples of ...
Excel! Learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive! Also, learn the ...
See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the ...
See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the ...
Also Try: