Token Else

[Milagros]

Hi there, I am trying to enter create a Custom Column in Power Query, but I am getting a 'Token else expected' error message.  When I select show error it takes me to the very end of the formula. The formula is meant to identify whether a result is on target, below target or within a set margin of the target. 

if [Target]= null or [Result]= null then null
else if [Polarity]="Higher is better" and [Result]>=[Target] then 1
else if "Higher is better" [Result]>=([Target]*0.95) then 0
else if "Higher is better" then -1
else if [Polarity]="Lower is better" and [Result]<=[Target] then 1 else if "Higher is better" [Result]<=([Target]*0.95) then 0
else if "Higher is better" then -1

[Jakinta · Accepted solution]

Your 3rd and 4th line of code are missing testing criteria.

[Milagros]

Hi Jakinta, many thanks, Kind regards,  Mila