=IF(ISNUMBER(SEARCH("February",B8)),1,"")
Ignoring the cell reference B8 which would be whatever cell you wish to be searched, this would return a number 1 if true and "" if false. The true and false values can be altered as per the IF rules.
=IF(ISNUMBER(SEARCH("February",B8)),1,"")
Ignoring the cell reference B8 which would be whatever cell you wish to be searched, this would return a number 1 if true and "" if false. The true and false values can be altered as per the IF rules.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks