| 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 |
| 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 | |||
Threaded Mode
