Nested Formula

[Pooja2100]

	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?

[#2]

@Pooja2100 

In R1C3:

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

Or in A1 notation, in C1:

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

Fill down