Turn the last 0 (i.e the FALSE part of the ISNUMBER function) into another IF
statement:

=IF(ISNUMBER(G7),IF(TRUNC(G7)=G7,IF(AND(G7=1,G7<= 7),1,0),0),IF(G7="A",1,0))

This will return 1 for both 'a' and 'A'.

If you want to check other for other characters change G7="A" into something
like
OR(G7="A",G7="B",G7="C")

"mndpy" wrote:

Hey guys this one works great but how do I add in the letters I am looking
for too? Like with this string I also need a 1 displayed if the letter a is
displayed?

=IF(ISNUMBER(G7),IF(TRUNC(G7)=G7,IF(AND(G7=1,G7<= 7),1,0),0),0)

Any suggestions would be great!