best practice for multiple if conditions

[dickson30]

Hi hoping someone can help I've got multiple if statement which I would be fine writing in excel but struggling in powerquery (the below is not working expecting another then?!) would appreciate any help and what the best practice would be for the below and if anyone can make it work that would be great. Thank you.


= Table.AddColumn(#"Added Custom", "Custom",
each if [Adjust]="monkey"
then if[Pear]>0
then if[Banana]>0
then if [Apple]>0
then ([Banana]+[Pear]+[Apple])/3
else if [Apple Juice]<0
Then 0
else ([Pear]+[Banana])/2
else if [Apple]>0
then ([Pear]+[Apple])/2
else if [Banana Smoothie]>0
then [Pear]
else 0
else if [Banana]>0
Then if [Apple]>0
then if [pear juice]<0
then ([Banana]+[apple])/3
else [Banana]+[apple])/2
else if [pear juice]<0
then [Banana]/2
else [Banana]
else if [Apple]> 0
then if [Banana Smoothie]<0
then 0
else if [pear juice]<0
then [Apple]/2
else [Apple]
else 0
else 0)

 

[VBA Geek]

you have some then with capital T

 

[dickson30]

Thank you I re went through the code there was also a couple of other minor mistakes but got it running, so now I just wonder is there a better way to write the query?

 

[VBA Geek]

Thank you I re went through the code there was also a couple of other minor mistakes but got it running, so now I just wonder is there a better way to write the query?

It depends on your business logic, I have notices there are some ifs that can be grouped with 'and' conditions