 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Logical formulas
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!  Signature-CRM 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) >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: [quoted text clipped - 7 lines] > > Any help would be awesome! See your other request in .misc Please do not multipost as it just fragments responses SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >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: [quoted text clipped - 7 lines] > > Any help would be awesome! >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: [quoted text clipped - 5 lines] > >Any help would be awesome! Please don't multipost. There are answers in the other group to which you posted. --ron 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 >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: |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.