IF Statements where multiple conditions exist

[JayB0730]

Hello,

I have the following data set:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]LOW POINT[/TD]
[TD]TEMP QTY[/TD]
[TD]ORDER QTY[/TD]
[TD]STATUS[/TD]
[TD]CURRENT QTY[/TD]
[TD]LOW?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2000[/TD]
[TD]0[/TD]
[TD]1000[/TD]
[TD]NOT COMPLETE[/TD]
[TD]500[/TD]
[TD]FORMULA???
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]500[/TD]
[TD]700[/TD]
[TD]1000[/TD]
[TD]NOT COMPLETE[/TD]
[TD]200[/TD]
[TD]FORMULA???
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]400[/TD]
[TD]0[/TD]
[TD]300[/TD]
[TD]COMPLETE[/TD]
[TD]200[/TD]
[TD]FORMULAS???
[/TD]
[/TR]
</tbody>[/TABLE]

1. If D2 = COMPLETE, Then I would like to check if E2 is <= A2. IF TRUE then "YES" otherwise "NO"; however,
2. If D2 is not COMPLETE, Then I would like to do the following:
2a. Not Complete AND B2>0 then I would like to check if the SUM of E2 + B2 <= A2. IF TRUE then "YES" otherwise "NO"; however,
2b. Not Complete AND B2=0 then I would like to check if the SUM of E2 + C2 <= A2. IF TRUE then "YES" otherwise "NO".

Trying to write one formula but I am confusing myself with the nested if statements. Any help is greatly appreciated!

TIA
Jay

 

[steve the fish]

Test this:

=IF(OR(AND(D2="Complete",E2 < =A2),AND(D2="Not Complete",B2>0,E2+B2 < =A2),AND(D2="Not Complete",B2=0,E2+C2 < =A2)),"YES","NO")

 

[JayB0730]

Steve,

Thank you so much. After seeing your solution, I was apparently over thinking this. Appreciate the help! Cheers!