Previous Topic Next Topic

IF fnct

Closed
rm - Jul 2, 2009 at 08:39 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 3, 2009 at 05:08 AM
Hello,
How do I nest an IF function that is more than 8-deep, can i be given some techniques.

rubara

3 responses

Answer 1 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 2, 2009 at 07:50 PM
see this refrence

https://www.excelforum.com/excel-formulas-and-functions/630156-ifs-against-vlookups.html?s=18a82df1cc1d9fe15f09de0a6f990055
0
Answer 2 / 3
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jul 2, 2009 at 10:59 PM
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"))))))))





0
Answer 3 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 3, 2009 at 05:08 AM
thank you very much
0