View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ampozdol ampozdol is offline
external usenet poster
 
Posts: 7
Default 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