Wednesday 3 May 2017

Excel - The Excel ISFORMULA Function

Description

The Excel Isformula function tests if a specified cell contains a formula, and if so, returns TRUE; Otherwise, the function returns FALSE.
Note: the Isformula function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the function is:
ISFORMULA( reference )
Where the supplied reference argument is a reference to a cell.

Isformula Function Examples

Column B of the following spreadsheet shows four examples of the Excel Isformula function.

No comments:

Post a Comment