# IF fnct

Closed
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
How do I nest an IF function that is more than 8-deep, can i be given some techniques.

rubara

## 3 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
156
yes sure you can see below solution from mine ..... you can use upto 36 IF's and 37 conditions ....

you can paste this code in B3 and in A3 write alphabet from A-Z and numeric from 0-9 and try to write some special char and see the result in B3 ..... There are many ways to get the same result but i especially made this formula to know how of nested IF's ........

```B3=IF(OR(A3="a",A3="b",A3="c",A3="d",A3="e",A3="f",A3="g",A3="h"),IF(A3="a",1,IF(A3="b",2,IF(A3="c",3,IF(A3="d",4,IF(A3="e",5,IF(A3="f",6,IF(A3="g",7,8))))))),IF(OR(A3="i",A3="j",A3="k",A3="l",A3="m",A3="n",A3="o"),IF(A3="i",9,IF(A3="j",10,IF(A3="k",11,IF(A3="l",12,IF(A3="m",13,IF(A3="n",14,15)))))),IF(OR(A3="p",A3="q",A3="r",A3="s",A3="t",A3="u"),IF(A3="p",16,IF(A3="q",17,IF(A3="r",18,IF(A3="s",19,IF(A3="t",20,21))))),IF(OR(A3="v",A3="w",A3="x",A3="y",A3="z"),IF(A3="v",22,IF(A3="w",23,IF(A3="x",24,IF(A3="y",25,26)))),IF(OR(A3=1,A3=2,A3=3,A3=4),IF(A3=1,"N1",IF(A3=2,"N2",IF(A3=3,"N3","N4"))),IF(OR(A3=5,A3=6,A3=7),IF(A3=5,"N5",IF(A3=6,"N6","N7")),IF(OR(A3=8,A3=9),IF(A3=8,"N8","N9"),IF(A3=0,"Zero","Non of Single Alphabet / Single Numerics"))))))))
```

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
thank you very much