What are you trying to achieve with this part:
Formula:
IF(ISERROR(SUBSTITUTE(F16," ","")*SEARCH("@JT",G67))
Do you want to return "@SUBCON" if G67 contains "@JT" and F16 is a number? As that is how it is currently evaluating...
What are you trying to achieve with this part:
Formula:
IF(ISERROR(SUBSTITUTE(F16," ","")*SEARCH("@JT",G67))
Do you want to return "@SUBCON" if G67 contains "@JT" and F16 is a number? As that is how it is currently evaluating...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks