lundi 24 août 2020

If And - and Statement

I have the below formula which works absolutely fine but I would like this formula to also check if column "Q2" contains the word "LOCKWOODS" how would I add this into my pre existing formula please?

If Q2 does not contain the word Lockwoods along with the criteria of the formula below the formula needs to return the word "OK"

=IF(A2=0,"",IF(AND(A2="Released",N2="No"),"ERROR","OK"))

Any help is very much appreciated!

Many Thanks,

Kind Regards,

Aucun commentaire:

Enregistrer un commentaire