Here's my functional formula
=IF(OR(O13=1,O14=1,O15=1,O16=1,O17=1,O18=1),"Need to answer all
statements",IF(AND(O13=2,O14=2,O15=2,O16=2,O17=2,O 18=2),2,IF(OR(O13=3,O14=3,O15=3),"3",IF(AND(O13=2, O14=2,O15=2,(SUM(O16:O18))=7),2,IF(AND(O13=2,O14=2 ,O15=2,(SUM(O16:O18))=8),"Btw
Red & Grn",IF(AND(O13=2,O14=2,O15=2,(SUM(O16:O18))=9),"B tw Red & Grn","not an
ans"))))))

and it return the results I want, but I needed one more condition and it
gives me the "formula contains errors" message. I just want to add the
following that works on it's own....

IF((AND(O13=1,O14=1,O15=1,O16=1,O17=1,O18=1)),1,

so is there a limit to how many true statements you can have?

Thanks