Nesting IF/OR Statement(s)

Paul Incitti 123

I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update:

When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty.

Is something like this possible? Or am I going about it in the wrong way.

I believe there is an error w/ the Empty section as it is being referenced multiple times. Do I move this to the end?

Here is what I have thus far:

=IF(OR(Status1 = "Complete", Status1 = "Received"), "Full", "Empty", IF(OR(Status1 = "In Process", Status1 = "Quoted"), "Quarter", "Empty", IF(OR(Status1 = "Dispatched", Status1 = "Ordered"), "Half", "Empty")))

Might I need to do individual nested IF statements?

Any suggestions or resolutions are welcome :)

Courtney S.

Hi! When you nest IF statements, you put each IF statement into the "else" (the 'if not') section of the earlier IF statement. In short, you only want to have the "Empty" in the end of the very final IF statement.

Instead of your stated logic: "When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty."

What you actually want is this logic: "If Status is Complete or Received list Full, otherwise if Status is In Process or Quoted list Quarter, otherwise if Status is Dispatched or Ordered list Half, otherwise list Empty."

So something like this:

=IF(OR(Status1 = "Complete", Status1 = "Received"), "Full", IF(OR(Status1 = "In Process", Status1 = "Quoted"), "Quarter", IF(OR(Status1 = "Dispatched", Status1 = "Ordered"), "Half", "Empty")))