Thread: Excel If Statement (Excel 2000/xp)

1. Excel If Statement (Excel 2000/xp)

I have noticed a number of times statements that you can only have 7 If statements. Here is a formula that allows many more by combining with OR. Many of you may be aware of it, but I thought I would pass it along. I cannot take create for this. I found it somewhere.

=IF(OR(B2="a",B2="b",B2="c",B2="d",B2="e",B2="f"), IF(B2="a",1,IF(B2="b",2,IF(B2="c",3,IF(B2="d",4,IF (B2="e",5,6))))),IF(OR(B2="g",B2="h",B2="i",B2="j" ,B2="k",B2="l"),IF(B2="g",7,IF(B2="h",8,IF(B2="i", 9,IF(B2="j",10,IF(B2="k",11,12))))),IF(OR(B2="m",B 2="n",B2="o",B2="p",B2="q",B2="r"),IF(B2="m",13,IF (B2="n",14,IF(B2="o",15,IF(B2="p",16,IF(B2="q",17, 18))))),IF(OR(B2="s",B2="t",B2="u",B2="v",B2="w"), IF(B2="s",19,IF(B2="t",20,IF(B2="u",21,IF(B2="v",2 2,23)))),IF(B2="x",24,IF(B2="y",25,IF(B2="z",26,"e rror - type a letter")))))))

2. Re: Excel If Statement (Excel 2000/xp)

Why would you want that many IF statements?

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•