Multiple criteria IF THEN help

[dp2311]

It has been years since I've used Excel extensively and find myself struggling with a large dataset.

Desired formula:
If Column B = 0, Column C = "No"
If Column B>0 AND Column A = "Green", Column C = "Yes"
If Column B>0 AND Column A DOES NOT = "Green", Column C = Other Color

The Yes/No logic is simple but the third result is getting the better of me. Any help would be appreciated.

Attachment 785016

[alansidman]

=if(B1=0,"NO",if(and(B1>0,A1="Green"),"Yes","Other Color"))

[dp2311]

Thank you!