Forum Discussion
Data Validation with AND and OR
Try Below formula
=OR(EXACT(LEFT(I5,3),"A R"),AND(EXACT(LEFT(I5,1),"A"),LEN(RIGHT(I5,LEN(I5)-1))=9,ISNUMBER(RIGHT(I5,LEN(I5)-1)*1)))
I am using a different language version of Excel if this doesn't work please rewrite the formulas I gave on my first post seperately to be sure they run correctly and then combine them.
Thank you erol (and sorry for misspelling your name in my last post -- MS autocorrected). I replaced the one ; with , but it still was not accepted. Any other thoughts? Thanks again!
Try Below formula
=OR(EXACT(LEFT(I5,3),"A R"),AND(EXACT(LEFT(I5,1),"A"),LEN(RIGHT(I5,LEN(I5)-1))=9,ISNUMBER(RIGHT(I5,LEN(I5)-1)*1)))
I am using a different language version of Excel if this doesn't work please rewrite the formulas I gave on my first post seperately to be sure they run correctly and then combine them.
Erol ... that was perfect ... thank you so much! I was having trouble combining ANDs and ORs ... you did great!
trust me, I am an engineer.. 😄
- And obviously a VERY good one ... thank you!