formula logic for cells containg a quotation marks

[Brian6751]

im trying to write a formula which looks in cell AV10 and labels any data less than 8 characters, and containing quotation marks as "check F1" if not "na"

it was working fine until i tried to add the quotation mark part

here is what i have and there is something wrong with it:

=IF(AND((AV10<>""),(LEN(AV10))<8),(ISNUMBER(FIND("""",AV10))"check F1","na")


appreciate the help!!

[6StringJazzer]

Your parentheses and commas are kind of mixed up. Try this:

Please Login or Register  to view this content.

I think this also will work, since any cell that passes the third test will also pass the first, so the first is unnecessary:

Please Login or Register  to view this content.

[Brian6751]

im sorry. i explained that incorrectly.

something in the cell

AND

(less than 8 characters

OR

contains a quotation mark)

[6StringJazzer]

Well then, let's try this

Please Login or Register  to view this content.

[Brian6751]

IT WORKS!!!! Thanks so much!!

[6StringJazzer]

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!