Hi,
I am looking to use Data Validation checking for parts of one or two parts of text.

In my data validation I Have:
=RIGHT(A1,13)="thistext.text"

which works, but I need to check for 2 different values so I tried:
OR(=RIGHT(A1,13)="thistext.text", =RIGHT(A1,14)="othertext.text")

However this won't work, it keeps giving the error.

Is there anyway in which I can check the text in A1 contains either thistext.text or othertext.text?