I gave you the formula for S4. It looks like you put it in S5??

Capture.JPG

Fixing your S5 formula and filling it into S4 ...

Capture1.JPG

Seems to return the No in S4 and the Yes in S5 that I thought you were expecting

Capture2.JPG

Am I failing to understand?