Make this formula take more than three if statements

[Excel43]

I have a pretty complex formula and I would need it to take more than three if statements. Right now it it says: If first condition is met, "use this if" if true, and "use this if" if false. I need to chain 9 different ifs. So basically I need it to say "If first condition is met (this is one if) AND This or This or This (8 if statements. If first is not correct, then check next, then next and so on).

Is this possible to do? Here is my formula:

=INDEX(Vikta;SMALL(IF(Vikta[Grupp]=I3;IF(Vikta[Grupper]=1;ROW(Vikta)-4);IF(Vikta[Grupper]=2;ROW(Vikta)-4));ROW($1:$1));27)

 

[JustynaMK]

As you are working with Office 365 you should be able to use IFS function - this should help you with checking multiple conditions.

IFS function

 

[Excel43]

Thanks, you where right. I solved it with IFS. Final solution:

=IFERROR(INDEX(Vikta;SMALL(IF(Vikta[Grupp]=I3;IFS(Vikta[Grupper]=1;ROW(Vikta)-4;Vikta[Grupper]=2;ROW(Vikta)-4;Vikta[Grupper]=3;ROW(Vikta)-4;Vikta[Grupper]=4;ROW(Vikta)-4;Vikta[Grupper]=5;ROW(Vikta)-4;Vikta[Grupper]=6;ROW(Vikta)-4;Vikta[Grupper]=7;ROW(Vikta)-4;Vikta[Grupper]=8;ROW(Vikta)-4));ROW($1:$1));27);"")

 

[JustynaMK]

Awesome, glad it worked for you!