I am struggling with the formula shown in the picture. I need to add to the formula so that; IF the E column has the phrase "FD" anywhere in it, the formula will show the phrase "Correct" in the P column.
The E column contains a large variety of codes such as 1-FD, 2-FD, 3-FD and so on. There are too many to list in a formula easily. In access I could type in "*" or "?" if I didn't know all the values. How can I do that in an excel formula?
Aucun commentaire:
Enregistrer un commentaire