SOLVED

Multiple conditions case

Brass Contributor

Working on excel workbook where I want to see a value(Column1) in Column 12 if value in Column 3= C1 and If value in Column 2 is >=C31 and if value in Column 2 is <=D3 . Above 3 conditions which are true only then I want to see value in Column 1 otherwise I want to see "NO" in Column 1. 

 

I tried formula (IFS([@Column3]='Shift Pattern'!C1,[@Column1],[@Column2]>'Shift Pattern'!$C$3,[@Column1],[@Column2]<'Shift Pattern'!$D$3,[@Column1])

 

Above formula shows Column 1 value even if one of the above condition is true and ignore others. 

 

Can you please tell me how I can apply above mentioned condition?

 

Either I am apply formula wrong or I am apply wrong formula. What is the case?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Arslannaz 

 

Use =IF(AND(condition 1, condition 2, condition 3),result if all true, else) 

 

IFS is for a series of possible conditions with corresponding results, as in

=IFS(condition 1, result 1, condition 2, result 2, condition 3, result 3..,....)

Thanks @Mathets (Y)
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Arslannaz 

 

Use =IF(AND(condition 1, condition 2, condition 3),result if all true, else) 

 

IFS is for a series of possible conditions with corresponding results, as in

=IFS(condition 1, result 1, condition 2, result 2, condition 3, result 3..,....)

View solution in original post