ISFORMULA

Checks whether a formula is in the referenced cell. Learn more

Video field
Info

In Google Sheets, ISFORMULA is a function that checks whether a cell contains a formula.

The function takes one argument, which is the cell reference or a range of cells. If the cell(s) contain a formula, the function returns TRUE. If the cell(s) do not contain a formula, the function returns FALSE.

Here is the syntax of the ISFORMULA function: ISFORMULA(cell_reference)

For example, if you want to check whether cell A1 contains a formula, you can use the following formula: =ISFORMULA(A1)

If cell A1 contains a formula, the function will return TRUE. If cell A1 contains a value or text, the function will return FALSE.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!

Client Portal | Internal Tools | Web App Builder | Free Website Builder Made with Softr