Hello Jimmy J,

If you start nesting more than, I'd say, 3 IF functions, it's probably time
to look elsewhere for another solution. The limit may be 7, but there are
other simpler ways to do this. You have not provided enough information for
a working solution. If you would like one, please post more information as
for your requirements and details.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"jimmyJ" wrote in
message ...

Sorry if this is a repeat anywhere but I am stumped.
I am trying to create a simple IF Formula with 9 variables. My
objectives are to mark tests that require 9 codes per answer. They can
be inputed in any order. ( you can see why the IF function would be my
first choice.) I only require the outcome to be either , 1 or 0 as an
answer. Can anyone help me with a suitable solution. I am not even sure
which Function would best suit me at this point.

Thanks!


--
jimmyJ
------------------------------------------------------------------------
jimmyJ's Profile:
http://www.excelforum.com/member.php...o&userid=28307
View this thread: http://www.excelforum.com/showthread...hreadid=478809