True False Column

[gheyman]

I have a column [Is Even] that has TRUE or FALSE values in it. I am trying to create a new column with an If statement in it. If [Is Even] = TRUE then "1" else "2"

But I cannot seem to get this to work.

I tried replacing TRUE with 1....... nothing seems to work

Help Please.

 

[GraH]

If [IsEven] then 1 else 2. Schould be enough. That is when that column is defined and logical. Else it's maybe seen as text.

 

[Sufiyan97]

Have you tried:

=--ISEVEN(A1)

 

[GraH]

Have you tried:

=--ISEVEN(A1)

It's about power query and not about excel formula.

 

[Sufiyan97]

It's about power query and not about excel formula.

Sorry, did'nt aware of that.

 

[gheyman]

Thank you both