i am writing a multiple criteria code for a table. its a bit over
complicated, but it should work fine. the following:

=(IF(D4="MIL-C-13931","X",IF(D4="ANSI Y14.5M","X",IF(D4="ANSI
Y14.5M-1982","X",IF(D4="B8769067","X",IF(D4="A7309999","X ",IF(D4="mil-l-3150","X",IF(D4="mil-g-10924","X",IF(D4="mil-c-46168","X"," ")))))))))

code works. It replaces the matching textx with an X. the following:

=(IF(D4="MIL-C-13931","X",IF(D4="ANSI Y14.5M","X",IF(D4="ANSI
Y14.5M-1982","X",IF(D4="B8769067","X",IF(D4="A7309999","X ",IF(D4="mil-l-3150","X",IF(D4="mil-g-10924","X",IF(D4="mil-c-46168","X",IF(D4="mil-c-13924","X","
")))))))))

does not work. The number of parenthesis at the end is not the problem,
because if i am missing one or have one too many excel just does it for me.
instead, i am getting an error message like my code is bad--yet i feel like i
haven't changed much about the code except added another IF. can anyone see
it?