Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-19-2012, 02:16 PM
56_kruiser 56_kruiser is offline AND function be used as criteria in DB functions? Windows 7 64bit AND function be used as criteria in DB functions? Office 2010 64bit
Novice
AND function be used as criteria in DB functions?
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Acos, Cos and Sin functions in DAX PowerPivot eramzan Excel 0 03-01-2012 11:32 AM
Using IF and Vlookup functions cpladson Excel 3 12-14-2011 11:57 PM
AND function be used as criteria in DB functions? Assign functions to F1, etc. ibclare Office 4 06-02-2011 03:22 PM
AND function be used as criteria in DB functions? ** Using Functions djreyrey Excel Programming 10 02-08-2011 04:18 PM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft