convert Excel Formula If statement into Power Query

[Sian1]

Hi, could someone please help to convert excel if statement formula to Power Query

=IF(AND(BF2<>"",BG2<>""),"Issued/Booked",IF(AND(BN2="",BK2<>"PO Direct"),"Not Released",IF(AND(BQ2="",BK2="PO Direct"),"Not Released",IF(AND(CC2="Rejected",S2="NP Practice - Rejected",BO2>BR2),"Rejected by NPP",IF(OR(CC2="Rejected",CC2="Rejected - Pending Acceptance"),"Rejected by NP",IF(CC2="New - Pending Acceptance","Released to NP",IF(CC2="New - New Pending Client / Broker Review","Pending",IF(AND(R2="New-Working",S2="NP Practice - Rejected"),"Rejected",IF(AND(R2="New-Working",S2="NP Practice - Accepted"),"Released to NP",IF(AND(R2="New-Working",OR(S2="NP Practice - Pending",S2="NP Practice - Completed")),"Released to NPP",IF(OR(R2="Open-Released",R2="Open-Corrected"),"Released to Booking",IF(OR(R2="Open-Released/Pending Info",R2="Open-Corrected/Pending Info"),"Pending",IF(R2="Open-Rejected","Rejected",IF(R2="Open-Accepted","Accepted Booking",IF(R2="Open-LclBooked","Booked, Unissued",0)))))))))))))))

 

[GraH]

Wow, ... I would suggest to make a mapping table. Then use a merge table on multiple columns. Expand the result column.

Basically one could add a conditional column in PQ and make this headache formula.
Syntax is if then else, and/or as key words.

 

[Sian1]

hahaha, i know right.
I tried to use the Syntax like you said if then else with and/or and no syntax detect error message
however the results didn't come to what expectation however excel does so i don't know what i have done wrong

 

[alansidman]

In PQ, the syntax is If-->then else if-->then else if-->then...............else but that makes for a long convoluted statement. As G indicated, you may be better off doing some mapping. If you upload your file to a third party site and provide a detailed description of what you are trying to do, it may be more beneficial than trying to reverse engineer a long convoluted if then statement.