If you’re working with more formulas than a Parisian perfumer, then you know how difficult it can be to keep track of them all (and make sure there are no errors). Instead of clicking on each cell to review the formula, or switching back and forth between formulas and values by hitting CTRL~, audit your formulas using the FORMULATEXT function. This function returns the cell's formula as a text string. FORMULATEXT only has one reference argument, which is the cell reference of the formula you want to return.
In the example above, I used the FORMULATEXT function to quickly compare each YTD total to its formula to make sure everything is working properly. First, I selected any empty cell next to the table, typed “=FORMULATEXT(“, and entered the YTD total as the reference agreement, followed by a closed parenthesis.
