I have this function in a particular cell;

=IF(D550,IF(AND(E18=1,D14<26),6,IF(AND(E17&E18="1 0",D14=26),"0",IF(E17=1,IF(D14<36.344,"0",IF(AND( D14=36.344,D14<39.549),1,2)),IF(D14<37.11,"0",IF( AND(D14=37.11,D14<39.174),3,4))))),0)

I need to add the following to it, and I can't figure out how to do it
without having 7 nested 'IF' statements;

=IF(AND(D14<36.344,E17=1),"0",IF(AND(D14<37.11,E17 =2),"0","X"))

In addition, is it possible to somehow merge the functions that require a
returned value of "0" with 'OR' statements so that I can minimize my nested
'IF' statements? I can't glean too much information from the 'help'
examples that is provided with Excel, or from the on-line help.

The reason that I have quotations around the zeros is because I need the
returned value of zero do display, and I have 'display zero values' turned
off for a particular reason.

Thank you in advance!