Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •