Well, there's a macro you can use called GetFormula:
http://www.mvps.org/dmcritchie/excel/formula.htm

Once installed you use it as an ordinary function: =getformula(A1) etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Don" wrote:

All,

Is there a function (eg, in the form of =ISFORMULA(_)) that will return a
code if a cell contains a formula as opposed to a blank or a text or value?