try this
=IF(SUMPRODUCT(NOT(ISERROR(SEARCH("p",e200:e250,1)))*1)>0,5,6)
substitute what you want for a positive (found) result for the 5, and for a negative (not found) result for the 6
try this
=IF(SUMPRODUCT(NOT(ISERROR(SEARCH("p",e200:e250,1)))*1)>0,5,6)
substitute what you want for a positive (found) result for the 5, and for a negative (not found) result for the 6
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks