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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Less or Equal 3
Need help with formula for expressing multiple greater/less than 5
Use TODAY() function as the criteria in a SUMIF formula 1
Paste Link and Link Text From Browser to Word 0
Multiplying Values only less than 1.5 1
Drop down list control value in vba 2
Sumif number is greater than a number but less than another number 2
Conditional formatting for time 2

Top