Forum Discussion
Nested Formula
| C1 | C2 | C3 | |
| R1 | Yes | Yes | 1 |
| R2 | Yes | No | 2 |
| R3 | No | Yes | 4 |
| R4 | No | No | 5 |
I am looking to add a formula for the mentioned conditions in column & column 2 combined together to return the values in column 3. Can someone help me please?
1 Reply
In R1C3:
=3*(RC1="No")+(RC2="No")+1
Or in A1 notation, in C1:
=3*(A1="No")+(B1="No")+1
Fill down
