You can't do it directly with a worksheet formula, but a
simple UDF would work. Something like:
Function IsFormula(Cell As Range) As String
If Cell.HasFormula = True Then
IsFormula = "Formula"
Else
IsFormula = ""
End If
End Function
---
To use, press ALT+F11, go to Insert Module, and paste
in the code. Press ALT+Q. Call the UDF in a cell as:
=isformula(A1)
Of course the formula will display "Formula" in cases
like "=100".
HTH
Jason
Atlanta, GA
-----Original 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
.
|