Excel Magic Trick 1140

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

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply