I can't seem to figure this out. Trying to make a column in this excel spreadsheet I am using for my class titled "Fatal?" In this column, it will take the information from the F column and input "yes" or "no"
Right now, I can't get it to work. The F column contains the word fatal but sometimes has other words in the same cell. So I thought I could do =if(f3="*FATAL*", "yes", "no") but it returns no through all cells.
Can anybody help me? I've attached the spreadsheet.
Thanks in advanced.
Bookmarks