The FORMULATEXT is fully automatic. When given the reference of a cell that contains a formula, it will return the entire formula as text. In the example as shown, the formula:
returns the text "=IF(B5>=70,"Pass","Fail")".
Dealing with errors
The FORMULATEXT function will return the #N/A error when a cell does not contain a formula. To trap this error and display nothing when a cell does not contain a formula, you can use the IFERROR function like this:
Alternately, you can use ISFORMULA and IF like this:
Checking for specific text
To check a formula for a specific text, you can use the ISNUMBER and SEARCH functions. In the formula below, we are checking a formula in A1 to see if it contains "apple":
The result is either TRUE or FALSE. See this page for a full explanation.