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

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dawnvz32" wrote:
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