Power Query If Col A and Col B = Null

[themissingelf]

Hi,

I think what I am trying to do is simple but the solution is evading me right now...

I simply want to a Power Query statement to do the following in a new column but can't work out what the formula should be:

IF COL A = NULL AND COL B = NULL THEN "OK" ELSE "NOT OK"

Grateful for help!

Thanks

 

[olivierhbh]

Hi,

Can you try: if [COL A] = null and [COL B] = null then "OK" else "NOT OK"

Olivier.

 

[themissingelf]

Hi,
Thanks for posting. I did try that and wasn't getting the result I was after...

 

[jak82]

=IF([COL A]=NULL,if([COL B ]= NULL ,"OK","NOT OK"),"NOT OK") Probably not the most elegant one but should help

 

[themissingelf]

Hi,
Thank you - I've not tried this before; however, when I do I'm getting an error: "Token RightParen Expected". When I click "Show Error" it highlights the comma shown in red below
=IF([COL A]=NULL,if([COL B ]= NULL ,"OK","NOT OK"),"NOT OK")

 

[kkardynalski]

What Olivier said, except enclose the if condition in parentheses: if ([COL A] = null and [COL B] = null) then "OK" else "NOT OK"