Help with conditional formula for greater/less than
 

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!

Help with conditional formula for greater/less than
 

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

"charlie" wrote:

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!

Help with conditional formula for greater/less than
 

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.

Help with conditional formula for greater/less than
 

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

"charlie" wrote:

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.