Formula for multiple conditions

[rizwanulhasan]

Hi,


In the attached image below, i am trying to enter a formula to make a person Not Available for the below criteria.

The person A should not be available if:


1. The DND status (Sheet2) of person A is Do Not Disturb.

2. The status of person A is pending (Sheet 1).

3. Person A has 2 or more status as Completed.


Can someone guide me with the formula.


Thanks in advance.

 

[etaf]

answered on other forum,

Formula for multiple conditions [SOLVED]

Hi, In the attached excel file, i am trying to enter a formula to make a person Not Available for the below criteria. The person A should not be available if:

www.excelforum.com

Where is the formula going, I added to Sheet2 B2
=IF(OR(C2="Do Not Disturb", COUNTIFS(Sheet1!$A$2:$A$6,Sheet2!$A2,Sheet1!$B$2:$B$6,"pending")>0,COUNTIFS(Sheet1!$A$2:$A$6,Sheet2!$A2,Sheet1!$B$2:$B$6,"completed")>1),"not Available","Available")

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formula for multiple conditions
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.