You can use a custom function like:
Function IsFormula(rng1 As Range) As Boolean
IsFormula = rng1.HasFormula
End Function

Also, you can see it directly on the screen using CTRL+~

Hope this helps,
Miguel.

"J.Smith" wrote:

Hi,
It seems like a trivial thing, but I seem to be unable to locate a worksheet
function that allows me to determine, if a given cell contents is a formula
or a value.

Thank you!