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?
Welcome to the forum.
You're nearly there - try this:
Formula:
Please Login or Register to view this content.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
syntax should looks like
=OR(RIGHT(A1,13)="thistext.text", RIGHT(A1,14)="othertext.text")
That is perfect. I don't know why I was putting in the =RIGHT inside the OR, without = it works.
Thank you.
As a formula it seems to work just fine?! It displays true/false to me. Maybe I didn't quite got what you wanted?
You're welcome and thanks for the feedback.
If that solves your question, please mark the thread as 'Solved' (instructions in my sig) to let others know that the answer's been found. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks