 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Multiple condition
Can I do multiple condition in Excel? How? Please tell me an example. Also please let me know can I do that in IIF condition? Would appreciate your response. Hi AK: The way that you test for multiple conditions is to use 'or' or 'and' . So I could test cells a1 and a2: =if(and(a1=1,a2=2),true part,false part) An 'and' is used to test two conditions are true. An 'or' is used to test if either of the conditions is true. You can have more than two conditions in the tests. The iif is not part of the worksheet functions.  SignatureHope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. > Can I do multiple condition in Excel? How? Please tell me an example. Also > please let me know can I do that in IIF condition? Would appreciate your > response. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.