Multiple condition

  • Thread starter Thread starter ak
  • Start date Start date
A

ak

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested IF without repeating the condition to be tested 6
Row Deletion based on condition. 4
Negative Conditional Formatting Excel 2003 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
More condition 1
Conditional formatting 5
Conditional format for unique values 5
Macro for multiple conditional formatting 2

Back
Top