On Tue, 11 Sep 2007 09:10:04 -0700, 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!


=--OR(G7={1,2,3,4,5,6,7,"a"})


--ron