Forum Discussion
How to check if all cells in a non congruent range/list meet specific criteria. See below.
I am trying to use the following formula to see if 1. All 39 cells in row C have data, 2. All cell values are greater than 225, and 3. All cell values are less then 384. If all conditions are met, t...
Thanks Mathetes.
I thought about using a similar formula (e.g. IF(AND(C17>225,C19>225,...C17<384,C19<384,...),"PASS", "FAIL"), but I don't want to do this due to the number of cells (39).
I wish Microsoft would allow for non-congruent cells in their formulas, as I can't make mine congruent.
Appreciate your response!
I thought about using a similar formula (e.g. IF(AND(C17>225,C19>225,...C17<384,C19<384,...),"PASS", "FAIL"), but I don't want to do this due to the number of cells (39).
I wish Microsoft would allow for non-congruent cells in their formulas, as I can't make mine congruent.
Appreciate your response!
I wish Microsoft would allow for non-congruent cells in their formulas, as I can't make mine congruent.
But you can create a range elsewhere (we refer to such things as "helper columns") that takes all the values in those odd numbered cells and puts them into a single continuous array.