I am trying to combine if statements if true then if this or this or this is true (if true) =IF(SEARCH("($",MID(T5,1,O5))>0 (then if either of these are true) IF(SEARCH("CASH",MID(T5,1,O5))>0,1 IF(SEARCH("PYMT",MID(T5,1,O5))>0,1 IF(SEARCH("PAYMENT",MID(T5,1,O5))>0,1
Solved by F. W. in 19 mins