ExcelBanter - Nested If's

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Nested If's (https://www.excelbanter.com/excel-programming/404776-nested-ifs.html)

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

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

Lisa wrote:
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