There is indeed a limit to the number of arguments you can use in a cell.

Suggest you spread the formula over several columns. You will then need a
'results' column to analyse the various 'test' columns. Depending on your
requirement the output of test column A and C may be BAD and that of test
column B FINE. You will have to decide on what the actual output is of the
three results.

BTW it would be better if you reduced BAD and FINE to, say 0 (zero) and 1
(one). This could substantially reduce the size of a spreadsheet and
re-calculation.

Regards.

Bill Ridgeway
Computer Solutions
"darno " wrote in message
...
I am looking for a worksheet formula through which i should be able to
check more than 10 conditions with if(and(... as my requirement is to
check two cells, e.g. check if a3=10 and b3=7 then display in cell
address d3 "GOOD", else "OK". there are more than 10 conditions to be
checked. but i am unable to achieve all 11, i endup getting 7 correct
and rest it gives error in formula. May be excel do not allow us to
write more than 7 if(and(... formula. I am writing you the existing
formula which i have, but i am unable to add more conditions to it:

=IF(OR

(I20818;M20866;O20830;Q208240;S20890;U208800 );"FINE";IF(Y207="P";"good
";IF(AND(AC207=1;AC207<=7);IF(AC207=-AD207;IF(X208<1;"BAD");"BAD");"BAD"))
)

This was my existing formula, if i were to add more conditions it wont
work. Please help me out. The conditions are around 10, and i have
already told you few of those, please help me out.


Regards,


Darno


---
Message posted from http://www.ExcelForum.com/