Perhaps a user defined function would provide the answer, this would allow
as many parameters as necessary and the VBA code would make checking and
changeing the conditional checking somewhat easier. However, I dont know if
there is a limit to the number of parameters that can be passed to the
function.

Just a thought

Peter

"Tom Ogilvy" wrote in message
...
You can't nest more than 7 if statements. Your conditions seem so
unrelated
that it would be difficult to suggest any alternatives.

--
Regards,
Tom Ogilvy

"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/