Power Query Literal Token Expected

[Austen229022]

I am trying to set up a simple IF AND statement to check within ranges to the provide a range category, though I am having an issue with a Literal Token Expected error on something that shouldnt be an error.

Provided is an image below to show exactly where the issue is

Can anyone help with this?

[Ahmedx]

pls try this

 = if [Assessment to Decision] <= 2 then "0 - 2 Working Days" 
else if [Assessment to Decision] <= 5 then "3-5 Working Days" 
else if [Assessment to Decision] <= 15 then "5 - 15 Working Days" 
else "15+ Working Days"

[Ritaf1983]

Hi @Austen229022 
When you writing and/ or statements in PQ
You need to repeat a column name: 
if a>5 and a<9...

not
if a>5 and <9

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak · Accepted solution]

@Austen229022 , Problem in row Two and 3

You are using  [Column] >2 and <= 5

You need to use

[Column] >2 and [Column] <=5