Help with basic IF problem

[tomshaw83]

Hi, I am trying to write a simple IF statement in Power Query, I want to return a value every time an odd value appears in a rank column. I am writing 

if [rank] = Number.IsOdd then [ExampleColumn] else [ExampleColumn2]

The Number.IsOdd section is picking up, can anyone help point me in the right direction?

Thanks

Tom

[BA_Pete · Accepted solution]

Hi @tomshaw83 ,

You need to use the Number.IsOdd function correctly:

if Number.IsOdd([rank]) then ... else ...

Pete

[tomshaw83]

Thank you