Excel: Multiple IF statemets

• ritesh.kansara

  SSChasing Mays

  Points: 654

  More actions

  September 6, 2011 at 5:22 am

  #242835

  I am trying to add multiple if statements and wanted to know the max number of statements.

  =IF(AND(H2<1000),"<1k",IF(AND(H2>=1000,H2<3000),"1-3K",IF(AND(H2>=3000,H2<5000),"3-5K",IF(AND(H2>=5000,H2<7500),"5-7.5K",IF(AND(H2>=7500,H2<10000),"7.5-10K",IF(AND(H2>=10000,H2<15000),"10-15K",IF(AND(H2>=15000,H2<20000),"15-20K")))))))

  When trying to add another If(AND( I get an error message

• kinderdesign

  Right there with Babe

  Points: 759

  More actions

  September 10, 2011 at 5:38 pm

  #1379650

  Unfortuntely, there is a limit of 7. I made a response in another form as to alternatives. See: http://www.excelforum.com/excel-worksheet-functions/637114-more-than-7-if-statements.html