I need a formaula that says:
If Cell B1 contains SA or A or D or SD then cell C2 reads 4 for SA or 3 for
A or 2 for D or 1 for SD. I hope that makes sense. I know how to do it for
yes and no but not when the cell could have four different entries.
Thank you