Data validation on specific text to identify website addresses .com OR .co.uk

HI I am trying to put data validation on cells in excel so it checks whether they have ".com" OR ".co.uk" i.e. they are validish web addresses. I can get it to work for one by doing this in the custom validation field

=ISNUMBER(FIND(".com",H3))

but I have tried variations of using OR but I can't get it to work, An example of what I have tried is this - I am not great at custom data validation so any help appreciated!

=OR(ISNUMBER(FIND(".COM",H3),(FIND".CO.UK",H3))

Thanks

Jen

Try it like this:

=OR(ISNUMBER(FIND(".com",LOWER(H3))),ISNUMBER(FIND(".co.uk",LOWER(H3))))

Hope this helps.

Pete

Brilliant this seems to have done the trick! what does the LOWER do? just out of interest!
Thanks

Jen

It ensures that H3 is in lower case, as I put .com and .co.uk in lower case - you could use SEARCH instead of FIND, and that is case-sensitive.

Thanks for the rep, and for marking the thread as Solved.

Pete