Excel is a very powerful product from Microsoft that helps people around the world make budgets, create forecasts and evalaute financial information of all kinds. It's also a great text processor. It turns out that Excel has a few undocumented formulas that have been deprecated, but that still work in Excel 2010 for backwards compatibility. One of them is not a function at all, but rather a macro that can be evalauted from named ranges only (aka 'names') in Excel. This macro is called EVALUATE(). You must enable macros to use it. Click below to see a full description of how this can be used to dynamically create formulas.