Nested Formula

Occasional Visitor
 C1C2C3
R1YesYes1
R2YesNo2
R3NoYes4
R4No No5

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

@Pooja2100 

In R1C3:

 

=3*(RC1="No")+(RC2="No")+1

 

Or in A1 notation, in C1:

 

=3*(A1="No")+(B1="No")+1

 

Fill down