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