if statement with and logic

[Kurdapyo_pogi]

Kindly help how to convert the below excel formula to Power BI Power Query

IF((AND(B2>=0,B2<2)),"0-2 Weeks",IF((AND(B2>=2,BS<4)),"2-4 Weeks",IF((AND(B2>=4,B2<6)),"4-6 Weeks",IF((AND(B2>=6,B2<20)),"Others"))))

Note: B2 is the cell reference.

Thank you in advance!

[amitchandak · Accepted solution]

@Kurdapyo_pogi , Create a new column like

Switch( True(),
[B] < 2 ,"0-2 Weeks",
[B] < 4 ,"2-4 Weeks",
[B] < 6 ,"4-6 Weeks",
"Others")