Help with conditional formula for greater/less than

C

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!
 
C

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