Thank you for you alternate solution.

JLatham wrote:
You've got a rather unique/special circumstance here, and I think this is the
solution
=IF(A4="",0,IF(ISERR(FIND(A4,"FDTSMLHGC")),"ERR", IF(FIND(A4,"FDTSMLHGC")<4,B4,C4)))

Mickey's right in stating that pre-2007, only 7 levels of nesting are
supported, but because in this setup you're only interested in evaluating the
contents of A4 and making the choice on that, and because 3 of those tests
result in a choice of B4, and 6 other results end with a choice of C4, we can
set it up as I've done above.

I am trying to make this IF statement work

[quoted text clipped - 3 lines]

.