I need help with this formula. I’m sure there’s a more efficient way to write the formula. Source cell where my formula resides is F4. Trying to insert ‘PM’ into F4 if cells S4, V4, Y4 and/or AB4 have numerical values of 24.2 or 12.2 or insert ‘SCAN’ into F4 if cells S4, V4, Y4 and/or AB4 have numerical values of 4 or 6. The formula below works with 12.2, 4 and 6 but when I enter 24.2 it populates F4 with ‘SCANPM’. Please help!
=IF(OR(ISNUMBER(SEARCH("24.2",S4)),ISNUMBER(SEARCH("24.2",V4)),ISNUMBER(SEARCH("24.2",Y4)),ISNUMBER(SEARCH("24.2",AB4)),ISNUMBER(SEARCH("12.2",S4)),ISNUMBER(SEARCH("12.2",V4)),ISNUMBER(SEARCH("12.2",Y4)),ISNUMBER(SEARCH("12.2",AB4))),"PM"," ") &IF(OR(ISNUMBER(SEARCH("4",S4)),ISNUMBER(SEARCH("4",V4)),ISNUMBER(SEARCH("4",Y4)),ISNUMBER(SEARCH("4",AB4)),ISNUMBER(SEARCH("6",S4)),ISNUMBER(SEARCH("6",V4)),ISNUMBER(SEARCH("6",Y4)),ISNUMBER(SEARCH("6",AB4))),"SCAN"," ")
=IF(OR(ISNUMBER(SEARCH("24.2",S4)),ISNUMBER(SEARCH("24.2",V4)),ISNUMBER(SEARCH("24.2",Y4)),ISNUMBER(SEARCH("24.2",AB4)),ISNUMBER(SEARCH("12.2",S4)),ISNUMBER(SEARCH("12.2",V4)),ISNUMBER(SEARCH("12.2",Y4)),ISNUMBER(SEARCH("12.2",AB4))),"PM"," ") &IF(OR(ISNUMBER(SEARCH("4",S4)),ISNUMBER(SEARCH("4",V4)),ISNUMBER(SEARCH("4",Y4)),ISNUMBER(SEARCH("4",AB4)),ISNUMBER(SEARCH("6",S4)),ISNUMBER(SEARCH("6",V4)),ISNUMBER(SEARCH("6",Y4)),ISNUMBER(SEARCH("6",AB4))),"SCAN"," ")