If Then Else with OR Eof expected

[detriez]

I'm using this to create a column.

It fails with Token Eof expected at "tru

=If[Country]="Australia" or[Country]="Austria" or[Country]="Belgium" or[Country]= "Brazil" or[Country]="Canada" or[Country] = "Denmark" or[Country]="Finland" or[Country]="France" or[Country]="Germany" or[Country]="Indonesia" or[Country]="Ireland" or[Country]="Israel" or[Country]="Japan" or[Country]="Kuwait" or[Country]="Luxembourg" or[Country]="Malaysia" or[Country]="Mexico" or[Country]="Netherlands" or[Country]="New Zealand" or[Country]="Norway" or[Country]="Philippines" or[Country]="Poland" or[Country]="Russian Federation" or[Country]="Saudi Arabia" or[Country]="Scotland" or[Country]="Singapore" or[Country]="Sweden" or[Country]="Switzerland" or[Country]="Taiwan" or[Country]="United Arab Emirates" or[Country]="United States" then "true" else "false"

 

[hernantorres23]

I'm so sorry but I'm trying t understand your message. Besides, is not many details, but I would prefer put all these countries inside a group (i.e. "selected"), and then

 IF([country]="selected", "True", "False")

In another way, if you are trying to use an OR nested within an IF, your syntax must be

 IF(OR([country]="Australia", [Country]="Austria", ....), "True", "False")

Book1
	A	B	C	D
4
5
6	country	groupCountries	Column1
7	Argentina		False
8	Australia	selected	True
9	Austria	selected	True
10	Belgium	selected	True
11	Brazil	selected	True
12	Canada	selected	True
13	China		False
14	Congo		False
15	Denmark	selected	True
16	Finland	selected	True
17	France	selected	True
18	Germany	selected	True
19	Indonesia	selected	True
20	Ireland	selected	True
21	Israel	selected	True
22	Japan	selected	True
23	Kuwait	selected	True
24	Luxembourg	selected	True
25	Malaysia	selected	True
26	Mexico	selected	True
27	Netherlands	selected	True
28	New Zealand	selected	True
29	Norway	selected	True
30	Peru		False
31	Philippines	selected	True
32	Poland	selected	True
33	Russian Federation	selected	True
34	Saudi Arabia	selected	True
35	Scotland	selected	True
36	Singapore	selected	True
37	Spain		False
38	Sweden	selected	True
39	Switzerland	selected	True
40	Taiwan	selected	True
41	United Arab Emirates	selected	True
42	United States	selected	True
43	Venezuela		False
44
Sheet1

Cell Formulas
Range	Formula
C7:C43	C7	=IF([@groupCountries]="selected","True","False")

 

[Norie]

Is this Power BI or Power Query?

 

[detriez]

This is Power Query

I am trying to create a column and populate it with "True" if the [Country] is in my list and "False" if it is not

The group solution seemed to be elegant but, I'm not sure how to implement it

Here is the syntax I tried. It does not complain about syntax errors but, now I get Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly
I tried different variations of IF(OR( but was getting Token literal Expected on first instance of [Country]

=IF(OR([Country]="Australia", [Country]="Austria", [Country]="Belgium", [Country]= "Brazil", [Country]="Canada", [Country] = "Denmark", [Country]="Finland", [Country]="France", [Country]="Germany", [Country]="Indonesia", [Country]="Ireland", [Country]="Israel", [Country]="Japan", [Country]="Kuwait", [Country]="Luxembourg", [Country]="Malaysia", [Country]="Mexico", [Country]="Netherlands", [Country]="New Zealand", [Country]="Norway", [Country]="Philippines", [Country]="Poland", [Country]="Russian Federation", [Country]="Saudi Arabia", [Country]="Scotland", [Country]="Singapore", [Country]="Sweden", [Country]="Switzerland", [Country]="Taiwan", [Country]="United Arab Emirates", [Country]="United States"), "True", "False")

 

[Norie]

You should add a table with the list of countries and then take a look at List.Contains.

Let's say you have a table named Countries which has a column named Name, you could then use this.

=List.Contains(Countries[Name], Country)

 

[detriez]

Hey @Norie that worked and it allows for easy value additions or deletions.
Thanks all for the help