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!
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!