Nested If's

[Lisa]

hi

I have a drop down list starting at column S2 that contains two values


Duplicate
Master

Depending on the selection, I want a message to appear in V2

I have this formula currently in V2...

=IF(AND(U2=A2,S2="Duplicate")," Master Account Cannot be a duplicate of
itself ", " ")

However, I want to add another part to this, ie

=IF(S2="Master"," Master Account Not req ", " ")

I've tried lots of different ways to turn both formulas into one, but
cannot seem to work it out


Thanks in advance

 

[Dave D-C]

I don't think there's an ELSE, so you have to nest:
=IF(AND(A1=A2,A3="Duplicate"),"One",IF(A3="Master","Two",""))