Parameter List
Syntax
ISFORMULA(reference)
reference
A reference to the cell you want to test. For example: A1, B5, or a named range. Must be a single cell reference, not a range.
More details
ISFORMULA checks if a cell contains a formula by examining the cell's content type. It returns TRUE only for cells that contain formulas (starting with = sign), regardless of whether the formula evaluates successfully or returns an error. It returns FALSE for cells containing static values, text, numbers, dates, or blank cells.