About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 355: VLOOKUP for Mortgage Calculator
by
ExcelIsFun
on
Youtube
Duration:
0.12 hours
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.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 367: Any Number Not Zero = TRUE
by
ExcelIsFun
on
Youtube
Duration:
0.03 hours
See that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE. See this trick in an IF, SUMIF and SUM formula for Conditional summing. Adding with ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 368: Count Unique Items With More Than One Criteria
by
ExcelIsFun
on
Youtube
Duration:
0.23 hours
Amazing use of the FREQUENCY and MATCH functions! Array formula for counting unique items in a column with criteria in a second column. See 1 formula for ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 363: Return Cell Address of First Non-Blank
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
Array Formula for returning cell address for first non-blank cell that uses the functions: ADDRESS, MIN, IF, COLUMN, ROW and the not comparative operator and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
Amazing non-array formula to returns the cell content from the first non-blank cell in a row that uses INDEX, MATCH and the not comparative operator and the ...
