IF AND Statement Question

[Shan_Drex12]

Hi All, 

I'm having trouble with this IF AND statement that I had on excel transfering it to power query Check below:

=IF(AND(AG5="",J5="FLOAD",F5="OCPD"),M5)

Check out Date (AG5) = "blank cell"

Stock Status (J5) = "FLOAD"

Regular Status (F5) = "OCPD" 

SPEND (M5) = "140"

I tried using this formula below but I keep getting FALSE in the Power Query column:

IF [Trailer Check Out]="" AND [Trailer Stock Status]="FLOAD" AND [Trailer Status]="OCPD" THEN [Detention Spend] ELSE "FALSE"
ENDIF

Your help would be greatly appreciated!! 🙂 

[Shan_Drex12]

Thank you! 

[Greg_Deckler · Accepted solution]

That doesn't look like M code with the endif, the syntax should be:

if [Trailer Check Out] = null and [Trailer Stock Status]="FLOAD" and [Trailer Status]="OCPD" then [Detention Spend] else "FALSE"