IF fnct [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
How do I nest an IF function that is more than 8-deep, can i be given some techniques.

rubara

3 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
thank you very much