I am extracting data within a cell. 3 conditions apply
condition1 =MID(B2,FIND("condition1",B2)+28,(FIND(",",B2)-(FIND("condition1",B2)+28)))
condition2 =MID(B2,FIND("condition2",B2)+28,(FIND(",",B2)-(FIND("condition2",B2)+28)))
condition3 =MID(B2,FIND("condition3",B2)+28,(FIND(",",B2)-(FIND("condition3",B2)+28)))
This is my non-working if statement, but Excel keeps telling me I have entered too few arguments:
=if(MID(B2,FIND("condition1",MID(B2,FIND("condition1",B2)+28,(FIND(",",B2)-(FIND("condition1",B2)+28)))))),MID(B2,FIND("condition1",MID(B2,FIND("condition1",B2)+28,(FIND(",",B2)-(FIND("condition1",B2)+28))))),if(MID(B2,FIND("condition3",MID(B2,FIND("condition3",B2)+28,(FIND(",",B2)-(FIND("condition3",B2)+28)))))),MID(B2,FIND("condition3",MID(B2,FIND("condition3",B2)+28,(FIND(",",B2)-(FIND("condition3",B2)+28))))),IF(MID(B2,FIND("condition2",MID(B2,FIND("condition2",B2)+28,(FIND(",",B2)-(FIND("condition2",B2)+28)))))),MID(B2,FIND("condition2",MID(B2,FIND("condition2",B2)+28,(FIND(",",B2)-(FIND("condition2",B2)+28))))),"No data available")
I can't see the wood for the trees. Can someone help me? Thanks.
Bookmarks