Multiple Data Validation - Add Two Together

[tlc53]

Hi there,

I have two data validations I would like to apply to cell F17.

The first one only allows number format of ### or ###/###. This code works fine;

=OR(AND(ISNUMBER(F17),LEN(F17)=3),AND(ISNUMBER(LEFT(F17,3)+0),ISNUMBER(RIGHT(F17,3)+0),ISNUMBER(SEARCH("/",F17)),LEN(F17)=7))

The second data validation I would like to apply, is only allow F17 to be populated if B17 is not blank. This code work fine;

=LEN(B17)>0

Now I would like to combine these two data validations. I've tried but I'm not having much luck. Can anyone puzzle it together for me please? Thank you

 

[Eric W]

Try:

=AND(OR(AND(ISNUMBER(F17),LEN(F17)=3),AND(ISNUMBER(LEFT(F17,3)+0),ISNUMBER(RIGHT(F17,3)+0),MID(F17,4,1)="/",LEN(F17)=7)),LEN(B17))

 

[tlc53]

Perfect! Thank you!!

 

[Eric W]

Happy to help!