Excel formula to return value based on certain criteria

[Ekguy41]

Hello,

I am using excel 2016 and trying to create ta formula that will return a certain value based on multiple criteria. I have set out the logic below but everything I try doesn’t work

if(and(a1=“Green”,a2<>”-“),”Good”,”Bad”
if(and(a1=“Amber”,a2<>”-“),”Good”,”Bad”
if(and(a1=“Red”,a2 <>”-“),,”Good”,”Bad”
if(and(a1=“-“,”-“),”Bad”
if(and(a1=“-“,a2<>”-“),”Bad”

any help or a better way to write the formula would be greatly appreciated. Been at this one for a couple of days.

 

[Fluff]

You're welcome & thanks for the feedback.