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 retu...
In R1C3:
=3*(RC1="No")+(RC2="No")+1
Or in A1 notation, in C1:
=3*(A1="No")+(B1="No")+1
Fill down