LIMITS on =IF conditions in EXCEL 2007

[sm2200]

I wish to enter the conditional statement =IF(AND(A2=1,B2=1,C2=0,D2=1,E2=0,F2=0,G2=1,H2=0),1,0)

It tests 8 conditions at one time.

For Excel 2007 is this too many conditions.

Is there a maximum number of conditions or tests that may be used in an =IF statement such as the one above.

Thanks,

Sam Marx


If there is a question involving ACN following this, please disregard it.

 

[VoG]

That should work OK even in earlier versions of Excel.

 

[prajul89]

Don't know what is the limit for the condition in If statement.

But for you ACN problem do this instead ="ACN". I know this is not the actual solution you are looking for but still it works.