I need C1 to return one of four values depending on condition in A1:B1
IF A1=A and B1=B than C1=17
IF A1=A and B1=C than C1=20
IF A1=D and B1=B than C1=25
IF A1=D and B1=C than C1=28
What formula or code should I use?
Can anybody help. Thanks in advance.
IF A1=A and B1=B than C1=17
IF A1=A and B1=C than C1=20
IF A1=D and B1=B than C1=25
IF A1=D and B1=C than C1=28
What formula or code should I use?
Can anybody help. Thanks in advance.