You text says: **if number is greater than 1** but your formula saud greater
than zero. Assuming that you mean = 1 and <= the other numbers, try

=IF(OR(AND(G7=1,G7<=4),AND(G7=949,G7<=991)),1,0)

Note that if you just want zero or 1 then:

=--OR(AND(G7=1,G7<=4),AND(G7=949,G7<=991))

Will do that.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"saltnsnails" wrote in message
...
I must admit. I am horrible at logical functions. I am trying to compose
a
formula that will return a value of "1" if number is greater than 1, less
than 4, greater than 949, and less than 991. Here is what I have now but
it
is not working: =IF(AND(G70,G7<4,G7949,G7<991),1,0)

Any help would be awesome!
--
-CRM