SOLVED

# Multiple conditions case

Brass Contributor

# Multiple conditions case

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

# Re: Multiple conditions case

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..,....)

# Re: Multiple conditions case

Thanks @Mathets (Y)
1 best response

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

# Re: Multiple conditions case

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..,....)