Well, "and so on..." implies that you have other conditions, so it
might be better to think about using a lookup table and a VLOOKUP
formula, but for just the values you have quoted in your example, you
can do this:

=IF(D1<=1,B21,IF(D1<=5,B22,IF(D1<=10,B23,"and so on...")))

Note that in XL2003 and earlier there is a limit of 8 in the number of
times you can put IFs together in this way - hence a table might be
needed if you have more.

Hope this helps.

Pete

On Jan 12, 4:57*pm, charlie wrote:
I am trying to construct a formula that will be based on the result of
an adjoining cell. I need to point to specific cell depending on what
the number is in that adjoining cell.

So for example:

If D1 = 0 or 1 - point to B21
If D1 = 2, 3, 4, or 5 - point to B22
If D1 = 6,7,8,9, or 10 - point to B23

and so on...

Rather than listing all of those variables, I know I should be able to
write it as equal to/greater than, but less than. I just don't know
how to express as a formula.

Thanks in advance for your help.