I have an if and formula =IF((AND(A2>=32, B2>=32)), "Y", "N")
I want to expand on this.
In the test document linked the if and formula is in reference to the first two columns. I would also like this if and formula to look through the range C2:N2 and return Y if five or more numbers are >=32 and N if not. so the whole formula returns Y if A2>=32 and B2>=32 and if 5 or more out of C2:N2>=32. (if that makes sense).
The formula needs to be in O2
Thanks in advance
Jon
Bookmarks