IF will give allow you to have upto 8 conditions. If you have more then
Enter 0 in A21, 2 in A22 and 6 in A23
then use this formula
=VLOOKUP(D1,$A$21:$B$23,2,TRUE)
You can enter more values A23... down and extend the range in the formula
accordingly

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