Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested If's
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested If's
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If's | Excel Worksheet Functions | |||
Nested IF's | Excel Programming | |||
Nested if's in vba | Excel Programming | |||
How many nested IF's??? | Excel Discussion (Misc queries) | |||
NESTED IF's too many | Excel Programming |