If statement

[Guest]

I have 6 columns of yes and no answers I need to group the columns in two and
if both columns have a yes I need that statement to be true but I would like
to write the statement for all columns in one if statement is this possible?
Thank you

 

[Guest]

Probably possible, but certainly more detail is needed. Perhaps you could
paste in plain text here a few lines of sample data within the 6 cols (in
cols A to F ??) and what exactly you want to do in the adjacent col(s), say
in cols G, H (paste some corresponding sample outputs in these adjacent cols
for the data in cols A to F)