Logical formulas
Try this:
=IF(OR(AND(G70,G7<4),AND(G7949,G7<991)),1,0)
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"saltnsnails" wrote in message
...
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(G70,G7<4,G7949,G7<991),1,0)
Any help would be awesome!
--
-CRM
|