Excel Tip - Formula Text

This is a simple formula on today's blog post.

You can use this formula to take a look at the formula that is in a particular cell. Much like we did in the Excel Tip - Combine Index and Match Function post.

You can use it in Cells with complex formulas to understand what is there and what you need to do in another cell to make it work elsewhere. Type "=Formulatext(Cell You Want to Look At)." It's that simple but so powerful.