IF Statements where multiple conditions exist

JayB0730

Board Regular
Joined
Oct 22, 2014
Messages
64
Hello,

I have the following data set:

ABCDEF
1LOW POINTTEMP QTYORDER QTYSTATUSCURRENT QTYLOW?
2200001000NOT COMPLETE500FORMULA???
35007001000NOT COMPLETE200FORMULA???
44000300COMPLETE200FORMULAS???

<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
Joined
Oct 20, 2009
Messages
8,403
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Oct 22, 2014
Messages
64
Steve,

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

Watch MrExcel Video

Forum statistics

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

Which adblocker are you using?

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
Top