Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels HD

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per year and your Test Text will change automatically. Great Trick for making tests in Excel. 1) (00:51 min mark) Text in double quotes and ampersand (join symbol) 2) (01:43 min mark) DOLLAR function 3) (03:41 min mark) TEXT function 4) (05:40 min mark) VLOOKUP function