You could have a column for each criterion, with a "Y" or "N"
response. Then you can just use COUNTIF to add the Y's to give you an
overall "score" - is this the kind of thing you mean?

=COUNTIF(B2:M2,"Y")

If there is a grading scale for some of the criteria, then you could
use SUM instead, and allocate numbers for the Yes/No answers and for
the scales.

Hope this helps.

Pete

On Nov 13, 10:00 pm, SGT Buckeye wrote:
I have a worksheet that has 51 rows (one row per Soldier) including a
header row. The columns contain different variables which will
determine whether each Soldier is eligible for promotion. EX: did
Soldier qualify with primary weapon, pas the APFT, meet height/weight
standards, etc. My problem is there are more than 7 nested functions
that are necessary to complete the formula. So I decided to use named
ranges and broke the formula down into two pieces and input a new
formula similar to this:

=if(namedFormula1, namedFormula1, namedFormula2)

This worked great for the first cell (AC2) but it did not work for
each subsequent cell when I dragged the formula down. How can I make
this work? I have it working in Excel 2007 because I can nest more
functions however most of the people who will use this are still using
Excel 2003. I appreciate any help. Thanks.