How to check if any cells and have formulas in Microsoft Excel
With the use of the inbuilt function =isformula() and referencing a cell between the parentheses we get an output that is either TRUE or FALSE. A result of TRUE indicates that the referenced cell has a formula while a result of FALSE signifies that the cell has no formula attached to it.