Logical formulas

[saltnsnails]

I think I got this in the wrong Discussion group. I put it General
Discussion before but I think it belongs here. Original Message below:

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(G7>0,G7<4,G7>949,G7<991),1,0)

Any help would be awesome!

 

[Ron Coderre]

Try this:

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

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Sandy Mann]

See your other request in .misc

Please do not multipost as it just fragments responses

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Ron Rosenfeld]

I think I got this in the wrong Discussion group. I put it General
Discussion before but I think it belongs here. Original Message below:

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(G7>0,G7<4,G7>949,G7<991),1,0)

Any help would be awesome!

Please don't multipost. There are answers in the other group to which you
posted.
--ron

 

[Gord Dibben]

Most of the regulars monotor all Excel news groups so there is not really a
"wrong" news group.

If you need answers to a complex VBA problem the programming group could be
considered the "right" group, otherwise see above.


Gord Dibben MS Excel MVP