IF fnct
Closed
Report
rm

venkat1926
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
3 replies
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
mubashir aziz
 Posts
 190
 Registration date
 Sunday April 12, 2009
 Status
 Member
 Last seen
 February 16, 2010
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 AZ and numeric from 09 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 ........
you can paste this code in B3 and in A3 write alphabet from AZ and numeric from 09 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"))))))))