Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

ISFORMULA function: Description, Usage, Syntax, Examples and Explanation

What is ISFORMULA function in Excel?

ISFORMULA function is one of the Information functions in Microsoft Excel that checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.

Syntax of ISFORMULA function

ISFORMULA(reference)

The ISFORMULA function syntax has the following arguments.

  • Reference: Reference is a reference to the cell you want to test. Reference can be a cell reference, a formula, or a name that refers to a cell.
Also See:   Sum formulas only in Excel

ISFORMULA formula explanation

  • If reference is not a valid data type, such as a defined name that is not a reference, ISFORMULA returns the #VALUE! error value.

Example of ISFORMULA function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

Also See:   Sum formulas only in Excel

You can adjust the column widths to see all the data, if need be.

Formula Description Result
=TODAY() Returns TRUE because =TODAY() is a formula. TRUE
7 Returns FALSE because 7 is a number, not a formula. FALSE
Hello, world! Returns FALSE because “Hello, world!” is text, not a formula. FALSE
=3/0 Returns TRUE because, although dividing by 0 results in an error, the cell does contain a formula. TRUE
Also See:   Sum formulas only in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *