How can I make an IF statement based on number of characters in a cell?

[tonguencheek]

Hey everyone. I would like to make an IF statement that says If cell A1 has 7 characters do ABC, otherwise do XYZ

Any help would be great!

 

[VoG]

Try like this


=IF(LEN(A1)=7,"ABC","DEF")

 

[tonguencheek]

Thanks a ton!