IF formula with multiple conditions in Power Query Editor

[Anonymous]

I have my Data Sample as shown in the picture 

Sample Data

I want to create a custom column in Power Query Editor which pulls the weight as per the conditions: 

All weights should be in Lbs(Pounds) (1 Oz = 0.0625 Lbs)

If Execution Status = Closed Use Gross Weight(Delivery Item)

If Execution Status = Cancelled Use Gross Weight(Sales Document Item)

I tried to create two different columns one for Oz and one for Lbs as per below M Language

Gross Weight(Oz) = if [#"Weight Unit (Sales Document Item)"] = "Oz (Ounce)" and [Execution status] = "Closed" then Value.Multiply([#"Gross weight (Delivery Item)"],0.0625) else if [#"Weight Unit (Sales Document Item)"] = "Oz (Ounce)" and [Execution status] = "Cancelled" then Value.Multiply([#"Gross weight (Sales Document Item)"],0.0625) 

But the above shows me an error

and a similar one without the weight conversion for Lbs.

Is there a better way where I can have everything in one Column 

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as a solution?

Best Regards,
Dale

[Greg_Deckler]

Can you post your error?

[Anonymous]

@Greg_Deckler If I click on Show error it points to the end of the formula

[Greg_Deckler · Accepted solution]

OK, I tried out a sample formula and this worked:

= if [profilepercent] = .2 and [userid] = 2 then 1 else if [profilepercent] = .3 and [userid] = 2 then 2 else 3

Looks like you are missing an "else" at the end of your statement. So you have:

if then else if then

You need it to be:

if then else if then else