Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. =IF(AND(ISNUMBER(VALUE(LEFT(A1,1))),MID(A1,2,1)=".",ISNUMBER(VALUE(MID(A1,3,1))),ISTEXT(MID(A1,4,1)),ISNUMBER(VALUE(RIGHT(A1,2))),LEN(A1)=6),1,0)
  2.  
  3. =IF(
  4. AND( --- ALL conditions below must be TRUE
  5. ISNUMBER(VALUE(LEFT(A1,1))) --- char #1 must be a number
  6. ,MID(A1,2,1)="." --- char #2 must be .
  7. ,ISNUMBER(VALUE(MID(A1,3,1))) --- char #3 must be a number
  8. ,ISTEXT(MID(A1,4,1)) --- char #4 must be text
  9. ,ISNUMBER(VALUE(RIGHT(A1,2))) --- char #5&6 must be numbers
  10. ,LEN(A1)=6 --- the string must be 6 characters long
  11. )
  12. ,1,0) --- if true output 1, else 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement