A arifanmol Member Jan 28, 2023 #1 IF I WANT TO COMBINE IF AND SEARCH AND EXPECT EXPECTED OUTPUT WHAT FORMULA SHOULD BE USE ? SEE ATTACHMENT PLZ Attachments FORMULA IF.xlsx FORMULA IF.xlsx 7.4 KB · Views: 8
IF I WANT TO COMBINE IF AND SEARCH AND EXPECT EXPECTED OUTPUT WHAT FORMULA SHOULD BE USE ? SEE ATTACHMENT PLZ
p45cal Well-Known Member Jan 28, 2023 #2 =IF(ISNUMBER(MATCH("F",A1:A25,0)),"RIGHT","WRONG") You don't need to shout Last edited: Jan 28, 2023
