| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Can someone give me a hand with this formula please?
IF the value in X is greater than a, AND less than b, OR greater
than c AND less than d, OR greater than e AND less than f, then FALSE, otherwise TRUE. Howie, From the above lines in your original post, really thought you wanted the "FALSE" indicated as the Value_IF_True, and "TRUE" as the value otherwise. That's why I swapped it around. I'm confused. Could you re-clarify your original intent? -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing an existing formula | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
| This formula is also summing the the value above to give 2 totals. | Excel Worksheet Functions | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| formula from multiple worksheets to give a color output to one wo. | Excel Worksheet Functions | |||
Threaded Mode
