Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Logical 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(G70,G7<4,G7949,G7<991),1,0) Any help would be awesome! -- -CRM |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Logical formulas
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 Replace @mailinator.com with @tiscali.co.uk "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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Logical formulas
On Tue, 19 Feb 2008 08:56:02 -0800, saltnsnails
wrote: 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! Please don't multipost. There are answers in the other group to which you posted. --ron |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Logical formulas
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 On Tue, 19 Feb 2008 08:56:02 -0800, saltnsnails wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical | Excel Discussion (Misc queries) | |||
Logical Formulas | Excel Worksheet Functions | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
logical formulas in excel | Excel Discussion (Misc queries) | |||
Can logical formulas be used to build accounts receivable workshe. | Excel Worksheet Functions |