If function: search for text in formula

[nflami]

Hello all,

I am trying to create a function that will search for text within the formula of a cell, currently I have only be able to search the values in cells.

=IF(ISNUMBER(MATCH("*"&"-"&"*",D3:AM3,0)),"Found","NotFound")

Above is the formula I'm using, but I need something similar where it can look at the formula. I'm trying to look to see if the formulas in a range contain a "minus sign (-)". Any ideas?

Thanks!

 

[Scott Huish]

I think you will need VBA for that, here's a UDF:

Function FormulaMinus(r As Range) As String
Dim c As Range
Set c = r.Find("-", , xlFormulas)
FormulaMinus = IIf(c Is Nothing, "Not Found", "Found")
End Function