By default range names are refenced as absolute cell references, so when you
copy a formula w/a named range you get the same range referenced each time it
was copied. So that's where the problem lies.

In reading your post I'm not sure why you wouldn't use just a regular
relative cell address as named ranges are usually used as unique identifiers.
--
Kevin Backmann


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