# IF Statements where multiple conditions exist

#### JayB0730

##### Board Regular
Hello,

I have the following data set:

 A B C D E F 1 LOW POINT TEMP QTY ORDER QTY STATUS CURRENT QTY LOW? 2 2000 0 1000 NOT COMPLETE 500 FORMULA??? 3 500 700 1000 NOT COMPLETE 200 FORMULA??? 4 400 0 300 COMPLETE 200 FORMULAS???

<tbody>
</tbody>

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

### Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

#### steve the fish

##### Well-known Member
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

##### Board Regular
Steve,

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

Replies
8
Views
127
Replies
3
Views
149
Replies
1
Views
94
Replies
0
Views
63
Replies
0
Views
65

Threads
1,130,271
Messages
5,641,233
Members
417,202
Latest member
AndyVBA

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back