Contains in IF formula

Question

Currently, I have a formula that says IIF(Contains([Data],"Secured"),"Yes","No"). However, this also picks up the word "Unsecured", but I only need it to pick up the word Secured. Is there a different way to structure this formula so that the word "Unsecured" does not become a "Yes"?

DataNath · Accepted Answer

Because secured is within unsecured, this satisfies your statement that [Data] field contains secured. If you just want it to outright check for secured without any extra possibilities then just use IIF([Data]="Secured","Yes","No").

Christine_Assaad · Accepted Answer

Hi @bogdansheremeta

Do you have to use contains? I'm asking because you can say [Data] = "Secured". TY!