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