Hi everyone. It might be simple question for someone. Here's the first 5 rows of table:
<tbody>
</tbody>
Let's say that I want to use IF formula: value_if_true will be "success" if logical_test will meet condition A1=7 and B1=8 and C1=9, but if it's not true, I want excel to look up for next cell
I know all the way to use multiple conditions, and I know the way to check A2 B2 C2 if A1 B1 C1 not meet condition. But I want it to go to NEXT row, not just from A to B, as I have hundreds of rows (I just want to say that I can't write formula for each row A1 A2 A3 and etc.)
Hope you guys will understand my problem and help me to solve it
1 | 2 | 3 |
4 | 5 | 6 |
7 | 8 | 9 |
10 | 11 | 12 |
13 | 14 | 15 |
<tbody>
</tbody>
Let's say that I want to use IF formula: value_if_true will be "success" if logical_test will meet condition A1=7 and B1=8 and C1=9, but if it's not true, I want excel to look up for next cell
I know all the way to use multiple conditions, and I know the way to check A2 B2 C2 if A1 B1 C1 not meet condition. But I want it to go to NEXT row, not just from A to B, as I have hundreds of rows (I just want to say that I can't write formula for each row A1 A2 A3 and etc.)
Hope you guys will understand my problem and help me to solve it