Sep 21 2021 02:30 AM
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?
Sep 21 2021 03:32 AM
In R1C3:
=3*(RC1="No")+(RC2="No")+1
Or in A1 notation, in C1:
=3*(A1="No")+(B1="No")+1
Fill down