Multiple conditions case

[ExcelGeek90]

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 · Accepted solution]

@ExcelGeek90 

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

[#3]

Thanks @Mathets (Y)