Hi, I am using 2 very similar formulas - the first one has worked however the
second one returns the result "name" error. I am trying to say if cell
AG19=either LH,AC,EA,AR,BZ,AZ the answer is yes otherwise no, but I cant get
this to work, this is my formula,,, can you help me?



=IF(OR(AG19=ac,AG19=AR,AG19=EA,AG19=BZ,AG19=AZ,AG1 9=LH),"YES","NO")

Many thanks
Paula