Nested IF AND Statement

[Admin_Expert]

I need to populate a field with a value based on three conditions:

1. Checkbox Field “Current Edits Complete” = 1
   or
2. Checkbox Field “No Changes Suggested” = 1
   AND
3. Checkbox Field “Content Implemented” = 0

So, if Edits are complete or No Changes Suggested are checked - BUT - Contentent Implemented must be empty, I want to bring back the {Editor copy}, otherwise I want the cell blank.

Here is what I have built, but it doesn’t grab the records where No Changes Suggested is selected.

IF({Current Edits Complete}=1,IF({Content Implemented}=1,"",IF(OR({No Changes Suggested}=1,{Current Edits Complete}=1),{Editor copy})))

Thoughts???

[Chris_Guthrie · Accepted solution]

@Admin_Expert I think this is what you’re looking for here

IF(AND({Content Implemented}=0,OR( {Current Edits Complete}=1, {No Changes Suggested}=1)),{Copy Editor})

[Admin_Expert]

Chris_Guthrie:

IF(AND({Content Implemented}=0,OR( {Current Edits Complete}=1, {No Changes Suggested}=1)),{Copy Editor})

PERFECT!!! Thank you!

[Chris_Guthrie]

No problem. Feel free to reach out if you need any other help!