Need Help on Multiple IF Statement

**NYC4LIFE** · 06-19-2013, 09:50 AM

can anyone tell me what's wrong with this formula? It doesnt work.

=IF(MID(D2,10,1)="-",1,IF(MID(F2,10,1)="-",2,IF(MID(H2,10,1)="-",3,IF(MID(I2,10,1)="-",4,IF(MID(J2,10,1)="-",5,IF(MID(L2,10,1)="-",6,IF(MID(BR2,10,1)="-",7,IF(MID(BS2,10,1)="-",8,IF(MID(BJ2,10,1)="-",9,IF(MID(BW2,10,1)="-",10,IF(MID(BY2,10,1)="-",11,IF(MID(CB2,10,1)="-",12,IF(MID(CF2,10,1)="-",13,IF(MID(CY2,10,1)="-",14,IF(MID(DA2,10,1)="-",15,IF(MID(DB2,10,1)="-",16,"No Match"))))))))))))))))

**GeneralDisarray** · 06-19-2013, 09:57 AM

If you are needing to nest this many together, then you should consider another option. Can you upload an example of what you are trying to do?

Which version of excel are you using?

edit:

reference for maximum number of IF statements:

http://www.mrexcel.com/forum/excel-q...s-allowed.html

Some ideas to avoid nested if statements:

http://www.excelhero.com/blog/2010/01/i-heart-if.html

**NYC4LIFE** · 06-19-2013, 10:06 AM

excel 2010. I attached a sample file. the formula is in cell B2

**GeneralDisarray** · 06-19-2013, 04:35 PM

Ok, this is what you sent.

When i opened it, cell B2 was showing the formula instead of the result, because there was a space in front of the "=" sign. But after i removed that, it seems to work.

I removed values from cells (D2, F2, etc..) and the result in B2 changed as it appears you meant it to.

Does the sheet i attached work?