If am attempting to create multiple if statements. I need excel to search for a specific word in one cell and change the criteria in other cell for greater than. If I do the beginning of the formula I have no problem. However when I change the search to another word it no longer works.
=IF(COUNT(SEARCH("11M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I21),"Pass","Fail"))=IF(COUNT(SEARCH("5M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I19),"Pass","Fail"))
This formula above I get ends with a False statement which is not working. However if I use the Formula below it will work. I need to expand upon this formula to work like I have above. I have a total of 9 different words that I need it to search.
=IF(COUNT(SEARCH("11M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I21),"Pass","Fail"))
Any help would be much appreciative. Thanks
=IF(COUNT(SEARCH("11M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I21),"Pass","Fail"))=IF(COUNT(SEARCH("5M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I19),"Pass","Fail"))
This formula above I get ends with a False statement which is not working. However if I use the Formula below it will work. I need to expand upon this formula to work like I have above. I have a total of 9 different words that I need it to search.
=IF(COUNT(SEARCH("11M",Sheet1!I2)),IF(AND(Sheet1!S2>Sheet3!I21),"Pass","Fail"))
Any help would be much appreciative. Thanks