Need a Formula

[Masterrmind]

I need to find the eligibility for sales person. I need a formula based on the below condition.

Condition:
1. If "D Amount" & "H Amount" both are >=0, then the final status will be "Eligible".
2. If "D Amount" & "H Amount" both are <0, and "D%" & "H%" both are <="Eligible%", Final Status will be "Eligible".
3. If "D Amount" & "H Amount" both are <0, and "D%" & "H%" both are >"Eligible%", Final Status will be "Not Eligible".
4. If any one of "D Amount" & "H Amount" is <0, and that criteria is also >"Eligible%", Final Status will be "Not Eligible".
5. If any one of "D Amount" & "H Amount" is <0, and that criteria is <="Eligible%", Final Status will be "Eligible".

All I need is to define "Final Status" with a formula.

Thanks.

 

[SunnyAlv]

like this ?

=IF(AND(D3>0,E3>0),"Eligible",
IF(AND(D3<0,E3<0,F3<H3,G3<H3),"Eligible",
IF(AND(D3<0,E3<0,F3>H3,G3>H3),"Not Eligible",
IF(AND(OR(D3<0,E3<0),OR(F3>H3,G3>H3)),"Not Eligible",
IF(AND(OR(D3<0,E3<0),OR(F3<H3,G3<H3)),"Eligible","")))))