# Trying to add an or condition for the "Completed" status

Topic Labels: Formulas
536 2
cancel
Showing results for
Did you mean:
4 - Data Explorer
IF(
AND(
{State (from Government Body)} = 'Iowa',
{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(
{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.
2 Replies 2
4 - Data Explorer

I think I am closer but still not joy.

IF(
AND(
{State (from Government Body)} = 'Iowa',
{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(