Excel Magic Trick 1140

VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels


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.
(00:51) Text in double quotes and ampersand (join symbol)
(01:43) DOLLAR function
(03:41) TEXT function
(05:40) VLOOKUP function


Be the first to comment

Leave a Reply