| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database Function Criteria Boolean Operations
Hello,
Is there anyway to change the way that the Database function analyzes the Criteria range? Default is (according to http://office.microsoft.com/en-us/as...spx#Example3): Sales=A1 Sales=B1 6000=A2 <500=B2 <6500=A3 ( (Sales 6000 AND Sales < 6500 ) OR (Sales < 500) ) I'm trying to get it to look at: Sales=A1 Sales=B1 6000=A2 <500=B2 <6500=A3 ( (Sales 6000 OR Sales < 6500 ) AND (Sales < 500) ) Thank you, Aaron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Database function criteria | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
| Function to look up largest value whose record meets criteria? | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
