Thread: [Solved] AND function be used as criteria in DB functions?
View Single Post
 
Old 11-20-2012, 11:46 AM
56_kruiser 56_kruiser is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2012
Posts: 26
56_kruiser is on a distinguished road
Default
Quote:
Originally Posted by Colin Legg View Post
No, the criteria in your formula is applied to each row in the database. So you can use it to apply criteria across a row in the database which would be difficult or impossible to do by laying out the criteria how I mentioned earlier.

I've attached an example. In it I want to get a sum but only where the name begins with a capital "C". The criteria I'm using is:

=EXACT(LEFT(B3,1),"C")

So the LEFT() function gets the first letter and EXACT() returns TRUE or FALSE depending on if the first letter is a capital "C".

Does that make sense?

Hi, yes, that all makes sense, and I follow.

I think where the confusion is, is that I was interpreting the statement of returning True or False literally, ie, useing the value True as THE criteria. Not the answer to the criteria.

I'm in synch.

I appreciate your input.
Reply With Quote