ISFORMULA(reference)

Returns the value True or False depending if the cell contains a formula.

referenceA cell or range reference.

Remarks

* Added in Excel 2013.
* If "reference" is not valid, then #VALUE is returned.
* You can quickly switch between displaying the values and the formulas using the shortcut key (Ctrl + ').
* You can use the FORMULATEXT function to return the formula from a particular cell.
* You can use the ISREF function to return True or False depending if the value is a cell reference.
* You can use the ISFORMULA - User Defined Function function if you are using Excel 2010 or earlier.
* For the Microsoft documentation refer to support.office.com

 AB
1=ISFORMULA(B1) = -1=NA() = #N/A
2=ISFORMULA(B2) = -1=100 = 100
3=ISFORMULA(B3) = 0some text

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top