I disagree.

So far, you haven't catered for all possibilities if D2="NO". Under that, you've provided for:
• B2>$H$1
• B2<H$1,E2=0
but what about:


• B2=$H$1
• B2<H$1,E2<>0
Likewise for D2="YES", you've provided for:
• B2>=$H$1,E2>=$H$1
• B2<$H$1,E2>=$H$1
• B2<$H$1,E2<$H$1
but what about:
• B2>=$H$1,E2<$H$1
You also haven't catered for D2="".

Your latest formula can be simplified to:
the ',""' parts are where you need to sort out the rules for the missing conditions.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]