Converting Excel nested If/and statements to Power Query

Hi, I'm new to Power Queries and am having trouble converting a formula to work in Power Query.  I understand I use if/and/then/else, however I have created custom columns in my power query where a l...