Power query 'Token Else Expected' error

Hi MichaelK27 ,

There isn't else part in the end of the formula. For each if statement, there should be then and else.

If the [#"Weight (kg)"] <=0, what result do you want, directly add the result in the else part in the end.

Or based on the condition in your Excel formula:

This is my Excel formula:

=IF(V2="";"";IF(V2>200;CEILING(V2;50);IF(V2>100;CEILING(V2;20);IF(V2>=30;CEILING(V2;10);CEILING(V2;5)))))

---

I write a corresponding code:

if [#"Weight (kg)"]="" then "" else
if [#"Weight (kg)"] > 200 then Number.RoundUp([#"Weight (kg)"]/50,0)*50 else
if [#"Weight (kg)"] > 100 then Number.RoundUp([#"Weight (kg)"]/20,0)*20 else
if [#"Weight (kg)"] > 30 then Number.RoundUp([#"Weight (kg)"]/10,0)*10 else
 Number.RoundUp([#"Weight (kg)"]/5,0)*5

Best Regards,
Community Support Team _ kalyj

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