Create a UDF and use that in the IF test

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)


"chopsx7" wrote in message
...
can you use an IF function (or any function) to return a value if a
certain
cell contains a formula as opposed to an inputted value. I would like to
be
able to see this indicator on a printout out of the spreadsheet. Thanks