IF(
AND(
{State (from Government Body)} = 'Iowa',
{Public Records Received (Yes/No)}= 'No',
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 50
),
"Delinquent",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Complaint Submitted to Iowa Public Information Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 60,
"Government Body Failure"
)
)
)
),
IF(
OR(
{Public Records Received (Yes/No)},
{Page Count} = 0;
"Completed"
)
)
)
I am teaching myself and/or conditions for a status formula and I am requesting assistance with adding an or condition to the "Completed" section of the code. The rest functions as desired.