What was wrong with all the responses to your previous posts? There were
several suggested improvements shown.

Regards,
Fred

"Cerealkiller via OfficeKB.com" <u59737@uwe wrote in message
news:a77766d2786c2@uwe...
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"))))))
))))

--
Message posted via http://www.officekb.com