HLP - Dynamic Range for Nested IF
 

I am trying to educate myself re dynamic ranges and understand how to
accomodate an expanding named range by using Offset, etc.

However, I am now trying to use dynamic ranges to nest more then the max
number of IFs. (I know I can do a lookup, but want to test what I have seen
suggested for the experience)

I have a Grades in B23 - B27, for example. I have a lookup table in, say,
A30 - B40, with column A containing the Grades (A, B, C, etc.) and column B
containing the corresponding % (A = 1%, B = 2%, etc.)

I want to create the first range to include the first 6 Ifs =
=IF(B23=A30,1%,if(B23=A31,B31, etc.

I would like to insert the "master" formula with the two named ranges in
cell E23, then copy it down to the rest of the cells (E24 - E27).

My problem is that the cell addresses get totally mixed up.

I am doing something wrong and/or not understanding this very well. Any
help or guidance to a site that explains the real basics of dynamic ranges.

Thanks!

--
Thanks!

Dee

HLP - Dynamic Range for Nested IF
 

one thing to try would be absolute references for the lookup table:
=IF(B23=$A$30,1%,if(B23=$A$31,$B$31, etc.

"dee" wrote:

I am trying to educate myself re dynamic ranges and understand how to
accomodate an expanding named range by using Offset, etc.

However, I am now trying to use dynamic ranges to nest more then the max
number of IFs. (I know I can do a lookup, but want to test what I have seen
suggested for the experience)

I have a Grades in B23 - B27, for example. I have a lookup table in, say,
A30 - B40, with column A containing the Grades (A, B, C, etc.) and column B
containing the corresponding % (A = 1%, B = 2%, etc.)

I want to create the first range to include the first 6 Ifs =
=IF(B23=A30,1%,if(B23=A31,B31, etc.

I would like to insert the "master" formula with the two named ranges in
cell E23, then copy it down to the rest of the cells (E24 - E27).

My problem is that the cell addresses get totally mixed up.

I am doing something wrong and/or not understanding this very well. Any
help or guidance to a site that explains the real basics of dynamic ranges.

Thanks!

--
Thanks!

Dee