Help adding more criteria to my IF function

[Excelstudent01]

Hi,
Would it be possible to add another statement to the formula in G2 that would return a blank cell if Code (cell A2) does not equal 56 (if A2 <> 56 then " ") in addition to the criteria I already have in G2?
Thank you for your help!!

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?
=IF(A2<>56,"",

)

 

[Excelstudent01]

Welcome to the MrExcel board!

Is this what you mean?
=IF(A2<>56,"",View attachment 108482)

Thank you for your response. Yes, that looks like what I want but I am unable to get the formula to work, I'm missing something. IF(A2<>56,"",(AND(B2<>B1,E3<>E2),1,IF(AND(B2<>B1,E3=E2),0,IF(OR(E2<>E3,B3<>B2),1,0))))

Welcome to the MrExcel board!

Is this what you mean?
=IF(A2<>56,"",View attachment 108482)

 

[Excelstudent01]

Thank you for your response. Yes, that looks like what I want but I am unable to get the formula to work, I'm missing something. IF(A2<>56,"",(AND(B2<>B1,E3<>E2),1,IF(AND(B2<>B1,E3=E2),0,IF(OR(E2<>E3,B3<>B2),1,0))))

I was able to write the formula so Excel would accept it but I am not getting the results I want. I am getting 0's for all rows. Essentially what I am trying to do it roll up stays that are less than 7 days apart into 1 stay, by each ID. I only want to do this for Code type =56. I was attempting to have column G return a 1 for each duration that was 7 days after the previous duration, for each ID (but only for Code=56). It is hard to explain but if you are able to understand what I am trying to do and have an easier way of doing it, please let me know!
Thanks!

 

[Peter_SSs]

Very difficult to test without sample data and we cannot copy from an image so could wee have the sample data (and the expected results filled in manually) with XL2BB and explain again in relation to that sample data exactly what you are trying to achieve?