if statement with in a if in excel code example

Example: if statement on excel

Simple If statement: 

=IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2)