Is there a function that will tell if a specific cell has a plain (manually entered) value or has a formula?
With this little snippet you can do that.
In this answer, Tom Horwood found a way to circumvent the usage of quotes.
Add the script under Tools>Script editor and press the bug button to activate the authentication.
I've created an example file for you: Check for Formula
Use ISFORMULA() built-in function.
Background and Explanation
I think I just discovered an undocumented formula in the new Google Sheets. @Pnuts was saying the
So, if the formula is available throughout the new Google Sheets, then this would be the best answer:
Only available in the new Google Sheets. I've asked a few other people to confirm the new formula and it's confirmed. As it's undocumented, its implementation is unsure and it might disappear. The
I've created an example file for you: isFormula
It looks like there is a hidden built-in function
@Jacob has provided an (the?) answer and this has been accepted but some 'comments' that might not fit as such:
With reference to =TYPE The function cannot determine whether or not a cell or range of cells is using a formula implies to me there is no such 'built-in' function - or hopefully it would have been mentioned there.
=CELL does not suit.
Find and replace however might sometimes be adequate, with