Help with if and statement

[Rsnor]

Apologies if this was answered before.

I am having issues with my if and statements in power query. 

=If [item1] = 1 and [item2] <> null then 1 else 0

Where [item2] just needs to have any text in the cells and [item1] has only either 1 or 0. 

The query keeps on returning 0 even if all conditions are met. I feel "<> null" is where the issue is but im not sure,kinda new to this.

[wdx223_Daniel]

=If [item1] = 1 and not List.Contains({null,""},Text.Trim([item2])) then 1 else 0

[Rsnor]

Hi, thank you very much for this but its still returning 0 as a result. I think I screwed up explaining what I was trying to do. Basically I'm trying to put the fx below to my query. 

=IF(AND(D3=1,LEN(E3)>0,LEN(F3)>0,LEN(G3)>0),1,0)

 

[wdx223_Daniel · Accepted solution]

=If [item1] = 1 and Text.Combine({[item2],[item3],[item4]})<>"" then 1 else 0

[Rsnor]

That's it! thank you so much daniel.