Hi Ron, Thank you for you help I also have these following statements that I
am having trouble with.
I have Excel 2000 so these problems are more than 7 levels is there a way to
make them shorter. I did make a vlookup for them but if I have to move the
cell then I have to re reference that vlookup so I figured a formula would be
easier if it is possible. Thank you for any help that you can provide.



=IF(E4="",0,IF((E4="F"),8,IF((E4="D"),4,IF((E4="T" ),2,IF((E4="S"),1,IF(
(E4="M"),0,IF((E4="L"),-1,IF((E4="H"),-2,IF((E4="G"),-4,IF((E4="C"),-8,"ERR"))
))))))))

=IF(E4="",0,IF((E4="F"),8,IF((E4="D"),4,IF((E4="T" ),2,IF((E4="S"),1,IF(
(E4="M"),0,IF((E4="L"),1,IF((E4="H"),2,IF((E4="G") ,4,IF((E4="C"),8,"ERR"))))))
))))


Ron Rosenfeld wrote:
I am trying to make this IF statement work

=IF(A4="",0,IF((A4="F"),B4,IF((A4="D"),B4,IF((A4 ="T"),B4,IF((A4="S"),C4,IF(
(A4="M"),C4,IF((A4="L"),C4,IF((A4="H"),C4,IF((A4 ="G"),C4,IF((A4="C"),C4,"ERR")
)))))))

It is helpful if you tell us what the problem is. Knowing that you apparently
cannot make this work is not very useful information when you don't tell us
either the version of Excel you are using, or what your function is doing
incorrectly.

Your formula, as written, does not have enough close parentheses at the end.

=IF(A4="",0,IF((A4="F"),B4,IF((A4="D"),B4,IF((A4= "T"),B4,IF((A4="S"),C4,IF(
(A4="M"),C4,IF((A4="L"),C4,IF((A4="H"),C4,IF((A4= "G"),C4,IF((A4="C"),C4,"ERR")
)))))))))

seems to work perfectly OK on my computer. But I am using Excel 2007 which is
not limited to seven levels of nesting as are earlier versions of Excel. Also,
Excel should have corrected your formula.

Could it be that you are using an earlier version? If so, you will be limited
to seven nesting levels. That being the case, your formula can be simplified:

=IF(A4="",0,IF(OR(A4={"F","D","T"}),B4,
IF(OR(A4={"S","M","L","H","G","C"}),C4,"ERR")))

But if there is some other problem that you are concerned with, you'll need to
provide more detail.
--ron