If cell contains more than 5 characters and less then 15 characters, return 1, if false return 0

[Tupelo1984]

Hi all,

Looking for a formula for : If cell contains more than 5 characters and less then 15 characters, if true = return 1, if false = return 0

Thank you!

 

[RoryA]

=IF(AND(LEN(A1)>5,LEN(A1)<15),1,0)

should do that.

 

[Tupelo1984]

=IF(AND(LEN(A1)>5,LEN(A1)<15),1,0)

should do that.

Thank You!