Help with conditional formula for greater/less than

[charlie]

I could use some help in constructing an IF formula that is based on
greater/less than. I have a COUNTA formula for a column of data. Based
on that result, I want to point to a different cell depending on the
result of the count.

For example, if the result is 0 or 1, I want to point to B21. If the
result is between 2-5, I want to point to B22.

Any help would be greatly appreciated!

 

[Jeff]

=if(counta(D1..D100)<3,B21,B22)

 

[charlie]

Sorry, I should have expanded a little. I have more than just the two
ranges that I need to reference (it's not just a simple either/or
result). For example, the next range result would be 6-10.

 

[Jeff]

If you have more than a few ranges, I'd suggest using a vlookup.