You don't need all the IFs. You don't state what you want if G7 is not any
of 1 - 7, but try

=IF(TRUNC(G7)=G7,IF(AND(G7=1,G7<=7),1,FALSE),FALS E)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"mndpy" wrote in message
...
I need a formula that will look at one cell G7 and if it is a 1, 2,3, 4, 5,
6, 7, or a then I need it to display a 1.

The formula I am using is this:

=IF(G7="1","1",IF(G7="2","1",IF(G7="3","1",IF(G7=" 4","1",IF(G7="5","1",IF(G7="6","1",IF(G7="A","1"," 0")))))))

All the cells are formatted as general text. The formula is working when
it
sees "a" but not any of the numbers? Any ideas on how I can make the whole
thing work?