View Single Post
 
Old 11-19-2012, 02:16 PM
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 AND function be used as criteria in DB functions?

I read some docs that say this: AND and OR functions can be used as criteria in DB functions. It gives this example:

=AND(E4>F9,D7<A5,M3>G1,B1=“FY 2010”)

with the final argument being the result that is displayed (I presume meaning if that above is listed in the criteria, it would resulst in FY 2010 being the criteria).

But I can't seem to find anything that indicates that AND would work like that, or make anything work with it.

Any comments/thoughts?
Reply With Quote