8th function on an IF(AND(

[jonathanrams]

Hello,

I have the following function but I need to add an 8th argument...

=IF(AND(C4="B",H4="S"),"CONTRA",IF(AND(C4="B",H4="ss"),"CONTRA",IF(AND(C4="b",H4="cs"),"Both BUYS",IF(AND(C4="cS",H4="SS"),"contra",IF(AND(C4="cS",H4="B"),"BOTH BUYS",IF(AND(C4="CS",H4="CS"),"SAME",IF(AND(C4="B",H4="b"),"SAME","-->")))))))

IS THERE ANYWAY??? PLEASE HELP. THANKS IN ADVANCE.

[dominicb]

Good afternoon jonathonrams

IS THERE ANYWAY???

Yes, you could buy Office 12 - that doesn't have the limitation

Seriously, though, Chip Pearson has a workaround here that works satisfactorily.

HTH

DominicB

[NBVC]

What's the 8th argument?

[jonathanrams]

=(if(and(c5="ss",h5="cs"),"contra","same"))

[ChemistB]

Not knowing what your 8th argument is, I can't complete it for you but you can simplify somewhat using the OR statement and C4=H4 for "Same" like so

Please Login or Register  to view this content.

ChemistB

[NBVC]

=(if(and(c5="ss",h5="cs"),"contra","same"))

Try:

Please Login or Register  to view this content.