If Formula looking at a number of cells to return a statement

Hi Everyone,

Newbie here,

I am trying to create an 'IF' formula that looks in specific cells to check that the data is equal to relevant characters in order to return 2 different statements. All Relevant cells would have to be specific in order to return the 'true statement'.

I am trying this but to no joy.

=IF(B6="Y"&B7="Y"&B8="Y"&B9="Y"&C8="Y"&D9="Y"&E8="Y"&E9="Y","Plan A","Plan B")

All of the specific cells must be Y in order to return Plan A. If one of them is an N then Plan B should be returned.

I hope someone can help!

Thanks in advance

Tyler

Man you are a wizard! . Thanks

Now what about if I wanted to apply an 'or' argument?
=IF(AND(B6="Y",AND OR B7="Y",AND OR B8="Y", AND OR B9="Y",C8="Y",D9="Y",E8="Y",E9="Y"),"Plan A","Plan B")

Thanks

Yes you are correct! Apologies I am new to Excel and have only just started with IF formula and Vllokups etc so sorry for the basic questions.

I now see that arguments need to be seperated by open and closed comma's which makes sense. Thaks you so much for your answers!