Hi there

I hope you are well!

Following a recent previous post, I am trying to get a formula that will make a cell say yes or no depending on what value is selected in a range of drop down boxes.

I have attached a example spreadsheet with more information in. Please feel free to give it a go.

thanks

Mike

yes or no formula (updated) 3.xlsx