Formula for IF is not 2 values

[filipebarros]

Hello, I need a help with a formula. I need to exclude two values , like an IF is not two values, I need to exclude the values "" and "100" . I though to use IF [STATUS NFE2] <> "" && [STATUS NFE2] = "100" , but doesn t seems to wrok, so i tried a diferrent way , to state all other values, but the problem is if it appears a new value my formula doesnt work, here is the formula:

else if [STATUS NFE2] = "101" or [STATUS NFE2] = "228" or [STATUS NFE2] = "102" or [STATUS NFE2] = "539" or [STATUS NFE2] = "151" or [STATUS NFE2] = "225" or [STATUS NFE2] = "302" or [STATUS NFE2] = "625" or [STATUS NFE2] = "328" or [STATUS NFE2] = "531" or [STATUS NFE2] = "817" or [STATUS NFE2] = "770" or [STATUS NFE2] = "232" or [STATUS NFE2] = "773" or [STATUS NFE2] = "886" or [STATUS NFE2] = "297" or [STATUS NFE2] = "533"
then "WD Check NF"

NF means Invoice.

[parry2k]

@filipebarros If I understood correctly, try following

IF ([STATUS NFE2] = "" || [STATUS NFE2] = "100", <exclude value>, <include value>)

so basically if status nef 2 = "" or nef2 = 100 then exclude else include

[filipebarros]

I forgot to mension that I am using the m language .
Is not simple as that , that are a lot of others if and statments , I would like something for this case "WD Check NF"
IF is not "" and if is not "100" then "WD Check NF"

Here is the full code.

#"Added Custom5" = Table.AddColumn(#"Replaced Value", "STATUS PEDIDO", each if [Sales Document] = "" then ""
else if [STATUS NFE1] = "Authorized" and [STATUS NFE2] = "100" then "NF Issued"

else if [STATUS NFE2] = "101" or [STATUS NFE2] = "228" or [STATUS NFE2] = "102" or [STATUS NFE2] = "539" or [STATUS NFE2] = "151" or [STATUS NFE2] = "225" or [STATUS NFE2] = "302" or [STATUS NFE2] = "625" or [STATUS NFE2] = "328" or [STATUS NFE2] = "531" or [STATUS NFE2] = "817" or [STATUS NFE2] = "770" or [STATUS NFE2] = "232" or [STATUS NFE2] = "773" or [STATUS NFE2] = "886" or [STATUS NFE2] = "297" or [STATUS NFE2] = "533"
then "WD Checar NF"

else if [#"Rejection Desc."] = "..."
else if [#"Rejection Desc."] = "T..iscal"
else if [#"Rejection Desc."] <> "" then "It..o"
......

[v-lili6-msft · Accepted solution]

hi, @filipebarros 

Try this code use "and"

Best Regards,

Lin