IF Function Max 7 Condition

Excel allows up to seven levels of nested IF functions. The formula below works correctly, but Excel will not allow you to nest the IF functions any deeper than this. The alternate you can use the following function :

1. VLOOKUP
In many cases, you can avoid using IF functions and use a VLOOKUP function. This will require a separate table in your worksheet.

2. CONCATENATE function
Another option was suggested by B. Ganesh, use the CONCATENATE function. In this case, each argument for CONCATENATE consists of an IF function. Here's an example:
=CONCATENATE(IF(A1="A",1,""),IF(A1="B",2,""),IF(A1="C",3,""),IF(A1="D",4,""),IF(A1="E",5,""),IF(A1="F",6,""),IF(A1="G",7,"")),F(A1="H",8,""),IF(A1="I",9,""),IF(A1="J",10,""))

3. & Function,
Example : =(IF(A1="A",1,""),IF(A1="B",2,""),IF(A1="C",3,""),IF(A1="D",4,""),IF(A1="E",5,""),IF(A1="F",6,""),IF(A1="G",7,"")),& IF(A1="H",8,""),IF(A1="I",9,""),IF(A1="J",10,""))